Unanswered

Gallery from collection that has large amount of data, produce many errors. Help :(

(1) Share

Report

Posted on by dhisss

Hi everyone...

So, I got this project that handle a lot of data around 270 row.
The concept of this project is to makes like when we edit data on excel.

then, here is the result of my work

As you can see from the picture I make the gallery like in excel
so user can fill data in each row quickly.

But the problem are:

sometimes when you scroll down, you find a row that already filled with value, but actually you haven't filled it yet. The value is same like the value that you have filled in the row at the top beginning
If we move to another screen (add item screen), and then go back to this screen. some values that we have filled before are gone. But some value still exist

I store my data in collection to display it on gallery, because I thought it would be safer when it runs locally.
the data is around 260 rows.
and the result of my work is still got those problems

I don't know what is wrong with the my concept to achieve project goal (Fill the data like excel)
is it because I store it on collection?
is it because powerapps can't handle data around 260 rows in one time?

Yaa I'm stuck in here 😞
does anyone have solution with this kind of problem, or any suggestion the way to handle my probelm
I'm kinda new in powerapps, so I think I miss something /technique to solve this problem.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@dhisss

@dhisss wrote:

But the problem are:

sometimes when you scroll down, you find a row that already filled with value, but actually you haven't filled it yet. The value is same like the value that you have filled in the row at the top beginning

If we move to another screen (add item screen), and then go back to this screen. some values that we have filled before are gone. But some value still exist

For this, check if the following simple attempt works first: just use the following Formula - usually place this in the property formula right after whatever is already there e.g. right at the end after performing the Patch, SubmitForm, or any other applicable operation modifying the data:

Refresh(YourDataSourceName)

For the screen changing problem, you may want to also place this same formula above at the OnVisible property of the screen that has the data source on it as well (but if it was placed correctly otherwise after all the data changing operations, it should not be needed to use it at all for the OnVisible).

See if something along the lines of the above works for your scenario.

Was this reply helpful? Yes No
dhisss 26 on at

Like
a
(0)

Report
Copy link

Link copied!

@poweractivate

thank you for replying my question.
But I still get confused

when I try Refresh(), it doesn't work in collection right?
because the data source in my gallery is collection.

So, should I change the data source to another data source like sharepoint list, so I can perform refresh()?

Owh ya, I got another question too
when we want to update data in collection, is it better to perform clearcollect() ? because I use patch to update my data in collection. is it the reason of my problem?

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@dhisss

Then you do not need Refresh at all if there is no data source. Even if there is one, Refresh is not usually needed either - just in certain special situations, such as in case the data could be changed by another person using the app on their device, and this needs to be shown on the app, then Refresh is sometimes used to capture these kinds of modifications. However in your case, unless the Collection you refer to is actually still coming from an underlying data source somewhere in the app, then you should be having no issues with your method. So in other words, it should work as you are doing it. Double check regarding how you are making the modifications.

Patch is valid for Collection. Because a Collection is a "special kind of data source" (but it is a data source, that should never need to be refreshed, you are right about that).

Formulas that operate on data sources also usually work on Collections as well, because a Collection is technically a special kind of data source as well.

So then, since it seems you are doing it correctly, besides double checking how you are doing the Patches and double checking the app otherwise in general just in case, we are not sure how to best advise you on this problem at this time. There is definitely something wrong if you get those results, but we are unsure in your case where specifically it is incorrect. If later we get an idea we will let you know.

One thing is we notice this presumption

@dhisss wrote:

Gallery from collection that has large amount of data, produce many errors. Help

Is the error really only occurring when there are many records? Does the error never happen for let's say, only 5 records?

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@dhisss

It seems when you recently asked this same question another way in a more recent thread, we got a clearer idea what you meant.

You can check it here:
scroll the gallery to the end of the gallery become an indicator

We think you may need to Paginate the Gallery - it is a topic discussed at length on these forums, so we encourage you to check the existing solutions - we linked you to one in our response to your new thread, and that response may even contain a file that may be imported so you could try it.

Was this reply helpful? Yes No
dhisss 26 on at

Like
a
(0)

Report
Copy link

Link copied!

@poweractivate

I see, okay thank you
I will check it

Was this reply helpful? Yes No