Unanswered

Create a flow for a selected row of Excel

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I want to create a flow from a spreadsheet in excel when an specific value is added to an specific column, an email should be sent.

When I try to check the flow, 3 errors appear.

Can you give me some feedback around flows made with excel?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

danwilso Microsoft Employee on at

Like (1)

Report
Hey @Anonymous!

There unfortunately aren't ways to trigger flows immediately when a value is added to a specific column. I won't bother you with the specifics, but one simple example is if you imagine accidentally creating a flow that added that itself added that value to the column, you'd pretty quickly have 1000s of flow runs going, each triggering another.

That said, there's a way you might be able to accomplish something just as good—depending on whether you're fine sending the email ~10–15 minutes after the value is added.

If you're okay with that delay, here's how I'd approach this:
Create a flow with a recurrence trigger running every 10 minutes or so
Create an Office Script that looks through the rows in the table and returns the ones that are new and contain the value you're trying to trigger on
Add a "Run script" action that runs this script on your workbook
The return value will be available in Power Automate, and you can use it accordingly (e.g. to send an email for each value that was added in the past 15 minutes and hadn't yet been used to send an email)
Create another Office Script, this time updating rows in the table so that they're correctly marked as "email sent" (or similar)
This is needed so that you don't end up sending a duplicate email every time the flow is triggered, i.e. every 15 minutes

Feel free to let me know if you have any follow up questions or need more detail 😊

—

For more on Office Scripts with Power Automate, see https://docs.microsoft.com/en-us/office/dev/scripts/develop/power-automate-integration

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Dan!
Thanks a lot for your answer 🙂

I'll let you know if I'm able to run the flow with your advice.

Was this reply helpful? Yes No