cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DeanGrealish
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.

 

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 @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 ? 

 

muralidharan_0-1626277497609.png

 

Hope this helps.

 

Thanks,

Murali

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
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)