Excel - If cell value greater then 0 send an email

(0) Share

Report

Posted on by 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

All responses (10)

Answers (0)

hdhillon on at

Like (0)

Report

Re: Excel - If cell value greater then 0 send an email

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
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Excel - If cell value greater then 0 send an email

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 on at

Like (0)

Report

Re: Excel - If cell value greater then 0 send an email

still failed:

Flow:

Flow result:
MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Excel - If cell value greater then 0 send an email

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-Automate/ba-p/1560881

BR,
Marco
hdhillon on at

Like (0)

Report

Re: Excel - If cell value greater then 0 send an email

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 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Excel - If cell value greater then 0 send an email

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 on at

Like (0)

Report

Re: Excel - If cell value greater then 0 send an email

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 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Excel - If cell value greater then 0 send an email

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 on at

Like (0)

Report

Re: Excel - If cell value greater then 0 send an email

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 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Re: Excel - If cell value greater then 0 send an email

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