Answered

Read Excel - Specific Columns

(0) Share

Report

Posted on by sceleiro

Good afternoon, how are you? I would like to ask for your help with the following: I am working on a process in Power Automate and need to read an Excel file that contains a large amount of information—about 8000 rows on average and more than 60 columns. Because of this, I would like to extract only 3 specific columns from the file and convert them into a "Table" in Power Automate. I have seen that there is an event to delete columns in Excel, but it only works one column at a time. What method would you recommend to extract the data more efficiently?

I also tried downloading each column separately into a different table and then attempting to combine them, but I had issues with that as well. When trying to combine them, it doesn’t work as expected (instead of merging the columns, it creates new rows).

Thank you very much!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

sceleiro 21 on at

Like (0)

Report
Copy link

Link copied!

One more question, for now I was able to solve it by adding an event that deletes column A and iterating over it with the loop X number of times. However, the process is still 1 by 1. Is there a way to delete a range of columns in a single event? For example, from column A to T?

Was this reply helpful? Yes No
Suggested answer

Deenuji_Loganathan on at

Like (0)

Report
Copy link

Link copied!

Hi Sceleiro,

In Power Automate Desktop, there are no built-in actions to delete multiple rows in one go; therefore, we must delete each unwanted column individually. Refer to the screenshot provided for reference. Once you deleted the unwanted columns then you can read your excel file and play around.

If you're open to using .NET scripts, the possibilities are vast. You can read specific columns such as C and E, or delete multiple columns like A, B, D, and F in a single operation.

Hope it helps. Please let me know in case if you have any additional queries.

Thanks,

Deenu

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Sceleiro,

In Power Automate Desktop, there are no built-in actions to delete multiple rows in one go; therefore, we must delete each unwanted column individually. Refer to the screenshot provided for reference. Once you deleted the unwanted columns then you can read your excel file and play around.

If you're open to using .NET scripts, the possibilities are vast. You can read specific columns such as C and E, or delete multiple columns like A, B, D, and F in a single operation.

Hope it helps. In case if you require any assistance on .NET scripts also please let me know.

Thanks,

Deenu

Was this reply helpful? Yes No