Others

Trigger a Power Automate Email When an Excel Cell Exceeds Zero

Elise WilliamsElise Williams Nov 18, 2026 868 views

Question details

The user needs an email notification when an Excel cell containing a supply or demand value is greater than zero.

Trigger a Power Automate Email When an Excel Cell Exceeds 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.
Before you start

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.

Solution 1Recommended

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.

1
Create a scheduled flow

In Power Automate, select Create > Scheduled cloud flow, set the start time and repeat interval, and select Create.

2
Read the Excel table

Add the Excel Online (Business) action List rows present in a table. Select the workbook location, document library if applicable, file, and table.

3
Check the value

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.

4
Send the email

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.

5
Save and test

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.

Create a Scheduled Flow to Check the Excel Table
Repeated alerts: The flow can send an email on every scheduled run while the value remains above zero. If you need only one alert when the value changes from zero or below to above zero, add a way to store and compare the previous state.
Free Microsoft Office alternative

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.

View and edit supply and demand spreadsheets in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLSXFamiliar spreadsheet interface for an easier transition from Microsoft OfficeFree, lightweight office suite for everyday document work
QA img-9

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.