cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dandandsan
Helper II
Helper II

Flow condition results returning error or false result

Hi, I am very new to this and trying out a basic flow to email when a quantity value for a particular row is less than 6 but can't get it to work without an error.

 

less than.JPGequal to scope .JPGLes than condition result.JPG

I have also tried the following which seems to work but the condition is returning false result even though the value is correct, 

 

equal to 4.JPGequal to condition result.JPG

 

Any help would be much appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @dandandsan ,

That is probably better one for the experts over at the Power Automate Community, however it appears the issue is that Excel is sending Quantity over as a String. You need either a Compose statement or a Variable to convert this into a numeric format. I did an example here as below with a Variable - the Expression is 

int(outputs('Get_a_row')?['body/Quantity'])

WarrenBelz_1-1611484842293.png

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

3 REPLIES 3
WarrenBelz
Super User
Super User

Hi @dandandsan ,

That is probably better one for the experts over at the Power Automate Community, however it appears the issue is that Excel is sending Quantity over as a String. You need either a Compose statement or a Variable to convert this into a numeric format. I did an example here as below with a Variable - the Expression is 

int(outputs('Get_a_row')?['body/Quantity'])

WarrenBelz_1-1611484842293.png

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

@WarrenBelz 

 

That's brilliant, thank you very much. 

No problems @dandandsan ,

You might also take a few minutes to watch this video from Shane Young

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,599)