cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Using calculated column as Condition

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

 

ListListFlowFlow

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Using calculated column as Condition

Hi @MortenMou,

 

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:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

Best regards,

Alice

 

View solution in original post

3 REPLIES 3
Highlighted

Re: Using calculated column as Condition

Hi @MortenMou,

 

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

Highlighted
Community Support
Community Support

Re: Using calculated column as Condition

Hi @MortenMou,

 

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:

Capture.PNG

 

The flow would run successfully as below:

Capture.PNG

 

Best regards,

Alice

 

View solution in original post

Highlighted
Helper I
Helper I

Re: Using calculated column as Condition

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

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,451)