Copy from Excel variable to a Table variable

(0) Share

Report

Posted on by BLabat83

122

Hello again,

I need to load all the contents of an Excel into a table type variable.

For this, I am declaring the Excel variable with the file (Excel) and then I read the content into the ExcelData variable. Then, I loop through each row of the ExcelData variable and insert it into the Table variable, but this process is very long and slow.

I would like to copy everything from ExcelData to the Table variable, but I can't, so I have to make a loop. Is there any way to copy everything from ExcelData variable to Table variable at once?

Thank you!

Categories:

Power Automate Desktop

All responses (4)

Answers (1)

Sort by

Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

%ExcelData% is already a table variable, if you read the entire range at once. Why would you need to move it to a new table?

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.

If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/
BLabat83 122 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Agnius,

I Want to use the search functionality to find something. It means that I can use in ExcelData?
Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

If you mean the Find or replace in data table action in PAD, then yes, you can use it on %ExcelData% directly.
BLabat83 122 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you @Agnius you help me a lot!!!