Unanswered

sharepoint lists showing empty at screen and app level

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

my app has a form which connects to 3 SP lists. I can access to the elements everywhere inside the form but if i call them at the screen or app level, they don't show any data.

my goal is to store the list inside a collection and then access the collection inside the form.

from what i read, the only way to store inside a collection is using onvisible at the screen level

thanks for your help

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Instead of putting the table name in the Onvisible, create a collection OnVisible of the screen as:

ClearCollect(ITPuuchaseColl,ITPurchase_Categories)

Then put name of the collection, ITPurchaseColl in your Gallery Items.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for you reply.
actually, i did that.
My screenshots meant to show that at the Screen level, the table is not returning any data while it does at Form level.

As you can see, when the table is selected at screen level it says "no data was found in (french). When i do the same at form level, it actually show the list of records...
I hope i made myself clearer

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

In OnVisible use formula:
ClearCollect(myCollection, ITPurchaseCategory)
and use myCollection inside the app.
Of course it is not indicated to import all the list's items, and to avoid some possible performance warning, you should think to filter the items by a column.

Hope it helps !

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I can get the records directly inside "items" field

now i create a collection:

when I use collectBrand, there's nothing in the dropdown

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

please see my post with more screenshots

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

anyone help me please! 😅

Was this reply helpful? Yes No