Trigger a Power Automate Email When an Excel Cell Exceeds Zero
Question details
The user needs an email notification when an Excel cell containing a supply or demand value is greater than zero.

- Product
- Microsoft Power Automate and Excel
- Device & OS
- not provided
- Scenario
- Monitor a supply or demand value in an Excel workbook and send an email when it exceeds zero.
- Observed behavior
- The desired outcome is an email alert when the monitored value is greater than zero.
Store the workbook in OneDrive for Business or SharePoint and put the monitored value in an Excel table with a column header, such as Supply. Ensure the monitored column contains numeric, nonblank values and that you can connect Power Automate to the workbook and your email account.
Create a Scheduled Flow to Check the Excel Table
Use a scheduled cloud flow to check the value at intervals and email you when it is greater than zero.
This approach checks the table on a schedule; it does not fire immediately when a cell changes. If the table has multiple rows, the flow checks each returned row.
In Power Automate, select Create > Scheduled cloud flow, set the start time and repeat interval, and select Create.
Add the Excel Online (Business) action List rows present in a table. Select the workbook location, document library if applicable, file, and table.
Add an Apply to each action using the value output from the Excel action. Inside it, add a Condition and use the expression greater(float(item()?['Supply']), 0), comparing its result to true. Replace Supply with the exact header of your monitored column.
In the Condition's true branch, add an email action such as Office 365 Outlook > Send an email (V2). Enter the recipient, subject, and message, and include the Supply column from dynamic content if useful.
Select Save and Test in Power Automate. Check the flow run history with a value above zero and again with a value of zero or less.

Get Help With a Power Automate Configuration
Use the Power Automate community if the connector, table, trigger, or condition is not working as expected.
Manage Supply and Demand Workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for editing Excel-compatible workbooks and moving existing spreadsheets into your workflow. Power Automate email alerts still need to be configured and troubleshot in Microsoft Power Automate.

Frequently Asked Questions
Will the scheduled flow email me as soon as the cell changes?
No. A scheduled cloud flow checks the Excel table at the interval set in its Recurrence trigger. The email is sent after a scheduled check finds a value greater than zero.
Does the value have to be in an Excel table?
For the List rows present in a table action, put the value in an Excel table with a column header. Select that table in the Excel Online (Business) action.
Why might I receive the same alert more than once?
The condition is checked on every scheduled run, so a value that stays above zero can trigger repeated emails. Store the previous state and compare it with the current value if you only want an alert when the value crosses the threshold.
What if the monitored value is calculated by a formula?
The flow checks the value available in the workbook when it reads the table. Make sure the formula has recalculated and the workbook is saved before the scheduled check.




