Dear Community,
HELP!
How can I convert lookup values (as a result of a lookup column or lookup formula) to real People Value? So I can compare it to User() function?
A See PEople values on the left, but lookup values on the right. How to make the right Peope column look like the left one (People value).
I’ve seen a solution here, but the referenced doc is not available anymore…
Thanks!!
1 Like
Hey there! People values hold other values within themselves (specifically name, photo, email)
You could do peopleValue.Name and compare that to the lookupValue.name
3 Likes
Hi,
indeed, it helped, THANKS!
Exactly how I solved is:
In the right Column originally had:
[Tanulók].Filter([Értesítésszint].contains(thisRow.Szint)).ListCombine().Unique()
Than, based on your advice I changed it to the following (Név is Name in Hungarian)
[Tanulók].Filter([Értesítésszint].contains(thisRow.Szint)).[Név].ListCombine().Unique()
4 Likes
@Marton_Posz
thank you for sharing your very elegant solution
it helps others who want to do something similar and will find this thread
well done
max
2 Likes
system
Closed
5
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.