Using variables in 'navigate to'

[Andrew_Callaghan]

I have a Read CSV going into a ForEach.

CSV
header1, header2,header3
name,surname,URL4534
name2,surname2,URL4554

I have set string variables for the individual URL codes to their respective URLs

URL4534 : https//someaddress.com
URL4554 : https//somepotheraddress.com

I then want to input the URL into the navigate activity. I have tried:
row(“Header3”).ToString
…but this just enters the URL code into the address bar and not its resolved variable.

What’s the way to do this?

[ptrobot]

Unfortunately, you can’t convert a string to a variable like that. The workaround is to create a translation table/dictionary. First create a dictionary and initialize it:

Assign the URLs:

And then access the URL like this:

dictURLs(row("Header3").ToString)

[Andrew_Callaghan]

@ptrobot

translation table/dictionary. First create a dictionary and initialize it:

Brilliant. That’s working Thank you!