Unanswered

How can I select the newly added row from an Excel spreadsheet?

(0) Share

Report

Posted on by user281

Hello
I am currently trying to send an email when a new row is added in an excel sheet. In the new row is also the email of the recipient received so how do I manage to select and use the information from the new row?

Thanks a lot

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

OneSleepyPanda 17 on at

Like (0)

Report

Hey @user281

Unfortunately, adding a new row to an Excel workbook isn't an available trigger for PowerAutomate. I'd recommend using a SharePoint list instead.

If you need to maintain your excel spreadsheet, you could develop a Microsoft Form that collects the required information and on submission updates the excel spreadsheet and triggers the email at the same time. Note that in order for power automate to work with the excel file, it needs to either be in SharePoint or OneDrive for Business.

Was this reply helpful? Yes No
user281 9 on at

Like (0)

Report

Hey thanks for the answer
I dont want to use the new row as a trigger. I want to identify the new row after the trigger. I want to find the new row with a action.

Was this reply helpful? Yes No
Verified answer

OneSleepyPanda 17 on at

Like (0)

Report

Gothca!

In that case, you'll want to add another column to your Excel table called "processed" or something like that. Then you can pull in the rows of the table where Processed is equal to null by using the Filter Query field in the action. You can then use a for each control after that to run whatever you need on all of the rows that are returned. Just be sure to include a step in your flow that updates that field to "yes" so it isn't triggered on any successive runs of your flow.

Note that I'm using two singe quotes here with nothing between, if you put in 'null' it would be interpreted as a string.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (1)

Report

There is also now a template that replicates a When an Excel row changes trigger without the need to add columns to track changes:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/When-an-Excel-row-is-created-modified-or-deleted/td-p/2264670

Was this reply helpful? Yes No