Change part of URL

(0) Share

Report

Posted on by Pow3rAutomat3

Hi all,

I have a list of item, whith corresponding ID. I would like put this ID(1234) in URL to go directly to item page.

.../master/suppliers/6/products/1234/edit

I don't know the correct comand but I think that should be something like

.../master/suppliers/6/products/[ExcelData][LoopIIndex][1]/edit

where [ExcelData][LoopIIndex][1] is the reference to my item's list.

Could someone teach me how to resolve?

Thank you

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

momlo 1,527 Super User 2024 Season 1 on at

Like (1)

Report

Hi @Pow3rAutomat3
Your thinking is correct.
To learn:
1. Search forum - there are many identical questions to this one
2. Read documentation, start here:
https://learn.microsoft.com/en-us/power-automate/desktop-flows/use-loops

Was this reply helpful? Yes No
Verified answer

werkbook 36 on at

Like (2)

Report
@Pow3rAutomat3

The following flow provides a high level overview of the solution:

We will need to read the Excel data as a datatable using the action “Read from Excel worksheet”. Remember to specify that the first line of range contains column names under the advanced properties.

Then, using the action “For each”, we will loop through each of the datarow “CurrentItem“ ****in the datatable. For each iteration of the loop, we use the action “Go to web page” to navigate to the URL “%Url%/%CurrentItem[0]%/%CurrentItem[1]%” which consists of 3 parts:
%Url% which is fixed and is “https://links.sgx.com/1.0.0/corporate-announcements/” in this example
%CurrentItem[0]% refer to the first column of the current datarow, i.e. “CurrentItem“, which is read from the Excel
%CurrentItem[1]% refer to the second column of the current datarow, i.e. “CurrentItem“, which is read from the Excel

Attached is the Excel file used for your reference. Hope this helps!

PS: To read more about this topic, please visit How to navigate to different URLs based on an Excel spreadsheet (werkbook.co)

Book1.xlsx

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (1)

Report

it would be something similar to like this:
.../master/suppliers/6/products/%ExcelData%/edit

%ExcelData% - Variable produced in Read from Excel worksheet.

Was this reply helpful? Yes No
Pow3rAutomat3 26 on at

Like (0)

Report

Hi all.
Thank you for your advices.
I solved using a flow similar to that one @werkbook proposed.
Since I made a list of items ID, instead to make a new variable, I used the follow URL
.../suppliers/6/products/%ExcelData2[LoopIndex][0]%/edit
where %ExcelData2[LoopIndex][0]% is the reference to my list in loop.

Was this reply helpful? Yes No