Answered

How to link to a SharePoint item by ID in PowerApps

(0) Share

Report

Posted on by Hclor

I am customizing a SharePoint list in PowerApps. On one screen I have, it displays all items with a filter applied. (Basically it shows all items with the same serial number from the previous screen.) I can make these hyperlinks, but "OnSelect", I want it to take them to that item. If I do Navigate to another screen, how would I have it populate with the data from the item they clicked on?

I also want them to be able to see or click on any attachments that list item contains. Any ideas?

Categories:

Building Power Apps

All responses (10)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey! To see the item, on select navigate to another screen with a form and in the form Item property write:
Gallery1.Selected

That will show the item.

I don´t think it is possible to show the attachments but I know that you can download it. But I think you cant preview it

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!
Hclor 56 on at

Like
a
(0)

Report
Copy link

Link copied!

This halfway worked, it seems to show the item data, but it does not show the attachment. (I used DataTable1.Selected) It says "There is nothing attached." in the attachment field, which is not true... the item does has an attachment. Do you know how to get it show the attachment or a link to the attachment?
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Hclor

Change your Item property formula to:

LookUp(yourDataSource, ID=DataTable1.Selected.ID)

That should give you what you need.

I hope this is helpful for you.
Hclor 56 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes This is giving me the same results as @Nogueira1306 's solution. See screenshot. (I added a comment in the SharePoint item that has an attachment to make sure it was showing the correct item, still no attachment)
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey! Watch this video:

https://www.youtube.com/watch?v=eZtOVvbj9qw

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hclor

Have you made any alterations to the form?

What is the Default property of your DataCard for the attachments? What is the Items property of the attachment control inside of the DataCard?
Hclor 56 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes Ahh, that may be it. I was working on this with another user and it looks like the properties have been altered. Attachments Datacard value Items properties= AttachmentsMain and Attachements datacard default= ThisItem.'{Attachments}'
Would it be easiest to delete the form and re-insert it?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hclor

You can remove the attachment datacard from the Field edit of the form and then add it back in. That would be easiest.
Hclor 56 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes! That worked. So simple, wow. Thank you, @RandyHayes !!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hclor

No trouble at all...Keep It Super Simple!!