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. 🙂
User | Count |
---|---|
89 | |
40 | |
21 | |
20 | |
16 |
User | Count |
---|---|
137 | |
56 | |
46 | |
36 | |
26 |