Get items from SP list based on selection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a list of names in SP:

Name ID

John 1

Ed 2

Joe 3

Power app user can select name using drop down control. For example selection is Ed. How to retrieve ID based on the selection also?

If user has selected Ed, I then want to Patch Ed's ID (2) to another SP list. Is it possible to store ID as a variable?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,277 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

If you are asking how to extract the number from the end of the string, it would be (setting as a Variable)

UpdateContext( { varMyID: Value( Right( 'Name ID', Len('Name ID')- Find(" ",'Name ID')-1 ) ) } )

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for answer but not exactly what I expected.

Imagine having a large datatable (SP List in this case) Where using drop down I choose one item, for example name "Ed". How to get other items from same row, where I selected Ed. For example I want to use Ed's LastName too. And it exists in the same row as Name: "Ed". Just by selecting Ed, I now have options to use all items in a row for further actions.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,277 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

I am still a little unclear looking at your two posts, but if "Ed" is in a drop-down called ddFirst linked to the column FirstName in your list MyStaff, the Items of a Gallery would be

Filter( MyStaff, FirstName=ddFirst.Selected.FirstName )

and you could display all the related fields in the gallery.

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.

Was this reply helpful? Yes No