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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,836)