Hi @Anonymous
Yes you can try this way
For demo purposes i have created a master excel file
Now i have file present in sharepoint folder whose data need to append to master file
Flow looks like this
Step 1: add a trigger which trigger the flow when file is added to sharepoint
Step 2: List rows present in file under ths sharepoint folder
Note: here i am assuming that table would have same name Table1, so i have hardcoded it here.
Step 3: use apply to each to loop through each row in newly added file and append the row details to master file in onedrive
After run, the master excel file has newly added row from file in sharepoint
(Extra point: if you have a requirement that you need flow only when file excel file is added to that folder location, as adding other file may cause error while running the flow, so use trigger condition in triggger like below)
trigger condition: @endsWith(triggerOutputs()?['body/{FilenameWithExtension}'],'.xlsx')
This will help to run the flow only when only excel file is added 🙂
Hope this helps
Mark it as solution if it resolves your query !
