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?
That must be it.
I would just add a separator: Concat( ThisItem.'Lookup Multiple Selection', Value, ", ")
@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
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?
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
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
Share
Report
All responses (
Answers (
