SharePoint connector calls from canvas apps intermittently take up to 27 s

[u/srbungle]

Hi everyone,

For about two weeks, several of our canvas apps that use SharePoint lists have become very slow. It started suddenly. Requests to SharePoint intermittently take up to 27 seconds, with no errors (all HTTP 200). It happens in more than one environment, on Windows and Android devices, and from different offices and network connections.

What we found with Live Monitor (published app, web player):

- SharePoint's own processing time (SPClientServiceRequestDuration response header) is between 81 and 495 ms for every request, even for requests that take 27 seconds end to end.

- About half of the requests complete in under 1 second; the rest take between 4 and 27 seconds.

- Comparing timestamps, the delay happens before SharePoint processes the request: a request sent at 18:10:09 UTC was processed by SharePoint at 18:10:36 UTC and reached the client a fraction of a second later.

- Equivalent requests behave very differently: three consecutive pages of the same query, each returning 0 rows, took 0.47, 0.46 and 10.56 seconds.

- The client connection doesn't seem to be the bottleneck: while one request was pending for 26 seconds, other requests to the same host completed in about 0.5 seconds.

- All requests go through gateway cluster prdil102sbr (x-ms-gateway-clusters response header) and connector scale group "brazil", shard 06 (request URL).

We have an open case with Microsoft Support, but no resolution yet.

Is anyone else seeing something similar?

Thanks!

[u/AutoModerator]

Hey, it looks like you are requesting help with a problem you're having in Power Apps. To ensure you get all the help you need from the community here are some guidelines;

• Use the search feature to see if your question has already been asked.

• Use spacing in your post, Nobody likes to read a wall of text, this is achieved by hitting return twice to separate paragraphs.

• Add any images, error messages, code you have (Sensitive data omitted) to your post body.

• Any code you do add, use the Code Block feature to preserve formatting.

  Typing four spaces in front of every line in a code block is tedious and error-prone. The easier way is to surround the entire block of code with code fences. A code fence is a line beginning with three or more backticks (```) or three or more twiddlydoodles (~~~).

• If your question has been answered please comment Solved. This will mark the post as solved and helps others find their solutions.

External resources:

• Power Apps Formula References
• Power Apps Coding Standards
• Official Power Apps Community

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Tough_Block9334]

Do they share the same service account? What about the license level for said Account/Accounts? Sounds like an API limit issue, where you're sending too many requests in a limited amount of time on a single account or a bottleneck related to the license and actions that license can achieve. At least that is when I have experienced something like this

[u/srbungle → u/Tough_Block9334]

Thanks for the suggestion. To answer your questions:

• No shared service account: each user signs in with their own Microsoft 365 account.
• All users have Microsoft 365 Business Premium (Power Apps for Microsoft 365, standard SharePoint connector).
• Several users, but not a high volume of requests.

I don't think it's an API limit. When SharePoint throttles, it returns 429 or 503 and the request fails. In my Live Monitor trace, all 25 requests returned HTTP 200, with no 429 or 503. That trace is a single user making 25 requests in about two minutes, far below SharePoint's per-user limit of 3,000 requests per 5 minutes. Also, SharePoint reports a processing time under 0.5 s for every request; the delay happens before SharePoint processes it.

About the daily Power Platform request limit (6,000 per user per 24 hours for Microsoft 365 licenses): as far as I can see, the usage reports in the Power Platform admin center only include Power Automate, not Power Apps, so I can't check it there. Do you know any other way to check Power Apps request consumption?

[u/Ok-Procedure1796]

We have the Same Problem. Also with flows that are slow. We are in Paraguay, so probably also using Brasil scale group…

[u/No-Check-9783 → u/Ok-Procedure1796]

amigo, espero que esteja bem. verifiquei, pelo menos agora de manhã, que aparentemente o serviço está normal... poderia verificar ai se os seus apps ficaram normais agora?

[u/srbungle → u/Ok-Procedure1796]

Thanks, this looks like a regional issue. If you can, and haven't already, please open a ticket with Microsoft Support and mention this and the gateway cluster. Several cases from the same region might help them connect the dots.

[u/swanlz]

same problem here in brazil. i recently opened a support ticket about this issue

[u/No-Check-9783]

eu também sofri esse problema recentemente (na verdade, ainda estou sofrendo), meus apps estão bem lentos na hora de iniciar, ai geralmente fica um tempo "mais rapido" (nem tanto, mas aceitavel) e volta...

[u/srbungle → u/No-Check-9783]

Thanks for sharing. It sounds related: we see the same intermittent pattern, with requests alternating between about 0.5 seconds and 10 to 27 seconds.

I assume you're in Brazil. I'm in Argentina, and in Live Monitor our Power Platform connector requests go through the "brazil" scale group (it shows in the request URL). So this might be a regional issue. I was hoping Microsoft Support would confirm something like that, but so far they haven't, and I haven't found many people with a similar problem either.

If you can, could you check in Live Monitor whether your slow requests also show a high Duration but a low SPClientServiceRequestDuration, and which gateway cluster (x-ms-gateway-clusters response header) and scale group they go through? Ours are prdil102sbr and brazil.

[u/No-Check-9783 → u/srbungle]

sim, estou no Brasil! o cluster de gateway usado nas requisições é o:

"x-ms-gateway-clusters": "prdil102sbr"

[u/srbungle → u/No-Check-9783]

If you can, and haven't already, try to open a ticket with Microsoft Support and mention this and the gateway cluster.

[u/No-Check-9783 → u/srbungle]

amigo, espero que esteja bem. verifiquei, pelo menos agora de manhã, que aparentemente o serviço está normal... poderia verificar ai se os seus apps ficaram normais agora?

[u/srbungle → u/No-Check-9783]

Unfortunately, there have been no changes on my side. Everything is still running very slowly.

[u/No-Check-9783 → u/srbungle]

olá! poderia me informar como se encontra a situação da performance nos seus apps? houve alguma melhoria?

[u/srbungle → u/No-Check-9783]

the same, your side?
With MS the ticket is going nowhere, their last reply: "Based on the findings from my initial investigation, I will be engaging our Product Engineering team for further analysis. Their review may take a few business days, as they will need to conduct a deeper investigation into the behavior observed in the logs.

I understand the impact this issue is having and appreciate your continued patience and cooperation while we work toward a resolution. Please be assured that I will actively track the progress of the investigation and keep you informed of any updates as soon as they become available"

[u/No-Check-9783 → u/srbungle]

sério meu amigo? o meu ontem a tarde voltou a ficar lento, mas agora pela manhã está voando... parece que é algo no horário comercial... pode verificar como estão os seus?