cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
danilomuniz47
Level: Powered On

Powerapps Slow performance with Sharepoint

I carry a sharepoint list with multiple items, one column of these items is a free text field with an image in base64 format.

 

Powerapps is loading the entire list to perform gallery filters, I would just like to load the items needed to gain performance.

 

The more items I add, the longer it takes for the app to load, but once it loads once it flows perfectly. The detail is that it is taking more than a minute to load a filter that has two items (Example)

4 REPLIES 4
Super User
Super User

Re: Powerapps Slow performance with Sharepoint

@danilomuniz47 

 

Do you have any delegation warnings for the filter query

Check the App checker

 

Delegationa and SharePoint

http://rezadorrani.com/index.php/2019/09/18/powerapps-delegation-with-sharepoint-as-a-data-source-wi...

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

v-siky-msft
Level 8

Re: Powerapps Slow performance with Sharepoint

Hi @danilomuniz47 ,

 

Can you share some formulas or snapshots? How many items are in SP list? Are there too many complex functions or complex fields in your formuals? such as LookUp function, Person Column, LookUp Column..

if you want to impove performance, you can try with showcolumns function if your data source is large set. Keeping only those columns you need will reduce lots of load. 

The following is a blog describing performance considerations, hope it can help.  https://powerapps.microsoft.com/en-us/blog/performance-considerations-with-powerapps/

Best regards,

Sik

danilomuniz47
Level: Powered On

Re: Powerapps Slow performance with Sharepoint

Collect(
        ReembolsoItensCollect2;
        Filter(
            ReembolsoItens;
            varReembolsoSelecionado.ID = Reembolso.Id
        )
    )

I use this formula, powerapps is not issued any warning

danilomuniz47
Level: Powered On

Re: Powerapps Slow performance with Sharepoint

The list in SP has few items, but one of the fields is text type and there I jump the image in base64 format, because the items must be loaded into a collection within powerapps, and from what I saw there is no possibility to load atachments in a collection nor save with patch

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Users Online
Currently online: 172 members 3,364 guests
Please welcome our newest community members: