Power Platform Community Forum Thread Details

I wish to create a workflow that would open all the files located in a subfolder, read the data from said excel files, and write down the extracted data in the new worksheet that corresponds correctly to the headers. (as some worksheets have their columns interchanged, etc.)

Currently, I have created the following workflow for accomplishing the task:-

However, I keep encountering certain issues in this flow -

1. I am unable to identify a way to dynamically read and write values that correspond with their respective headers.

2. When executed, the 'Write to Excel Worksheet' action seems to behave in a peculiar manner. It does write in the row immediately below the headers' row, but it also seems to overwrite the data previously written, as given below -

3. Additionally, some values are being written in the wrong header and I wish to avoid that from happening whenever a new file is read for compilation.

Do suggest me some ways to handle these anomalies occurring in my project. I'd highly appreciate some insight into what I am doing wrong here.

Categories:

Power Automate Desktop