cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Collector
Kudo Collector

Saving Data to Sharepoints lists (VS) Excel on Onedrive

Hello Team,

 

Would you please suggest the best option to store data between Sharepoint lists and Excel on Onedrive.

Each month, ~ 3000 rows going to be added to datastorage of my application. I will be waiting for the pros and cons for both the datastorages.

 

Awaiting for the information.

 

Kind regards,

Naga

 

6 REPLIES 6
Highlighted
Community Support
Community Support

Re: Saving Data to Sharepoints lists (VS) Excel on Onedrive

Hi Nagaviswanath,

 

When using SharePoint list, we should know that not all types of columns are supported in PowerApps, and not all types of columns support all types of cards, moreover, PowerApps doesn't support columns that support multiple values or selection.

 

There are known issues when using SharePoint list,please check this documentation for a reference: https://powerapps.microsoft.com/en-us/tutorials/connection-sharepoint-online/

 

When using Excel on OneDrive, there are also known limitations, we should format the Excel file as a table, and If your Excel data includes a calculated column, you can't use it to build an app, and you can’t add that data to an existing app.

 

Please check this link for more details:

https://powerapps.microsoft.com/en-us/tutorials/cloud-storage-blob-connections/

 

 

Best regards, 

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Kudo Collector
Kudo Collector

Re: Saving Data to Sharepoints lists (VS) Excel on Onedrive

Hello Mabel,

 

I am using all the single line text fields and 30+ users will just add entries every month of their time sheets. And i have already created an app from scratch. I just wanted to know whether Excel/sharepoint lists can handle 3000 rows/month and it increases to 3000 x 12 = 24000 for one year and so on.

 

How many rows does Sharepoint lists supports and are there any limitations regarding storage?Sharepoint_Lists.PNG

 

 Does excel support to store data of 30+ users in a single excel file as we need to format the table in excel file to use.Excel-Data.PNG

 

 

Highlighted
Community Support
Community Support

Re: Saving Data to Sharepoints lists (VS) Excel on Onedrive

Hi Nagaviswanath,

 

I haven't seen a related documentation about the storage limitation of SharePoint list/Eacel table.

 

I will try to confirm it from my side then back to you.

 

When using Excel file as data source, you will have to format the Excel file as a table so that you can use it as expected.

 

Best regards, 

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Kudo Collector
Kudo Collector

Re: Saving Data to Sharepoints lists (VS) Excel on Onedrive

Hello Mabel,

 

I have formatted the excel into a table called "table2" and it worked for me. When i shared the excel file(can edit) to another user, he is getting following error:

Excel_Table-error.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Please let me know how could it be resolved.

 

Kind regards,

 

 

Highlighted
Post Patron
Post Patron

Re: Saving Data to Sharepoints lists (VS) Excel on Onedrive

@v-yamao-msft Have you found any thing ? I also have the same questions?

Highlighted
Advocate I
Advocate I

Re: Saving Data to Sharepoints lists (VS) Excel on Onedrive

bump. I am researching the same thing. Both excel in OneDrive for Business and Sharepoint work in my testing, but I'm wondering how well this will scale. What happens when muliple people use the PowerApp at the same time?

 

Anyone tried both and decided to use one over the other?

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Users online (3,703)