Unanswered

If Field of existing Row is modified then (Dataverse)

(0) Share

Report

Posted on by EStegemann

Hi all,

I´m about to go crazy 😂. From the beginning. I created a flow that is triggered by a dataverse table when a row is added.

It updates some additional Fields and sends an email to a certain approver. This issue comes with the next steps.

When the first approver approves, i want to trigger the second part of the flow to send an email to the next approver.

For that the flow needs to check if a certain field of a certain row ID is modified. For this i used a second dataverse trigger "when a row is modified". Now i struggle how to select/filter that specific item (that have been approved from the 1st approver) and how i can check if the approval status 1 have been set to approved or rejected.

Many thanks,

Eric

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello @EStegemann ,
as per my understanding based on your requirement, you don't need another flow, after the first approval action, you should add a Dataverse "Get row by ID" looking to the same row created from the Trigger, then add a Condition to check the status.

Let me know.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
EStegemann 22 on at

Like (0)

Report
Copy link

Link copied!

Hi Marco,

thanks for your feedback. I already tried to use get row by ID, but the issue is that the flow runs straight through before i can change the approval status. Therefore i need a kind of action/trigger that the condition check should only take place when the approver 1 Status changed. Like (wait until approver 1 status is modified, that check status. If approved then email to approver 2, if rejected then email to requester)

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@EStegemann ,
so you need to run a child flow that updates the row, then your flow can continue to follow the process.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
BR,
Marco

Was this reply helpful? Yes No
EStegemann 22 on at

Like (0)

Report
Copy link

Link copied!

Thanks Marco. Is there any other option i can use as i haven't worked before with child flows.
Can i trigger the second approval step through power apps? I´m asking, because each of the item approver (6 Approver per Item) need to go into power apps to set the approval. Can i use this to trigger further flows? If so, any advice how to do it?

Many thanks,
Eric

Was this reply helpful? Yes No