cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MortenMou
Level: Powered On

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

 

Capture1.JPGListCapture2.JPGFlow

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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
Super User
Super User

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?

Community Support Team
Community Support Team

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

MortenMou
Level: Powered On

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

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (4,943)