cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aebara
Helper I
Helper I

Display 'Person or Group' Data Type Column in Data Table

Hi,

 

I currently have a couple SP lists that are referenced in my app.

 

On one data table, I have a few records being displayed based on a gallery selection.

 

One of those columns I want displayed is a 'Person or Group' data type.

 

PowerApps does not like this, and is expecting a text value. Any ideas on how I could display this information as a text data type?

 

I am currently using ThisItem.Supervisor as my code (doesn't work).

 

I used ThisItem.COLUMN.Value in other areas where I had similar issues, and that worked, but not for this specific column/data type.

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions

Fixed it!

 

@v-yujincui-msft @SanjaKan @WarrenBelz 

 

In case you folks are curious, this is the code I was required to use:

 

 

 

Concat(ThisItem.'Supervisor'.DisplayName, Concatenate(Text(DisplayName),", "))

 

 

 

Screenshot_4.png

 

Glad to have it working now! Had me stumped for a couple days 😤

 

Still don't know why it works, but we'll take it.

 

Not working perfectly though. Only the first record in the 'Supervisor' column in my SP list is being returned to the data table, even though I have multiple users selected for that record.

View solution in original post

11 REPLIES 11
SanjaKan
Helper I
Helper I

Hi!

Did you try thisitem.supervisor.DisplayName? Maybe that will work?

Hey @SanjaKan,

 

I tried this, but also doesn't seem to be working.

 

Thank you for the suggestion!

Hey!

Does it allow you to add the Supervisor column into the data table from the source?

Yes, I can add the 'Supervisor' field from the source, but it still loads with an error in the 'Text' property of that column.

SanjaKan
Helper I
Helper I

Unles the Supervisor column is saved as text type in the list, I have no idea why this is happening.

Maybe disconnecting the source and re connceting it again sets everything right.

v-yujincui-msft
Community Support
Community Support

Hi @aebara ,

 

I agree with what @SanjaKan said, if you select the corresponding column and apply the following formula on its Text property as 

ThisItem.supervisor.DisplayName

It should work.

Note that thisitem needs initial capitalization.

vyujincuimsft_1-1654244813459.png

vyujincuimsft_0-1654244750720.png

 

 

Best Regards,
Charlie Choi

Hi Charlie, thanks for taking a look, but still getting an error in this column...

object.png

 

error.png

 

 

 

 

 

If it helps at all, I had errors in another column I fixed by using this code:

 

Concat(ThisItem.'Session type'.Value, Concatenate(Text(Value),", "))

 

 

WarrenBelz
Super User
Super User

Hi @aebara ,

I suspect your Supervisor column is multi-select, in which case if you only ever have one item selected

Concat(
   ThisItem.Supervisor,
   Value
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Hello @WarrenBelz!

 

Happy to see you here 😊

 

Still getting an error using this formula unfortunately.

 

Yes, this is a multi-select column. Most times there will only be one selection, but I wanted to leave the possibility of having multiple selections open.

 

Screenshot_2.pngScreenshot_3.png

 

Any more ideas?

 

Thank you!

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (4,582)