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
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?
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?
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.
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.
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?
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.