cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerUser06
Helper I
Helper I

Calculated Field Not Working in Flow Condition

 

Hi,

 

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...

 

PowerUser06_1-1663720995441.png

 

Thanks!

7 REPLIES 7
SudeepGhatakNZ
Resident Rockstar
Resident Rockstar

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

If my suggestion helped you, please give it a Thumbs up and mark it as a Solution so that it can benefit others in the community.

@SudeepGhatakNZ 

 

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...

 

PowerUser06_1-1663730366603.png

 

 

 

SudeepGhatakNZ
Resident Rockstar
Resident Rockstar

Can you please include a screenshot of the flow run page by clicking on the flow instance?

SudeepGhatakNZ_0-1663730360134.png

 

If my suggestion helped you, please give it a Thumbs up and mark it as a Solution so that it can benefit others in the community.

My flow dint run, so there is nothing in the flow history section...

 

PowerUser06_0-1663732037177.png

 

SudeepGhatakNZ
Resident Rockstar
Resident Rockstar

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

If my suggestion helped you, please give it a Thumbs up and mark it as a Solution so that it can benefit others in the community.

@SudeepGhatakNZ 

 

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...

PowerUser06_3-1663778472004.pngPowerUser06_4-1663778490347.pngPowerUser06_5-1663778511668.png

 

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?

PowerUser06
Helper I
Helper I

@SudeepGhatakNZ 

 

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.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,321)