Hello! In d365, is it possible to update a column in a view with subgrid items dynamically - i.e. items added or removed from subgrid?
In Account, I have a subgrid showing related categories that could have items added or removed at any point in time. I created a Power Automate flow to update a column in account to show a comma delimited list of these items (purpose is to show the list of items in a view), but the trigger is on create/update of Account. Is there a way to trigger from the relationship? Or would I have to schedule it to run periodically on account to check for new items?
Curious to see if others have done this and how. Thanks!
Hi @JEM123
the account form doesn’t know there is an update, so it won’t be triggered to refresh. I can think of two ways realize this
1. do some JavaScript that updates the sub grid every x seconds.
2. Update the categories with an embeded power app on the account form. From the power app you can call a form refresh
both options will show some refresh delays I think.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.