Showing False in the if condition even though drop down column value exists

(0) Share

Report

Posted on by sudheermadduru

Hi,

I have a sharepoint column called 'Region' of type Choice.

So if user select Europe under Region column,an email alert should be triggered to the mentioned user.

For this,I have user template of Start approval when a new item is added

In this I have added if condition,in the condition have set as 'Region is equal to Europe'.

In the advanced mode it is showing as @equals(triggerBody()?['Region'], 'Europe')

Email action has been set in the yes block of if condition

But when user is selecting Europe under Region column,it is not triggering an email.

In the flow history,under if condition it has been displayed as false under Expression result of if condition.

Please let me know if I am making any mistake here as I am newly using MS flows.

Regards,

Sudheer

Categories:

General topics

All responses (6)

Answers (1)

Sort by

ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you post a screen shot of your Flow? That may help shed some light on the root cause of your issue.
sudheermadduru 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry,

I am not able to find the suitable option to upload the screen shot.
Please help me on this.

Regards,
Sudheer
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

One way would be to open any of the Office desktop apps and go to the insert ribbon. Then select screenshot/screen clipping. Then select just that part of the screen that you want to capture.

After you capture the image, right click of it in the Office app and select "Save as Picture". Save the picture to OneDrive and share it out. Post a link to the image here.
Verified answer

v-yuazh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sudheermadduru,

Could you please share a screenshot of the configuration of your flow?

Please take a try to modify the expression in the Condition as below:

@equals(triggerBody()?['Region']?['Value'], 'Europe')

You should choose the "Region Value" dynamic content of the trigger to get the value of "Region" column.

I have made a test on my side and I have create a flow as below:

When an item is created in the list and the value of "Region" column is equal to "Europe", the flow would run successfully to start an approval as below:

Regards,
Alice Zhang
Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

These things are not "solved" by any means. I'm testing Flow in our environment and I always get the same results. Works a time or two but later the same day or the next day, the logic fails totally. I've even had a simple flow check the status of an item, send either a true email or false email so I could test what it was doing, and it's fired BOTH emails on the same status check.
This has become horribly unreliable and the only way I've been able to correct it is to edit the flow, delete the Document Status Value field, re-add the field and update the flow.
It works for a day or so, then fails again.
Can anyone explain how we are supposed to move to Flow when we are forced to use the Modern Experience?
luizhr 112 on at

Like
a
(0)

Report
Copy link

Link copied!

I solved the issue following this instruction below:

condition returns false on choice field | Power Automate Exchange (flowug.com)