I have a Calculated Field that takes the value from another field from a related entity. This field is a Choice field. The field name is Approval Status and it has 2 options - Approved & Rejected. My Calculated Field name is also the same, and it will take whatever value this field will have.
My Flow condition is - If Approval Status is equal to Rejected
The resultant action should be - Change the Status of the Record to Inactive
However, looks like the Calculated Field is not working for the condition as my Flow is not running at all. Could it be because the value in a Calculated field is real-time? If so, how should I set this condition?
This is a snapshot of my flow...
Your flow comparison should refer to Approval Status Value not Approval Status
Use a compose action before the condition to see what value does your Field (on the left of your compare action) return
Thank you for your response. I used the Compose function, still my flow is not running. I dont see any Approval Status Value field in my dynamic content too. This is how my flow looks...
Can you please include a screenshot of the flow run page by clicking on the flow instance?
I see that you have a Dataverse trigger, can you update a Dataverse record and run the flow to investigate what's going on? The calculated field has nothing to do with your flow not running.
Perhaps you are updating the wrong table which isn't meeting the flow trigger condition
Wow you are right, since this is a Calculated field and runs in real-time, I should have used the original field on the related entity in my trigger. In my case the entity record I want to modify is called 'Grant Applications' & the related entity is called 'Reviews'. The calculated field in the Grant Application entity is taking its value from the field with the same name in the Reviews entity. So I modified my trigger with Review entity, and gave the same condition, but when I'm trying to add my conditional action under 'Yes' & 'No', I'm not able to select the Row Id of Grant Applications dynamically. All the values and fields appearing are from the trigger entity. Here are some snapshots...
Since my trigger started with the Related entity, I guess the conditional action too needs input from the related entity. So is there anyway by which I can update my Grant Applications entity record inspite of the trigger having the Review entity?
I have figured out the issue. By using List Rows action before Update a Row, we can use the related entity row Id and fields in the Update a Row action.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!