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

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)

5 REPLIES 5
Highlighted
Dual Super User II
Dual Super User II

@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.

Highlighted
Community Support
Community Support

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

Highlighted

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

I use this formula, powerapps is not issued any warning

Highlighted

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

Highlighted

Hi,

 

Did you ever get to the bottom of this?  I am having the exact same issue and it's holding me back from having a great app!

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

Users online (12,244)