How to store multiple data item in List in power automate desktop.

(0) Share

Report

Posted on by Suraj_Adhikari

Hello Everyone.

Hope all are doing well.

I have a query regarding to "List" action in power automate desktop.

i want to store multiple item of data from excel to List .

While looping excel data after each iteration i want to store some data in List but i am unable to do this.

It only store the last iteration item. How can i store multiple item in List, Please help me.

Thanks in advance.

Best Regards,

Suraj

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Suraj_Adhikari
Please attempt the following method:
1. Create New list named "DataList"
2. For example, if I wish to retrieve data from an Excel file named SL and store the values from the first column into the list created above.
3. By employing the "Launch Excel" and "Read from Excel worksheet" actions, I have retrieved the data from the Excel file. Utilizing a "for each" loop, we are appending all current items [0] - the values from the first column - into the designated list variable

Code:
Variables.CreateNewList List=> DataList
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Documents\\SL.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.ReadFromExcel.ReadAllCells Instance: ExcelInstance ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
LOOP FOREACH CurrentItem IN ExcelData
Variables.AddItemToList Item: CurrentItem[0] List: DataList
END
Excel.CloseExcel.Close Instance: ExcelInstance

Thanks,
Deenuji Loganathan

------------------------------------------------------------------------------------------------------------------------

If I've resolved your query, please consider accepting it as the solution and giving it a thumbs up to help others find answers faster.

Was this reply helpful? Yes No
Suraj_Adhikari 24 on at

Like
a
(1)

Report
Copy link

Link copied!

@Deenuj
Hope you are doing well.

Thank you so much for your kind assistance. Your help is truly appreciated!
It work and save my time. Thanks aot.

Best Regards,
Suraj

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@Suraj_Adhikari
Many thanks for your kind words. Happy Automation!!

Was this reply helpful? Yes No