Microsoft Dynamics 365 | Integration, Dataverse...

Update parent row with a message if there are no related rows in the subgrid

(0) Share

Report

Posted on by dsammied

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?

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report

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:

Count Total Subgrid Records in Dynamics CRM using JavaScript – Passion Dynamics (passion4dynamics.com)

Or you can create a rollup field to count related reords:

Count the number of related child records using a Rollup field – Passion Dynamics (passion4dynamics.com)

Was this reply helpful? Yes No
dsammied on at

Like (0)

Report

Thank you, using the notifications needs to be easier! rather than writing JS and web resource - I'm not an expert at JS and find writing a web resource takes quite a long time for me.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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)

Was this reply helpful? Yes No