Copy the content of a new Excel file created in OneDrive to another file

(0) Share

Report

Posted on by EY

Hi,

I am new to Power Automate and would you offer my some help?

I have people sending me an Excel file by email from time to time for some product updates, what I need to do is to merge all those information (multiple rows) onto a master file I am keeping on OneDrive. Basically both files are having the same format in a table, e.g.

Department	Staff Name	Contact Number	Product A Quantity	Product B Quantity	Product C Quantity

Let's say if I save the received new file into a OneDrive folder, would Power Automate be triggered as "a file is created in a folder" then

- Read the content in the received file

- Check if the staff is a new one, append it in the master file as a new row

- Or if it is an existing staff, then update the corresponding information behind

Regards,

I have the same question (0)

All responses (10)

Answers (0)

ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Copy the content of a new Excel file created in OneDrive to another file

hi @EY you can try this.

Was this reply helpful? Yes No
EY 10 on at

Like (0)

Report

Re: Copy the content of a new Excel file created in OneDrive to another file

Hi ChristianAbata,

Thank you for your suggestion.

I tried to put it up the same way, but new files being created are probably in different file names, how can the file and table information be defined?

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Copy the content of a new Excel file created in OneDrive to another file

hi @EY try with this.

Was this reply helpful? Yes No
EY 10 on at

Like (0)

Report

Re: Copy the content of a new Excel file created in OneDrive to another file

Hi@ChristianAbata

My test run is successful now. But when checking at the result, all the cells are blank. Is it correct if I put the setting like this?

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Copy the content of a new Excel file created in OneDrive to another file

hi @EY in department you need to add the department value but from your excel conector

Was this reply helpful? Yes No
EY 10 on at

Like (0)

Report

Re: Copy the content of a new Excel file created in OneDrive to another file

Hi @ChristianAbata

May I know how the command is like? Seems I don't have any selection to choose from dynamic content, I tried simply put "Department" in, same problem.

thanks.

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Copy the content of a new Excel file created in OneDrive to another file

hi @EY sorry for delay, list rows in a table have columns I think... whe you are inserting data in the other excelm you need to add the columns that have list rows conector.

Was this reply helpful? Yes No
EY 10 on at

Like (0)

Report

Re: Copy the content of a new Excel file created in OneDrive to another file

Hi @ChristianAbata

I am not sure if I get what you mean, I tried
in the other excel a row is added but empty.

Was this reply helpful? Yes No
ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Copy the content of a new Excel file created in OneDrive to another file

@EY please see the image please, I don't know if is correct my suppose.

Was this reply helpful? Yes No
EY 10 on at

Like (0)

Report

Re: Copy the content of a new Excel file created in OneDrive to another file

yes, @ChristianAbata , your understanding is correct.

Both tables in those excels are exactly the same. I always get empty cells copied to excel2. is my outputs() command right?

Was this reply helpful? Yes No