How do I select an Item of my SharePoint List

(0) Share

Report

Posted on by DustinB

Is there a way to select an item of my SharePoint List, like it's done with a Gallery Item?

Detailed Situation:

I generated an mobile App out of my SharePoint List. So I'm Having three Screens with BrowseGallery, Detail Screen and Edit Screen. The Forms on the Screens (Detail and Edit Form) are working with the Selected Item of the BrowseGallery (EditForm.Item = BrowseGallery.Selected) also the Delete and Edit Icons are working with it.

Now I want to "select" and Item of my SharePoint List manually by it's ID or something like that. For Example the user is typing the ID in a searchbox and gets directly to the Detailscreen with the "selected" Item. All other Functions (Deleting/ Editing) should also work with this manually "selected" Item.

Right now I archieved to "select" an Item with the Filter Function. So I created another Screen with a Detail Form (DetailForm2.Item = First(Filter('MySPList'; ID = BarcodeScanner2.Value)). This Workaround is nice, but makes it a little bit complicated with all the other functions.

TLDR:

So is there a way to "select" an Item of my SharePoint List or directly Filter and Select the right Item out of the given BrowseGallery? So it could be used in the Detail and Edit Form and for the Delete and Edit Buttons? This would make things much easier for me...

Thanks in advance for trying to help me 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-siky-msft on at

Like (1)

Report

Hi @DustinB ,

No shortcut, because the first hard-coded way to return the Selected record is through the Gallery.Selected, you can only replace the record (Gallery.Selected) with the one you manually Selected(First(Filter(..) code) in the property one by one.

A more recommended approach is to save the selected record as a variable, so that you only need to change the definition of the variable later. For example:

Gallery.OnSelect: Set(varSelectedRecord; Gallery.Selected)

BarcodeScanner2.OnSelect: Set(varSelectedRecord; First(Filter('MySPList'; ID = BarcodeScanner2.Value)))

Hope this helps.

Sik

Was this reply helpful? Yes No
DustinB 71 on at

Like (0)

Report

thank you very much, I think that will help

Was this reply helpful? Yes No
DustinB 71 on at

Like (0)

Report

Hi @v-siky-msft

but it's not possible to delete the SharePoint Item with the Remove function, is it?
I tried Remove('MySPList'; varSelectedRecord), but got the Error "Incompatible type"

Is there another way to delete the SharePoint Item which is stored in the variable?

Thanks in advance 🙂

Was this reply helpful? Yes No