Unanswered

Automatically create variables in Power Automate Desktop

(0) Share

Report

Posted on by adisprijic

Hello,

I tried to make, in Power Automate Desktop, an automatic number of variables, based on the number of elements in the array, but it didn't work. I have a certain string that is parsed from a pdf document and the elements are saved there. The number of elements in the array is variable.
How to create a variable number of variables based on the number of elements in a variable array?

Any suggestion is welcome

Thanks in advance

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @adisprijic

I don't think we can do that, may be can you explain your usecase to understand why you need such a requirement ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
adisprijic 2 on at

Like (0)

Report
Copy link

Link copied!

Hello,
Thanks for your answer @Nived_Nambiar
I want to create an automatic posting of a bank statement in the sql-local ERP system.
Sometimes a bank statement has 4 or 5 items, and sometimes it has 10-20. A bank statement arrives every day. therefore, the number of rows is not equal on any extract.
So, in order to place the data in variables after parsing, I need to create as many variables as there are lines on the bank statement (sometimes it's 5, sometimes 10 or even over 20).
For this purpose, I need to find a model of how to use PDA to create "n" variables based on the number of elements in the sequence

Was this reply helpful? Yes No
MichaelAnnis 5,727 Moderator on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, we have all tried to do this at one time or another. But, as with all coding languages that I have worked with so far, all variables must be defined prior to running, and you can’t use a variable to create a variable.

The most practical way to work around this is to list your variables in column A of an Excel document, and list the value in column B. In C1, you will have an input field, and in D1, you will have a vlookup formula, =Vlookup(C1,A:B,2,false).

when you need a variable, you call it by writing the unique variable to C1, and reading D1 to your reusable variable.

best of luck!

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You don't really need to define each item of the statement into a separate variable. You just need to put them into a list of values, or a data table. They do need to be processed the same way anyway, so there is no need to define them as individual variables.

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

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No