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

Expression Result showing as false even though if statement is true

Hi guys, 

 

I'm new to Flow and trying to create a simple alert based on a condition. Here is my flow: 

 

Flow1.PNG

Now my datasource is a SharePoint list and the TAC column is a calulated column which returns a number. 

 

My logic is simple - If the Value of the field "TAC" is equal to 1 then send an email. 

 

However whenever I run my flow no email is sent even though I use a PowerApp to set the TAC field Value to "1". I can confirm the PowerApp is setting the field in the list as when i browse to the list I see the value as 1. 

 

When i check that my flow has ran, it confirms it has ran sucessfully, however the Expression result is always showing as false, even though I know the statement should return a true result. 

 

Flow2.PNG 

Can somebody give me some steer here please, what I'm trying to acheive is straight forward. Have I hit a limitation whereby calculated columns are not supported in conditions? 

 

Thanks for your help. 

 

Steve

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Expression Result showing as false even though if statement is true

HI Steve,

All calculated fields work as a string in Flow.

 

You'll need to convert the string by using the int() expression.

 

Please see below for how I did this:


 

Then your condition will look like this:

 

 


I confirmed that it works.

Thanks,

 

Dan
 

View solution in original post

5 REPLIES 5

Re: Expression Result showing as false even though if statement is true

HI Steve,

All calculated fields work as a string in Flow.

 

You'll need to convert the string by using the int() expression.

 

Please see below for how I did this:


 

Then your condition will look like this:

 

 


I confirmed that it works.

Thanks,

 

Dan
 

View solution in original post

KevB
Level: Powered On

Re: Expression Result showing as false even though if statement is true

Hi 

 

thank you for replying to this query. 

 

Your images are not available can you repost please?

 

Many thanks

Re: Expression Result showing as false even though if statement is true

Sorry for the issue with the images

 

Please see below:

 


All calculated fields work as a string in Flow.

 

You'll need to convert the string by using the int() expression.

 

Please see below for how I did this:

 

 

 

 

Re: Expression Result showing as false even though if statement is true

@SteveT If this works for you please mark as solution.

 

Thanks!

SteveT
Level: Powered On

Re: Expression Result showing as false even though if statement is true

Hi Dan, 

 

This worked a treat thank you very much! 


No idea that a calulated field which was in the number format would return as a string in flow. 

 

Many thanks 


Steve

 

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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 Kudoed Authors (Last 30 Days)
Users online (5,602)