Answered

PowerApps DataTable not showing data from Sharepoint List

(0) Share

Report

Posted on by jainlaksh05

Hi,

I have created a data table to showcase the contents in my share-point list. The data table is not showing any record from my share-point list. It just displays the "We didn't find any data to show at this time" message. There are 20 records in my list.

The items property has the default value (no changes made). There are 63 columns in my list with columns of type like single line of text, multiple lines of text, choice, person, date , etc.

I just cant figure out why this is not working.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

AaronKnox 514 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The wizard that makes the DataTable when you select a data source via the prompt can mess things up, especially with a busy list with so many columns. I just tried making a DataTable and it brought over the SharePoint attachments column (?) which of course generated an error and I had to delete that column.

Try this instead:
Construct a ShowColumns formula that contains some of the columns from the SharePoint list.
Place this formula in the DataTable Items property instead of selecting the SharePoint list.
The wizard will then create a DataTable from just those columns. For example:

ShowColumns(Projects,"description","isActive","districtId")

Was this reply helpful? Yes No
jainlaksh05 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks this worked on a simple list but did not work on my list.

Was this reply helpful? Yes No
jainlaksh05 23 on at

Like
a
(0)

Report
Copy link

Link copied!

I just did some trial and error and found that the problem is with my list. I have more than 12 person columns.

Gallery and Data Table both fail in showing the records when I cross the limit of 12 person columns.

Is there any way I can keep the >12 person column count and still make the gallery/data table work?

Was this reply helpful? Yes No
AaronKnox 514 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I believe that's a hard limit. With a Power App you probably don't need the complex People datatype in SharePoint which includes DisplayName, Email, and Picture. Saving their email as a Single Line of Text (SLT) column should suffice.
One trick is to 'borrow' a People type column combo box, even the Modified By column will work, to serve as the drop down People Picker for every SLT column.

Was this reply helpful? Yes No
jainlaksh05 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, This works for a new record to be added to the datasource.

But in the case of editing an existing record, what should i put in for the defaultselected items so that it shows the existing person's displayname. Do note i am only storing the email id as SLT.

Was this reply helpful? Yes No
Verified answer

AaronKnox 514 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
In defaultselecteditems for a person column, try this code, replacing emailID with your actual column name:
{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & Lower(emailID), DisplayName:"", Email:"" }

Also, this might work without the @OData line.

Was this reply helpful? Yes No
jainlaksh05 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks.

Was this reply helpful? Yes No