How to get a ThisItem for a lookup column in SharePoint

(0) Share

Report

Posted on by Aurora

364

Hi All,

I am unable to get a user value in a gallery using ThisItem. I have a gallery that displays tasks and the person the task is assigned to, but the person the task is assigned to is in a lookup column on SharePoint. Trying Text(ThisItem.FK_USER.Value) does not work either, and using .Id is also not working for me.

The lookup value comes from a User table also in SharePoint. Does anyone know how to bring this value through?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Is it going to only ever be a single user? Is it a person column?

If yes: ThisItem.FK_User.DisplayName

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
Aurora 364 on at

Like
a
(0)

Report
Copy link

Link copied!

There will only every be 1 user assigned a task in this specific instance. I do not get .DisplayName a choice.

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

I test it on my side and it works fine.

For a Person column type: ThisItem.Person.DisplayName
For a Lookup to another list (and using title as the Lookup column): ThisItem.'Person Lookup'.Value

But your error shows you are giving a table where text is expected... something may need fixing is that data structure?

Was this reply helpful? Yes No
Verified answer

MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!

@Aurora @jcfDaniel the reason it is returning a table value is because you have allowed in the data source multiple select so you will need the following:

Concat(ThisItem.FK_USER, Value)

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@phipps0218

That must be it.

I would just add a separator: Concat( ThisItem.'Lookup Multiple Selection', Value, ", ")

Was this reply helpful? Yes No
Aurora 364 on at

Like
a
(1)

Report
Copy link

Link copied!

This worked, thanks!

Was this reply helpful? Yes No