Unanswered

Autogenerate a link based on ID on SharePoint List

(0) Share

Report

Posted on by cedillom07

I want to create a column on a SharePoint list that has a hyper link that links to another SharePoint list based on the ID. One list is a master list containing all submissions and their details, the other list simply contains SOME aspects of those details but would like them to be linked to the master list.

I want PowerApps to auto-generate a link for me when a submission is made. The link will be a link to another SharePoint list item. My thoughts were to retrieve the submission ID to reference the other list item's details. For example, the below ID is 43. How can I auto-generate the long link?

I have --> Text - "Last ID: 43"

"/Lists/Document%20Update%20Requests/DispForm.aspx?ID=43&e=RYFF4z" automatically.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

If you are using a form and you want to use the Id to generate a link, then you can use OnSuccess property of the form - Set(varID, Form1.LastSubmit.ID)

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report

If you already have the ID somewhere, either in a variable or a field somewhere like a gallery / dropdown. You generate it in a string like so

"/Lists/Document%20Update%20Requests/DispForm.aspx?ID=" + varID + "&e=RYFF4z" or

"/Lists/Document%20Update%20Requests/DispForm.aspx?ID=" + dropdown.selected.refID+ "&e=RYFF4z"

Was this reply helpful? Yes No