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

Excel as a data source

Hi ,

I am using excel online as a data source , if multiple users  are using PowerApps application and doing create operation in excel through PowerApps , will it will be successful ??

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

I was being a bit more generous from my experience saying 5-8.  The documentation you are looking for would be the documentation covering concurrent use of Excel Online.  Here's one of the clearer answers.

Any Limit on Number of Users that Can Share a Word or Excel Document - Microsoft Community

For Excel its complicated because the number of co-authors is dependent on what section of the file they are authoring.  Since Power Apps works with tables you have to treat it like everyone is authoring the same set of cells.  For that the official maximum is 99, but with the caveat that anything more than 10 is very slow.  In my experience the performance starts to degrade at 5.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

5 REPLIES 5
Pstork1
Dual Super User III
Dual Super User III

As long as the Excel file is stored in OneDrive and no one has opened the file in the desktop version of Excel, you should be able to support a number of simultaneous users.  But probably not more than 5-8.  More than that and the performance will degrade significantly.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
subhramalya
Frequent Visitor

Thanks a lot .Is there any documentation available in this stuff from MS?? According to my understanding if excel is not opened around 5-6 people can optimally use PowerApps

Pstork1
Dual Super User III
Dual Super User III

I was being a bit more generous from my experience saying 5-8.  The documentation you are looking for would be the documentation covering concurrent use of Excel Online.  Here's one of the clearer answers.

Any Limit on Number of Users that Can Share a Word or Excel Document - Microsoft Community

For Excel its complicated because the number of co-authors is dependent on what section of the file they are authoring.  Since Power Apps works with tables you have to treat it like everyone is authoring the same set of cells.  For that the official maximum is 99, but with the caveat that anything more than 10 is very slow.  In my experience the performance starts to degrade at 5.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Drrickryp
Super User
Super User

@subhramalya 

I recommend this 7 minute video by Shane Young.  https://m.youtube.com/watch?v=RtmZM3tm2Zs 

Thanks a lot. Actually I need to set a limit for my client .Around 4-5 users at a time I will put then.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,131)