Unanswered

Email Triggered Based on Cells in Excel

(1) Share

Report

Posted on by LM-21011123-0

I have an Excel sheet containing cells that display either "TRUE" or "FALSE" based on other data in the sheet. Is it possible to you use Power Automate to automatically send an email to a specified address in the Excel sheet whenever a cell changes from "TRUE" to "FALSE" upon updating the sheet?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

There are no Excel triggers that would allow you to do what you want. The only Excel trigger is for a selected row, which means someone needs to manually trigger the flow. And then there is no way to tell if the value in the cell changed.

You would be better off switching to a SharePoint list. You can then trigger the flow when an item is modified. Once triggered, you can use the get changes for an item or file action to see if the true/false field was modified during the last change. If so, you could then send the e-mail.

Was this reply helpful? Yes No
Suggested answer

trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

As David mentioned, there is no trigger to launch a flow when a cell has changed directly. If you need to stay in Excel for business case reasons vs SharePoint Lists, understood.

One way to make this work is to setup a scheduled flow that runs every 30 minutes. When here you can effectively check if a cell is true/false (list rows present in a table) and then send an email.

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
Verified answer

FatihDagdelen 53 on at

Like (3)

Report
Hi :)

Power Automate doesn't support direct triggers based on individual cell changes. Instead, you can set up a flow that triggers when the Excel file is modified and then checks for the specific cell value change. Here's how you can achieve this:

Store the Excel File:

Ensure your Excel file is stored in a location accessible by Power Automate, such as OneDrive for Business or SharePoint.

Set Up the Excel File:

Create a table in your Excel sheet that includes the cells you want to monitor. Having your data in a table format makes it easier for Power Automate to reference specific cells.

Add a Helper Column:

Introduce a new column (e.g., "Previous Value") to keep track of the cell's previous state. This will help in determining if the value has changed from "TRUE" to "FALSE".

Create a Flow in Power Automate:

Trigger: Use the "When a file is created or modified (properties only)" trigger for the location where your Excel file is stored.

Action - List Rows Present in a Table: Retrieve the rows from your Excel table.

Action - Apply to Each: Loop through each row to check for changes.

Condition: Compare the current value of the cell with its previous value.

If the current value is "FALSE" and the previous value was "TRUE":

Action: Send an email to the specified address with the relevant details.

Action: Update the "Previous Value" column to "FALSE" to reflect the change.

If the condition is not met, continue to the next row.

This approach ensures that an email is sent only when a cell's value changes from "TRUE" to "FALSE". By maintaining a "Previous Value" column, the flow can accurately detect this specific transition.

For a visual demonstration and more detailed guidance, you might find this tutorial helpful:

https://www.youtube.com/watch?v=18-OfIDBacQ

And also you can find another topic related yours.

Trigger when Excel cell changes

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help!

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Hey there!

I am following up on this post email triggered based on cells in excel in this category building flows from 02/04/2025. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 3 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No