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
 

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
 

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
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

thirdImage

New Flow Community Board!

Check out the new Microsoft Flow Community Blog Topic Suggestion board!

fourthImage

Australia Summit

Travel to Melbourne and network with thousands of peers!

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 281 members 3,516 guests
Please welcome our newest community members: