Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Microsoft Flow & Sharepoint List Trigger

Hi all,


I would really appreciate your help on an issue I am having.


Currently I have a flow (seen below) which has a condition to send an email to a particular user, depending if the Calculated Column on a SharePoint list is above £1500. When running this flow, it seems like it is not recognising the condition value, and instead, only sending to the 'Yes' Email flow. 


Is there a way I can get flow to recognise the calculated column value? I have tried all the tests below and only can get it to follow the 'Yes' Flow. 


I have even tried formatting the condition value e.g. 1500, 1,500, £1500.00, 1500.00...


Any ideas would be appreciated please.





Thank you for your help in advance.

Solution Sage
Solution Sage

Hi @DeanGrealish ,


Can you try formatting the values on both side of the condition so that there are no currency symbols and it is just a plain number.


If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Hi Eric,


Thank you for your suggestion.


Unfortunately, this still does not work. I don't even get an email when I change it to this.


I have tried: 1500, 1,500, £1500.00, 1500.00...

Hi @DeanGrealish ,

Can you please try converting both the side number as float and give a try ? 




Hope this helps.




Hi Murali,


Thank you for your suggestion. 


Please can you kindly advise how I would go about doing this? I am quite inexperienced with Flow/Sharepoint lists.


Thank you for your help in advance.

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,430)