Excel - If cell value greater then 0 send an email

Like (0) Share

Report

Posted on 9 Jun 2022 15:53:57 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

I have the same question (0)

All responses (10)

Answers (0)

hdhillon on 23 Jun 2022 at 16:25:14

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on 23 Jun 2022 at 15:18:39

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

Was this reply helpful? Yes No
hdhillon on 23 Jun 2022 at 15:15:49

Like (0)

Report

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

still failed:

Flow:

Flow result:

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on 23 Jun 2022 at 14:44:30

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

Was this reply helpful? Yes No
hdhillon on 23 Jun 2022 at 14:36:50

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:

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on 23 Jun 2022 at 14:16:23

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

Was this reply helpful? Yes No
hdhillon on 23 Jun 2022 at 14:03:11

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?

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on 23 Jun 2022 at 13:24:45

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

Was this reply helpful? Yes No
hdhillon on 23 Jun 2022 at 13:14:08

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

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on 21 Jun 2022 at 16:41:20

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

Was this reply helpful? Yes No