web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Excel Online Connector...
Power Apps
Unanswered

Excel Online Connector Limitation with Powerapps for concurrent users

(0) ShareShare
ReportReport
Posted on by

Hello,

We have a PowerApps App connected with Excel file having less than 2000 records. This app displays a single record from the Excel file that the user has to update.

In the above scenario, If throttling limit for Excel Online connector is "API calls per connection" == 20 as mentioned in the link here , Does it mean, 20 users can work with this app and update data in Excel file simultaneously OR for PowerApps, Is there any different limitation for concurrent user access?

Also, How do we verify the number of API calls occurring in this App with Excel Online connector?

Thanks and Regards,

Categories:
I have the same question (0)
  • mdevaney Profile Picture
    29,989 Moderator on at

    @dave8 

    Did you mean to reply to your previous post created this morning instead of starting a new topic?
    https://powerusers.microsoft.com/t5/Building-Power-Apps/What-are-the-performance-issues-for-PowerApps-connected-with/m-p/525480/highlight/true#M160896

  • v-xida-msft Profile Picture
    on at

    Hi @dave8 ,

    The 'API calls per connection' is 20 means that you could send 20 HTTP Request calls at most to your Excel file from your canvas app in one minute (through per connection).

     

    Actually, PowerApps canvas app inherits data access permission from data source itself. If there are multiple users (> 2)  updating data within your Excel table simultaneously, they may face a Conflict Update Error on their side.

    In addition, when you open your Excel file in web browser, you could not update the data within your Excel table due to File Lock mechanism.

    Note: Actually, when you made changes to your Excel table using built-in functions in canvas app, it essentially send a HTTP Request call to your Excel file.

     

    If you want to verify the number of API calls occurring in this App with Excel Online connector, I afraid that there is no direct way to achieve your needs. As an available solution, you could share your canvas app to 21 end users, and share your Excel table to these users. And then ask them to run your app, and add new entry, then click "Submit" button simultaneously, then check if the throttling limit error would show up.

    Note: Actually, the API calls limit is specified within the Rest API supported for the Excel Online (Business) connector. Currently, we could not change this limit

     

    Best regards,

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard