Power Platform Community Forum Thread Details

Hi everyone,

I am trying to automate following case:

I receive every few weeks an excel file that contains the exactly same information, but with some newly added rows. E.g. rows 1,2,3 are same, but the new excel file contains row 4 and 5 that have some data. In order to keep track of the data, I have saved the excel list on my local drive, and whenever I receive the updated version, I would copy and paste the information on my excel file on the loval drive and make some notes for myself.

Is there a way I could automate these activities, so that the moment I receive a new excel file via e-mail, that the newly added rows are added to my excel file?

I am curious to hear your opinions.

Categories:

Process mining

Hello,

The excel file that you receive has a table? If not, I believe this topic was discussed here:

Solved: Interacting with Data from Excel without a table - Power Platform Community (microsoft.com)

"Just for exposure, this is now possible with Office Scripts, specifically Office Scripts with Power Automate. "; however this is a complex solution.

-----

If the excel is coming from an e-mail and has a table, you can try to:

use a trigger to your e-mail account (outlook connector,..);
use an excel connector to retrieve the table with their rows;
Loop for each one of the rows and verify if your file has that entry (you can compare a specific column that you have not modified);
If not, you can add it to your excel file.

Note: your local excel file would be sync with your onedrive.

Thank you,