cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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.

 

DeanGrealish_0-1626270820844.png

DeanGrealish_1-1626270896381.png

 

Thank you for your help in advance.

4 REPLIES 4
eric-cheng
Solution Sage
Solution Sage

Hi @Anonymous ,

 

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

Anonymous
Not applicable

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 @Anonymous ,

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

 

muralidharan_0-1626277497609.png

 

Hope this helps.

 

Thanks,

Murali

Anonymous
Not applicable

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

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

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.

Top Solution Authors
Users online (1,862)