Convert Lookup values to People Values

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.