Get ID from selected SharePoint Person Column

[JimmyWork]

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?

[WarrenBelz · Accepted 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

[JimmyWork]

@WarrenBelz Thank you Warren I must be very tired 🙂