Excel - If cell value greater then 0 send an email

[hdhillon]

Need you help -  this is probably a simple on for all of you 🙂

I want to create  flow, that if cell B1 value is greater then 0 it will send me an email

(The cell value contains a formula)  Sheet name is called:  mismatch_check

I cant seem to get it to work

[MarconettiMarco]

Hello,

please share all the Power Automate Actions and Controls so that I could help you.

Anyhow the excel Table has to be formatted, otherwise Power Automate is not able to list the rows in the table.

BR,

Marco

[hdhillon]

Marco thanks for the offer to help

I have created a table as you suggested in my excel spreadsheet. it includes a IF statement to look for differences between 2 sheets and reports the difference as a value greater then 0

I have then created the following daily scheduled flow to look for a number greater then 0 --> if it finds one then it sends me an email

However I cant get it to work 😞  What am i doing wrong

Harry

[MarconettiMarco]

Hello @hdhillon ,

in the Condition you should specify the "Yes_People_No_Process" excel column and the operator has to be "is greater than" based on your requirement.

Please let me know

BR,

Marco

[hdhillon]

Marco,

I made the change (Equal to changed to Greater Then) and then ran the flow.   I got the following error message.  (This is probably due to the fact that the column contains a IF statement and therefore doesnt read as a number/integer?

[MarconettiMarco]

ok, maybe the field isn't correctly formatted in Excel.

Anyhow, you can use the following expression to change the value in integer:

int('<'your value'>)

BR,

Marco

[hdhillon]

Still doesnt work, I've amended the flow a little so it looks for the table aswell

  I'll add screenshots of the whole process

Excel S/S

Flow:

Flow Result:

[MarconettiMarco]

ok @hdhillon ,

in the condition you should replace your field with the following expression:

int('<your value>')

please replace <your value> with the excel column variable.

Refer also to the following article:

https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Convert-String-to-Number-using-Power-A...

BR,

Marco

[hdhillon]

still failed:

Flow:

Flow result:

[MarconettiMarco]

Please don't use the "values" excel variable, you've to select the specific excel column on which you want to check the condition.

BR,

Marco

[hdhillon]

How do I select a cell value? How do I write that in the Initialise variable section?

Currently everything is linked to the table, that is why i selected value