Using calculated column as Condition

[Anonymous]

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

ListFlow

[Pieter_Veenstra]

Hi @Anonymous,

Can you set a varibale or a compose action to the calculated field value and use that in your condition?

[v-yuazh-msft · Accepted 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

[Anonymous]

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