Answered

Data from SP list not loading

(0) Share

Report

Posted on by xecho

Hi,

I have one SP list which data is frequently not providing data, it just times out without errors and no records are loaded into the collection that I am trying to load it to.

At the same time, directly working with the SP list doesn't work either.

I have a few other SP lists that work without issues and which have more records than this one.

Funny enough, when I use the app on my iPhone, it loads most of the time correctly.

The behavior is the same in Edge and Chrome.

I have been clearing cache in both browsers and even rebooting my laptop but nothing seems to help.

I also tried to set up another connection to the same SP list, but unfortunately with the same result.

The code is really simple:

ForAll(
 Distinct('Apps Reports (New2)', Modality), 
 Collect(MyOldReports, Filter('Apps Reports (New2)', Modality = Result));
);

Any solution to this?

Thanks,

Bart

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 155,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @xecho ,

What exactly are you trying to do here - that code will (in a long way) simply collect the entire list.

Was this reply helpful? Yes No
xecho 98 on at

Like (0)

Report
Copy link

Link copied!

I am trying to load the complete list into a collection to avoid delegation issues as well
as to speed up searching through the list. Also, to avoid the issue with more than 2000 records , I’m loading in a few steps (categories) which is about 6 of them.
But even when I use ClearCollect() to get the list in one go, nothing loads.
like said, when I do this in the app on my iPhone the list loads without issues.

Thanks

Was this reply helpful? Yes No
WarrenBelz 155,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @xecho ,

The point I was making was that using the structure you posted, you getting a distinct list and then your ForAll Filter would simply get the list back as each "loop" would collect all the records matching the value. If you want distinct records, use LookUp as below

Clear(MyOldReports); With( { wMod: Distinct( 'Apps Reports (New2)', Modality ) }, ForAll( wMod As aCol, Collect( MyOldReports, LookUp( 'Apps Reports (New2)', Modality = aCol.Result ) ) ) )

however the underlying issue is that Distinct() is not Delegable, so will only work on the first data set up to your limit.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
xecho 98 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

The code is not the issue, it is doing exactly what I want. On my iPhone using the app in Powerapps loads the data all correctly.
However, when editing or using the app
on my laptop won’t load the data, as if the connection is not working but no error seems to be returned either.

Any clue?
Thanks,
Bart

Was this reply helpful? Yes No
Verified answer

xecho 98 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
I finally managed to find the cause of not getting data. In some records, the field on SP was too large (htmltext with images inserted). It seems like SP doesn't like that and sort of hangs up the connection.
Don't understand why this is an issue only when the powerapp is running on a laptop and not on the iPhone.

I changed all of the records that had this large data and now everything works as before.
Thanks for you help,
Bart

Was this reply helpful? Yes No