Skip to main content

Notifications

Community site session details

Community site session details

Session Id : jYe5wPywklHrg5KA3O0bD6
Power Apps - Building Power Apps
Unanswered

Accessing SharePoint Lists suddenly very slow

Like (3) ShareShare
ReportReport
Posted on 28 Jun 2023 20:44:41 by 33

I maintain two separate quote tools for my organization that tie into Power Automate and that store all of the data for quotes in a SharePoint List.  The list for one of the quote tools has around 25,000 entries and the other one has around 1,200.  Up until yesterday, things were working fine.  There was some slight slowness for the quote tool that has 25,000 entries when it came to pulling up existing quotes because of the size of the list but it was on the scale of 5 seconds or so.

 

Sometime around midnight UTC on June 28th, something changed.  I'm still checking with my organization to see if they changed something but it seems like maybe Microsoft changed something.  For the quote tool with 25,000 entries in the list, it never fully loads the list.  After a long time there the App Checker shows an error that says:

 

"An error occurred on the server.  Server Response: <SharePoint_List_Name> failed: Request to the backend service timed out."

 

With the quote tool that has around 1,200 entries in the list, it takes a solid 1.5 to 2 minutes for the app to fully load the list.

 

As a test to see if it was strictly related to PowerApps, I setup a flow that is triggered manually that just retrieves the first 5,000 items from the large list (5,000 is the max you can do).  After 10 minutes, the flow timed out.

 

I don't know if this is an issue with something my company changed (still looking into that), an issue with the Power X suite, or an issue with SharePoint but I figured I would check here.  I can pull up that SharePoint list without issues and I can export it to CSV and to an Excel iqy file and those all work fine.

 

Anyone else seeing anything like this?

Categories:
  • Tarterman Profile Picture
    33 on 30 Jun 2023 at 15:38:24
    Re: Accessing SharePoint Lists suddenly very slow

    Working properly for me too!  

  • Community Power Platform Member Profile Picture
    on 30 Jun 2023 at 15:25:22
    Re: Accessing SharePoint Lists suddenly very slow

    same. issue fixed this morning. love it.

  • temp2023 Profile Picture
    6 on 30 Jun 2023 at 13:15:59
    Re: Accessing SharePoint Lists suddenly very slow

    Microsoft resolved the Issue, everything working for us this morning. Yay! 

  • StuartSSTech Profile Picture
    36 on 30 Jun 2023 at 09:02:26
    Re: Accessing SharePoint Lists suddenly very slow

    Just adding that i have also had 2 Clients report the exact same errors with Timeout on connections. I cant see anything confirming a known issue but appears like it. Not got any visibility on if the issue is fixed yet but you are not alone 🙂 

  • webbedfeetmaest Profile Picture
    81 on 30 Jun 2023 at 08:26:56
    Re: Accessing SharePoint Lists suddenly very slow

    yep now working again for me too!

  • DataChris1 Profile Picture
    13 on 30 Jun 2023 at 07:58:47
    Re: Accessing SharePoint Lists suddenly very slow

    Now working normal speed!

  • mcacer_123 Profile Picture
    4 on 29 Jun 2023 at 19:18:26
    Re: Accessing SharePoint Lists suddenly very slow

    Same problem since yesterday. My app is still working, but it seems to be loading data permanently, and has low performance. Has anyone found a solution yet?

  • temp2023 Profile Picture
    6 on 29 Jun 2023 at 19:14:37
    Re: Accessing SharePoint Lists suddenly very slow

    We have exact same issue. PowerApps connecting to SharePoint Online was working fine until Tuesday after noon, then all of a sudden keep spinning with data not loading and then timed out. SharePoint List has limited rows (less than 2000).

  • pdog763 Profile Picture
    66 on 29 Jun 2023 at 19:06:37
    Re: Accessing SharePoint Lists suddenly very slow

    We are slow too.  I checked the services health in the Admin portal and it says "Healthy".   This is the only forum I can get confirmation of performance issues.  The analytics feature within the Admin portal only goes through 6/24 so it's useless.

  • webbedfeetmaest Profile Picture
    81 on 29 Jun 2023 at 16:41:42
    Re: Accessing SharePoint Lists suddenly very slow

    since yesterday my deeplinks are taking 2-3 mins to load records too. reading other threads here there seems to be a Microsoft bug.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard
Loading started
Loading complete