cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nagaviswanath
Kudo Commander
Kudo Commander

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
v-yamao-msft
Community Support
Community Support

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.

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

 

 

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.

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,

 

 

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

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors
Users online (2,311)