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. 🙂
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
90 | |
50 | |
36 | |
30 | |
27 |
User | Count |
---|---|
73 | |
60 | |
50 | |
39 | |
38 |