Power Platform Community Forum Thread Details

Hi,

I'm using a DataTable to get the data from a SharePoint list, the third field (responsable:) is a made of a "Person / Group " from SharePoint, and when I execute the collection all the info at the Table is correct les that "Person / Group" which is showed like: [object Object] and not the name of the Person / Group selected.

Aplicacion de control de cambios.JPG

I tried the suggestion mentioned by @ señor-dang and @ jaos291 on the case:

https://powerusers.microsoft.com/t5/General-Discussion/object-Object-Powerapps-and-Sharepoint-list/td-p/172007

Trying to add a column. But something happens that isn’t work yet.

Hope someone can help me, thanks

Categories:

Building Power Apps

Hi @llss86,

Do you save your SP list records into a Collection within your app?

Is the Responsable column a Person type column in your SP list?

I think it is a known issue that when you save your SP list records which includes a Person type column into a Collection, the Person type column would be saved as a Table value rather than Text value within the Collection.

The user @priyankbhat has faced same issue with you, please check the response within the following thread:

https://powerusers.microsoft.com/t5/General-Discussion/DataTable-is-showing-object-Object-in-column-for-data-from/m-p/137040

Based on the needs that you mentioned, I think the AddColumns function could achieve your needs. I have made a test on my side, please take a try with the following workaround:

Set the OnVisible property of the first screen of my app to following:

ClearCollect(RecordsCollection, '20181119_case13')

Set the Items property of the Data Table control to following:

AddColumns(RecordsCollection, "ManagerValue", Manager.DisplayName)

Note: The Manager column is a Person type column in my SP list.

On your side, please take a try with the following workaround:

AddColumns(CrearTarea, "ResponsableValue", Responsable.DisplayName)

Note: The CrearTarea represents the Data source you typed within the Items property of the Data Table control.

Then display/enable the "ResponsableValue" field within your Data Table control.

More details about AddColumns function, please check the following article:

AddColumns function

Best regards,

Community site session details

DataTable created by a Sharepoint list (User,person,grupo)

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates