Fetch data row from Excel and pass variable to the fetched string

[Dawid_Nguyen]

I have an Excel file with links list like this example for reference:

I use for each activity to read each row in the data table(excel).
In that “var1” i have to pass value that i will assign to variable of the same name(“var1”) with value like date. The result i want it be: “www.google.com/2022-12-31/test”
Could any1 tell me how to make it to work?

[Sudharsan_Ka]

HI @Dawid_Nguyen

In the excel give the link like

www.google.com/{0}/test

In the studio give it like

String.Format(var1,Your Date String)

Regards
Sudharsan

[Sudharsan_Ka]