Hi.
I have a Sharepoint list with a calculated column that gives either Yes or No based on the rest of the list.
I am trying to make a Flow that sends an email when the Calculated Column (Test) says "Yes" but no matter what i write in conditions it always gives "false" status when testing.
I have tried:
@equals(triggerBody()?['Test'], 'Yes')
@equals(triggerBody()?['Test'], bool('true')
@equals(triggerBody()?['Test'], true)
and a lot of other things, but i cannot get i working. Is it not possible to use a Calculated Column as a condition i flows?
If you need more information, please ask.
//Morten
List
Flow
Solved! Go to Solution.
Hi @Anonymous,
The value of a calculated column with Yes/No type should be 1/0,
You could take a try with expression below:
@equals(triggerBody()?['Test'], '1')
I have made a test to create thef flow as screenshot below:
The flow would run successfully as below:
Best regards,
Alice
Hi @Anonymous,
Can you set a varibale or a compose action to the calculated field value and use that in your condition?
Hi @Anonymous,
The value of a calculated column with Yes/No type should be 1/0,
You could take a try with expression below:
@equals(triggerBody()?['Test'], '1')
I have made a test to create thef flow as screenshot below:
The flow would run successfully as below:
Best regards,
Alice
Thank you @v-yuazh-msft
It works now. I thought i had tried that though, but i guess i might have missed the '' or something. 🙂
Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
User | Count |
---|---|
53 | |
42 | |
39 | |
34 | |
34 |
User | Count |
---|---|
70 | |
64 | |
60 | |
58 | |
50 |