cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
danielmillion
Frequent Visitor

creating a collction based gallery is very slow while scrolling

Hello, 

To my understanding, by saving data in a collection i can work on a gallery with editable fields without suffering from slow upload time, query time or slow scrolling, but that is not the situation.

 

By collecting data to a local connection, and building the gallery based on that collection, i am suffering from the exact same 

symptoms i suffer by using a direct connection to the database.

 

Can anyone suggest why ? 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: creating a collction based gallery is very slow while scrolling

Hi @danielmillion ,

Do you patch data from your Gallery back to your SQL Table directly?

Could you please share a bit more about the formula you used in your app? Do you use Patch function?

 

According to the issue that you mentioned, I assume that you use Patch function to patch data from your Gallery to your data source, is it true?

When you providing value from TextInput box in your Gallery for these Text fields in your SQL Table, please use the following formula:

TextInput1.Text

rather than TextInput1 directly.

So you should modify your formula as below:

ForAll(
        Gallery1.AllItems,
        Patch(
              '[dbo].[SQLTable]',
              Defaults('[dbo].[SQLTable]'),
              {
                 ...
                 TextField1: TextInput1.Text,
                 TextField2: TextInput2.Text,
                 ...
              }
        )
)

 

Please consider take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Dual Super User
Dual Super User

Re: creating a collction based gallery is very slow while scrolling

Hey @danielmillion 

 

Can you share more details about the configuration of the application? Where are you collecting this collection and what is passed in the gallery items.

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Community Support
Community Support

Re: creating a collction based gallery is very slow while scrolling

Hi @danielmillion ,

Could you please share a bit more about your scenario?

Do you mean that the you are still suffering from slow upload time, query time or slow scrolling when you connect the Gallery to a collection?

 

Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Actually, the collection is stored in current app session, whose performance is based on the RAM your app has gotten from your PC.

On your side, please make sure you have remained enough RAM on your PC to run your PowerApps app.

 

In addition, please also make sure the Network is in good state on your side. The Network state would also affect the speed of retrieving and processing of data within your PowerApps app.

 

Please also check if the following performace tips for canvas app could help in your scenario:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/performance-tips

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
danielmillion
Frequent Visitor

Re: creating a collction based gallery is very slow while scrolling

Nothing solved my problem. 

I tried to solve my problems by collecting data from the gallery directly to my SQL database, which will result in much faster editing,

but i recieved this message  : 

 

the data source you are using expects text type, but you are using a control type.

 

How can i by pass that ? 

What's causing the problem ? 

Community Support
Community Support

Re: creating a collction based gallery is very slow while scrolling

Hi @danielmillion ,

Do you patch data from your Gallery back to your SQL Table directly?

Could you please share a bit more about the formula you used in your app? Do you use Patch function?

 

According to the issue that you mentioned, I assume that you use Patch function to patch data from your Gallery to your data source, is it true?

When you providing value from TextInput box in your Gallery for these Text fields in your SQL Table, please use the following formula:

TextInput1.Text

rather than TextInput1 directly.

So you should modify your formula as below:

ForAll(
        Gallery1.AllItems,
        Patch(
              '[dbo].[SQLTable]',
              Defaults('[dbo].[SQLTable]'),
              {
                 ...
                 TextField1: TextInput1.Text,
                 TextField2: TextInput2.Text,
                 ...
              }
        )
)

 

Please consider take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Dual Super User
Dual Super User

Re: creating a collction based gallery is very slow while scrolling

Hi @danielmillion 

 

This error comes when an unexpected value is passed for the fields.

In case of different controls, the way to input value could be different.

For TextBox: ControlName.Text
For Dropdown: ControlName.Selected.ColumnName

If you can share more details about the configuration of the application, we can help you construct a formula for this.

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,118)