Hi
I have a SharePoint list with a person column.
In PowerApps I have a Combobox where I list all the persons in this SharePoint list.
Now I need the ID of the item in the SharePoint list for the person selected from the combobox.
In the combobox items i have: (This lists all the people from the list in the User column, User column is a person column)
Sort(
Distinct(
Listname,
User.Displayname
),
Result,
Ascending
)
How would I get the SharePoint item id for the selected user?
If I don't use a person column but a single line of text then I just do a LookUp.
LookUp(listname,'Full name'=ComboBox1.Selected.Result,ID)
But how would I do the same if the column is a person/people column?
Solved! Go to Solution.
Hi @JimmyWork ,
Something like this should work
LookUp(
ListName,
User.DisplayName = ComboBox1.Selected.Result
).ID
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.
Visit my blog Practical Power Apps
Hi @JimmyWork ,
Something like this should work
LookUp(
ListName,
User.DisplayName = ComboBox1.Selected.Result
).ID
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.
Visit my blog Practical Power Apps
User | Count |
---|---|
257 | |
108 | |
93 | |
57 | |
41 |