Unanswered

data table from sharepoint list does not display person column

(0) Share

Report

Posted on by gonzna3

All I want to do is display my list created in sharepoint where most columns are people since it is a contact table.
But when loading the data to powerapps the people are not shown...

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@gonzna3

Please check your settings on your SharePoint people column. You most likely have it defined to allow multiple selected. The DataTable will not be able to display that information.

Easiest answer if you don't need multiple people in a column, then turn that off.

If you need to have this as multiple people, then you will need to pre-shape the data to your table (Items property of your DataTable):

AddColumns(yourDataSource, "multiPeopleCol", Concat(yourMultiPeopleColumnName, DisplayName & ", "))

Then add the "multiPeopleCol" to your DataTable fields.

This will give you what you want.

I hope this is helpful for you.

Was this reply helpful? Yes No
gonzna3 6 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes I do need multiple.

Is this a step to do in the sharepoint list?
Do you have a step by step article?

where would the below line be?
AddColumns(yourDataSource, "multiPeopleCol", Concat(yourMultiPeopleColumnName, DisplayName & ", "))

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@gonzna3

Is this a step to do in the sharepoint list?

No, if you need multiple, then you don't need to change anything on the SharePoint list, as it is already set to multple people.

Do you have a step by step article?

Well, there really only is one step (maybe two).

1 - Change the Items Property of your DataTable to:

AddColumns(yourDataSource, "multiPeopleCol", Concat(yourMultiPeopleColumnName, DisplayName & ", "))

Replace the "yourDataSource" with the name of your data source (most likely what is already listed in the DataTable Items property). Replace the yourMultiPeopleColumnName with the name of the column in your SharePoint list that is a multi-people column. The multiPeopleCol is free-form. You can call it whatever you want - it will become the column header of your datatable.

2 - Click on edit fields for the DataTable and then check on the multiPeopleCol field (or whatever you ended up calling it).

That's it...

Was this reply helpful? Yes No
gonzna3 6 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes Ok. thanks!
This works, but I have some rows with ,multi and some single person... the single person and the multi at the end have a ",". Is there a way to avoid this?
Also view is long not split or under each other?

why cant powerapps just literally show me the list/table?
seems like waste of time and functionality...

I also have 5 columns with multi in this table, seems i cant do this for more than 1 column to so does not work...

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@gonzna3

This works, but I have some rows with ,multi and some single person... the single person and the multi at the end have a ",". Is there a way to avoid this?

You can change your formula to this to drop the final ",":

AddColumns(yourDataSource, "multiPeopleCol", Left(Concat(yourMultiPeopleColumnName, DisplayName & ", "), Len(Concat(yourMultiPeopleColumnName, DisplayName & ", "))-2) //drops last two characters )

Also view is long not split or under each other?

You will not be be able to do that with a DataTable control. They are single line only.

why cant powerapps just literally show me the list/table?

seems like waste of time and functionality...

I'm not sure what you mean by waste of time and functionality. The DataTable does exactly what it does. It has VERY limited formatting and control over it. This is why the Gallery, rather than DataTable, is the better choice for a control when doing a list where you need to control parts of it individually.

I also have 5 columns with multi in this table, seems i cant do this for more than 1 column to so does not work...

You can do this for as many columns as you want. I only demonstrated one as I don't know your column names and it would be repetitive otherwise.

But, if you wanted more, just add them on the AddColumns function:

AddColumns(yourDtaSource, "Col1Name", theFunctionAbove, "Col2Name", theFunctionAbove, "Col3Name", theFunctionAbove...etc, etc.

Was this reply helpful? Yes No
gonzna3 6 on at

Like (0)

Report
Copy link

Link copied!

Ah, I see what you mean.

Once I try to keep adding more columns to the formula I get "The function Concat has some invalid arguments"

AddColumns(NORTHEAST_1,
"DELAWARE VALLEY",
Left(Concat(DelawareValley, DisplayName & ", "),
Len(Concat(DelawareValley, DisplayName & ", "))-2),
"NY METRO",
Left(Concat(NYMetro, DisplayName & ", "),
Len(Concat(NYMetro, DisplayName & ", "))-2))

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@gonzna3

At a glance, your syntax looks correct - what specifically is it saying is an invalid argument? There should be a part that has a darker red line under it.

But again...remember from what I mentioned - you're only going to get so far using a DataTable. If you want real control over the format, then you need to explore the Gallery instead.

Was this reply helpful? Yes No
rcoughanour 19 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes Helped me so much to figure out why the people column wasn't being populated in my SP list.

Was this reply helpful? Yes No