Answered

Data Table showing [object] [object] For "Person" Column on App Reload

(0) Share

Report

Posted on by Powertron

I have a Data Table within one of my apps, this data table pulls data from a variable (varUserAdminList) which itself is fed on the OnVisible property of the app page as follows :

Set(varUserAdminList,Filter(AdminCollection, Active = true));

AdminCollection itself is a collection which is fed by a Sharepoint form called "Admin List". This Data Table, when setup, appeared to show values correctly. On reloading the app, however, it now shows as follows :

On checking the error I see the following :

The "Name" column is a person column, and Name.Displayname is DEFINITELY a thing for this data source.

Weirdly I also noticed if I go into the setup of the datatable and clear then reinput the "items" value of varUserAdminList it suddenly fixes itself :

If I then reload the app it again is broken until I change this value.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Silvester. Akakpo 783 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Powertron ,
Rather than using the OnVisible property, can i suggest you put it on the OnStart Property?
And rather than using the global variable to store the varUserAdminList items, can you use a collection instead?
Powertron on at

Like
a
(0)

Report
Copy link

Link copied!

So the problem I have is I'm trying to apply/remove filters from the Data Table with button presses, the easiest way (I thought) to do this was to have the Data in the table fed by a variable.

So I have the Sharepoint list being loaded intially into a collection in the Apps OnStart :

Collect(AdminCollection,'ServerOrderForm-AdminList')

I then have the OnVisible of the Admin page in question setup a Variable from this Collection, with an initial Filter applied :

Set(varUserAdminList,Filter(AdminCollection, Active = true));

And the "Item" value of the data table uses "varUserAdminList" :

Then I have buttons on my page that change the filter as such :

Set(varUserAdminList,Filter('ServerOrderForm-AdminList', Active = false));

Which changes the content of the list. If there is an easier way to do this I'm open to hearing it 🙂
Verified answer

Silvester. Akakpo 783 on at

Like
a
(0)

Report
Copy link

Link copied!
Good, from my standpoint, it is a valid option but rather than using a variable to do that, use a collection.
You keep your initial collection that loads the data from the SP list
Collect(AdminCollection,'ServerOrderForm-AdminList')
Now for the True option,
ClearCollect(AdminCollectionGallery, Filter(AdminCollection, Active = true))
And the False option-

ClearCollect(AdminCollectionGallery, Filter(AdminCollection,Active= false))
And set the gallery DataSource to AdminCollectionGallery.
Powertron on at

Like
a
(0)

Report
Copy link

Link copied!

Using a collection instead of a variable does seem to have stopped this behaviour from occurring. Still confusing why it was happening in the first place, but not happening any more, so frankly I don't really care 😄