Unanswered

Anyone know why my collection would not load my SharePoint List

(0) Share

Report

Posted on by sonisick

282

I connected to my SharePoint List. I only have one record in the list. I tried this statement both in App OnStart and then in the Form OnVisible

ClearCollect(colGridData,"Task Assignments")

No Syntax errors

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Ramole Super User 2024 Season 1 on at

Like (0)

Report
Hi @sonisick
Can you share bit more information as you're clear collect looks ok, you can also test by adding button and run it

ClearCollect(colGridData,'Task Assignment')

then on gallery item property add colGridData see what you will get

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

Like (2)

Report

@sonisick

Change your formula to:

ClearCollect(colGridData,'Task Assignments')

When you put double quotes around the name, that is what is collected...a text value.

I hope this is helpful for you.

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

Like (1)

Report

@sonisick
@RandyHayes you're correct as I didn't even seen it "
That's why always good to use without space when creating field names or data source 😀

Was this reply helpful? Yes No
sonisick 282 on at

Like (0)

Report

Actually, I mistyped it here.
ClearCollect(colGridData,"Task Assignments")
The above line is copied from the OnVisible. Being a JavaScript Program I fight with single quotes--but not this time.

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

Like (0)

Report

@sonisick

So are you stating that you have single or double quotes on your data source name?

Was this reply helpful? Yes No
sonisick 282 on at

Like (0)

Report

Actually tried it with Single Quotes--still didn't load

Was this reply helpful? Yes No
sonisick 282 on at

Like (0)

Report

Thanks, that makes sense. I'm now getting my headers but no data.

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

Like (1)

Report

@sonisick

First, keep in mind that loading records from a datasource into a collection is just duplication of data and a performance issue. So, only use this if you really need to have all of your data loaded in memory of the app.

Second, make sure your datasource is refreshed in the app. Go to the datasource list and on the menu, refresh the list.

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

Like (0)

Report

@sonisick
Collecting data source in to memory not good idea and it will decrease you're performance 100% as your data grows then you will feel, you're loading will take forever plus you have to refresh each new record, I have been in that road waste my time but been rescued by @RandyHayes till today I appreciate him for that.
take his advice and you will thank him later.
Secondly if you're loading the data in the memory because of delegation no need it just filter you're data correctly.
Example if you need to filer a date month and year
To avoid delegation problem, you can create a condition a filter data date due, instead of Month functions and will be delegable also will pull all you're data no matter which data source, I hope that make sense.
by the way @RandyHayes is a master and honestly I have learned lot from him.

Was this reply helpful? Yes No
sonisick 282 on at

Like (0)

Report

How do you load a datagrid?

Do you need to update each row as changes are made?

Can you filter the datasource before you load it into a collection?

Was this reply helpful? Yes No