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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

joeinmay 205 on at

Like (4)

Report
Copy link

Link copied!

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,","))

Was this reply helpful? Yes No
JP-23070531-0 16 on at

Like (0)

Report
Copy link

Link copied!

Thank you! So much to learn 😄

Was this reply helpful? Yes No