Customer experience | Sales, Customer Insights,...

Replace standard buttons on subgrid with modern command and add visibility rule

(3) Share

Report

Posted on by MacG

We are using quotes entity and have a related custom entity with sub grid visible to this entity on quote form.

We want to replace the standard "New" button in subgrid to open a custom page and add data in the related entity with a modern command "New" button, and show/ hide this button based on a field in quote record.

Unfortunately all blogs etc. are showing only how you can show/ hide buttons on the main grid/ main form, with conditions based on field values, but for this always a record must be selected/ opened.

Is there a way to have a visibility rule for subgrid? Something like: if field in quote abc_example = "Visible" than show "New" command in subgrid, else not.

We've tried everything, the enable rules (via command checker) always shows "false", so it seems that Self.Selected.Item... doesn't work for subgrid.

Any ideas? Ribbon Workbench could be a solution, but if there's a way to sue modern commands we would prefer this.

Thanks for any hints.

All responses (6)

Answers (0)

MacG 22 on at

Like (0)

Report

Replace standard buttons on subgrid with modern command and add visibility rule

**Push**

Unfortunately it's still not answered, issue remains.

Is there really nobody who tried this and has an idea how to do it without ribbon workbench?

Every blog/ video to be found on the internet is always showing "commanding" in the main form and not in sub-grids, also MS links provided in below posts.

Anything that lead into the right direction would be highly appreciated.

Thanks.
VaHiX 3,119 on at

Like (2)

Report

Replace standard buttons on subgrid with modern command and add visibility rule

** Please don't forget to close up the thread here by Like and verify it as an answer if it was solved **
MacG 22 on at

Like (0)

Report

Replace standard buttons on subgrid with modern command and add visibility rule

Unfortunately this is not working (as expected).

If you add - as an example - the oob relation between Quote and Order (salesorder table) and add a modern command to the subgrid view of the order table (create new), everything is fine. New command is showing (without visibility rule).

But trying to add also a visibility rule to this command, based on a value from the appropriate quote record (in this case its "parent"), leads to that the new command is always "hidden" (checked this also with the command checker/ "ribbon debug", but you can't figure out why the visibility rule always defaults to "false"). It seems that the check based on a "parent record value" is either basically not supported or I'm doing something wrong.

I also can't find any documentations regarding this use case and every blog/ video to be found on the internet is always only showing the commands in the record itself.

The idea using this approach is to "connect" the new comand with a custom page, I used this approach several times since this is the easiest way to implement custom logic as this isn't really working in oob "quick creates" for us.

Any additional ideas?
Suggested answer

JeroenS 46 on at

Like (0)

Report

Replace standard buttons on subgrid with modern command and add visibility rule

Should you not be able to do this when following the next steps:

- Open the app in App Designed and Edit

- Select the right page

- Select Edit Command Bar

- Select the Subgrid view

- make you changes using the Visible property?

Create or edit modern commands - Training | Microsoft Learn
MacG 22 on at

Like (0)

Report

Replace standard buttons on subgrid with modern command and add visibility rule

Hi VaHiX, thanks for the hint.

I already found this article, but it requires ribbon workbench and we want to use the modern commands whereever possible.

Also in this article from MS learn - Command designer overview - Power Apps | Microsoft Learn (section https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/command-designer-overview#classic-versus-modern-visibility-rule-comparison) there seems to be an option available that is what I think we need.

Reference the control context for primary and related tables EntityRule PrimaryEntity. SelectedEntity Self.Selected

I tried this with several adjustments but without success. This shouldn't actually be an unusual requirement.

Any ideas?

Thanks.
VaHiX 3,119 on at

Like (2)

Report

Replace standard buttons on subgrid with modern command and add visibility rule

I think this article is a great start point

Hide Add Button on a Subgrid by Applying Custom JavaScript Rule - Microsoft Dynamics 365 CRM Tips and Tricks (inogic.com)