Power Automate

Want to add rows from one excel to other

(2) Share

Report

Posted on by slvedva

176

Hi,

Maybe someone can help with excel row update from input excel file to other excel file, stuck with error message.

I have input file with data, which every day user add additional data and other excel like output file with the same data, just filtered by supplier. And I want after manual flow run add these additional data to the output file.

1. From picture below, the first list rows present I read the input file

2. Problem I have with add a row into table - output table

Below is my error, maybe there are some other workarounds, how to add the data?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@slvedva Hi,

I assume that you have proper access to the file.

Please check if 9001.xlsx contains correct Table.

Double check if you pass the correct variable value.

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 4,150 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @slvedva,

1. Trigger:
Use Manual Trigger (e.g., “Manually trigger a flow”).
2. List Rows from Input Excel:
Action: List rows present in a table
File: Input Excel (stored in OneDrive/SharePoint)
Table: Ensure the table is defined and named.
3. List Rows from Output Excel:
Action: List rows present in a table
File: Output Excel
Table: Same structure as input.
4. Filter New Rows:
Use “Filter array” to compare input rows with output rows.
Logic: Only keep rows from input that don’t exist in output (e.g., based on a unique ID or combination of fields).
5. Apply to Each (Filtered Rows):
Action: Add a row into a table
File: Output Excel
Table: Must match column names exactly.

If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
Regards,
Riyaz

Was this reply helpful? Yes No
slvedva 176 on at

Like (0)

Report
Copy link

Link copied!

Hi @Riyaz_riz11

Please can you describe these steps 4 and 5 more detail, because I can't find, how to set-up this. I both tables I have unique field - "ID".

Because when I create filter array outside Apply to each loop, it's somehow include this in loop. These select an output from value should be from Input excel or Output? The same question for filter array this value from which table and what about these ID?

Was this reply helpful? Yes No