Hi dear all,
There are two table in one Excel and I would like to merge two tables into one as below.
Sample
I built a flow as below and seems run history worked. But the table is not merged.Does anyone know how to solve?
Hi @Glueck ,
If your table headers are fixed you can create a template file with the headers create a new file with the headers and avoid the create table action in your flow.
After that you have to iterate over the array that you are getting from the Select operation.
So , after Select operation use an apply to each loop , add the select array into it add a compose action inside it and write item(). The compose action is optional , this compose will show you the data that you are trying to add. Now after the compose you can use the action add a row and pass the same object(row) or use output of compose action in that array.
Refer the below screenshot.
The Add a row action takes time to execute based on how many objects are there in your array. If you have a large dataset then you can consider using office script and adding the data to a blank excel file , refer the below link for more details.
https://www.youtube.com/watch?v=4g8Lh0gzEnc
Hope this helps!
Thanks,
Sanmesh
Thank you for your advice!
Based on your advice, I tried, but it didn't work.
1.Added new table
2.Added one flow to pick the file content dynmically.
Do you know how to build a flow to pick the content and reflect into a new table?
Hi @Glueck ,
How are you creating the table in the excel file?
One way could be to keep a template file with the header pick the file content dynamically before adding the data (the template file will have only headers)and then add the data.
Thanks,
Michael E. Gernaey
66
Super User 2025 Season 1
stampcoin
61
rzaneti
31
Super User 2025 Season 1