Variable Concatenation

(0) Share

Report

Posted on by TelmoERF96

170

Hello everyone,

I am running an extraction that stores independent values in variables name 'LinkCMVMConsulta0', 'LinkCMVMConsulta1', and so on up to 'LinkCMVMConsulta4'.

That extraction is working as intended the problem is that I want to access each one inside a For each action and I already have a variable named 'Counter' starting at '0' and incrementing with each iteration of the loop.

Since all my variables start with 'LinkCMVMConsulta' and then have a number in front of them changing I was thinking of appending the 'Counter' to the text 'LinkCMVMConsulta' and use it as a variable, not as a string, and I have not been able to do so.

I tried writing %LinkCMVMConsulta%%Counter% inside the Set variable action but it gives me an error saying that %LinkCMVMConsulta% doesn't exist which is true, so I don't know what to do .

If anyone knows any way to help I would really appreciate it.

Thanks in advance,

Telmo Ferreira

Categories:

Power Automate Desktop

I have the same question (0)

All responses (8)

Answers (1)

UshaJyothiKasibhotla 203 Moderator on at

Like (0)

Report

if you need to concatenate then try this
%LinkCMVMConsulta+Counter%

Hope this helps
Usha

Was this reply helpful? Yes No
TelmoERF96 170 on at

Like (0)

Report

Thank you for your response @UshaJyothi20

But that still doesn't work, I still get the error 'variable "LinkCMVMConsulta" doesn't exist.

Was this reply helpful? Yes No
UshaJyothiKasibhotla 203 Moderator on at

Like (0)

Report

can you please share some screenshots?
and which type of data is there in the variables

Was this reply helpful? Yes No
TelmoERF96 170 on at

Like (0)

Report

Sure @UshaJyothi20

The 'LinkCMVMConsulta' variables have URLs stored as text value

And the 'Counter' variable that has a numerical value

When I tried what you proposed the action gave me error without even running the code saying variable 'LinkCMVMConsulta' doesn't exist, which in fact doesn't.

Was this reply helpful? Yes No
UshaJyothiKasibhotla 203 Moderator on at

Like (0)

Report

youe variables are named as LinkCMVMConsulta0
and LinkCMVMConsulta1

so you need to use the same variable from the select or give the same name
like
%LinkCMVMConsulta0+Counter%
%LinkCMVMConsulta1+Counter%

Hope this helps
Usha

Was this reply helpful? Yes No
TelmoERF96 170 on at

Like (0)

Report

@UshaJyothi20

I know that is the correct way the variable should be written, that is why I wanted to write it like this LinkCMVMConsulta + Counter. So it would automatically change the variable to the correct one for each iteration of the loop I'm running. Without a way to write the variable dynamically I guess I will have to use a bunch of If and Else to get the correct output I want

Was this reply helpful? Yes No
Verified answer

UshaJyothiKasibhotla 203 Moderator on at

Like (1)

Report

Do one thing you can crate list of that variables or you can write them in an excel and you can loop through them
then you can write
%currentitem+counter%

Hope this helps

Was this reply helpful? Yes No
TelmoERF96 170 on at

Like (1)

Report

Thank you for your time @UshaJyothi20 that works.

Was thinking I could achieve the same result with less actions but it's the result I wanted so thank you once again for all the help.

Was this reply helpful? Yes No