Hi, has anyone used power automate, cloud flows to check the number of rows in a subgrid, so check there are a number of child rows, and if there is less than one, the put a message on the parent row to say 'You need to add a ... (related row)'
If I get the 'list of rows' using power automate and a get the number of those rows with the expression: length(outputs('List_rows')?['body/value']), how could I then put a message, like a warning on the parent row?
Hi dsammied,
If you don't want to write js code, you can refer following link to download Alerts4Dynamics app:
Alerts-Notifications Dynamics 365-Alerts4Dynamics (microsoft.com)
Hi dsammied,
You can create a new text field in parent entity, then use 'Update a row' action to update the field with the message.
https://docs.microsoft.com/en-us/power-automate/dataverse/update
But it's impossible to achieve it through power automate if you want to show alert message in the form, just like following screenshot:
You need use setFormNotification() function in js code:
setFormNotification (Client API reference) in model-driven apps - Power Apps | Microsoft Docs
Count related records through is:
Or you can create a rollup field to count related reords:
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,399
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
