Get URL of item from Sharepoint list based on form field text

(0) Share

Report

Posted on by julienvdc

206

Hi,

I have this Sharepoint list/form that I customized through PowerApps, where users start by entering a Project Code. OnChange, this Project Code gets checked in the Sharepoint list and alerts the user with a on-screen notification telling him/her that there is already an entry with that Code. I got this working.

Now I would like to insert in that notification message the link to the entry to redirect the user to it so he/she can view the already filled details and stop creating a new entry.

How should I got about it?

I guess I could try to pull the ID of the entry that was found and use it to build the URL to the list item. How can I pull this ID, any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

WarrenBelz 154,538 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @julienvdc ,

You can use the ‘Link to item’ property of the record in the email body and click on on it will take the user directly to that record app form.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

julienvdc 206 on at

Like (0)

Report
Copy link

Link copied!

In the end I created a button with Visible/onChange parameters making it appear once there is a match in the Sharepoint List, and the OnSelect parameter of my button is the following:

Launch("https://[SHAREPOINT DOMAIN]/sites/[SHAREPOINT SITE]/Lists/[LIST NAME]/DispForm.aspx?ID="&LookUp('Log Project ID Card', 'Project Code' = DataCardValue1.Text).ID)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,538 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @julienvdc ,

I would have thought that

Launch( LookUp( 'Log Project ID Card', 'Project Code' = DataCardValue1.Text ).'Link to item' )

would be a bit simpler

Was this reply helpful? Yes No
julienvdc 206 on at

Like (0)

Report
Copy link

Link copied!

Ah yea even simpler! thanks! I changed it according to your suggestion, works well 😉

Was this reply helpful? Yes No