Answered

Convert Sharepoint People Displayname from Table type to Text to function in Lookup?

(0) Share

Report

Posted on by JP-23070531-0

I am trying to Lookup a Sharepoint List People value (DisplayName) but I am getting an error that Expected value is Text. When I have the cursor after the last parenthesis it shows the value, but it will not display the result in the Label.

LookUp('Risiko CheckListe', Title = DDProjektname.Selected.Title, ProjektManager.DisplayName)

DDProjektname is a drop down.

I have tried adding .value & .text after DisplayName, I have seen suggestions of using Concat() but I am not sure how. Any ideas please?

Many thanks

Categories:

Using Apps Using Formulas

image.png

All responses (2)

Answers (1)

JP-23070531-0 16 on at

Like (0)

Report

Re: Convert Sharepoint People Displayname from Table type to Text to function in Lookup?

Thank you! So much to learn 😄
Verified answer

joeinmay 205 on at

Like (4)

Report

Re: Convert Sharepoint People Displayname from Table type to Text to function in Lookup?

Most likely the "ProjektManager" people picker field allows multiple values. So the lookup formula is trying to return a table.
Try using the below:
LookUp('Risiko CheckListe', Title = DDProjektname.Selected.Title, Concat(ProjektManager.DisplayName,DisplayName,","))