Unanswered

Create a Dictionary of lists from Excel file

(0) Share

Report

Posted on by RVF99

Hello everyone,

I'm have a Excel spreadsheet which I use as settings of my automation. Each line creates a variable within a dictionary. Beside that, a few variables are list type. For example, follows the spreadsheet.

A	B
int_MaxRetry	3
list1	['Test','Test2']
list2	['Test3','Test4']

When I try to loop through list type variable created, I get an error message. The dictionary does not understand the list type

How should I import this variable so PAD can understand that is a list type?

Thanks!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

BalamuruganDev 57 on at

Like (0)

Report

Hello @RVF99 ,

Is okay with .json file as setting file instead of excel?
If yes you can create a json file along with your needs and can able to use as dictionary throughout the flow

Let me know if you want steps

Thanks,
BD

Was this reply helpful? Yes No
RVF99 36 on at

Like (1)

Report

Hi @BalamuruganDev,
I saw this possible solution using .json, however it is a requirement the use of the Excel file.

To get around this problem, I'm reading the variable as array and then converting to list, while there is no "native solution".
Thanks,
RVF

Was this reply helpful? Yes No