cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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 III
Dual Super User III

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

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.

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 ? 

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (13,638)