cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MrYYxx
New Member

Question regarding Data Source/ Data Storage

Hi community, 

I want to replace an Excel file where the user first has to input some master data and then answer a bunch of  yes/no questions  (approx. 80). With each question also comes a  text field where the user can add additional information. 

What would here the recommended data source/storage?
I´ve started with SharePoint. Column names would be the questions and associated text field. 
E.g. :
Column Name                              Column Type
Question 1                                    Choice
Add. Information Question 1        Text 
Question 2                                    Choice
Add. Information Question 2        Text 

But it would then have 160 columns within one list and that would hit the SPO list column limit.  

I´m not sure what would be the best approach for that?
I´m thinking of storing the questions within a SPO list, connect them to the Power App and patch the answers to Dataverse or Teams for dataverse?
Could Dataverse (for Teams) store 160 columns in one table?

The other solution I could think of, would be to split the questions and store it all in different SPO lists. But what happens when the user want to save, not submit, the data and then comes back to proceed the input of the data?
I probably need then a master list where he can select the item which he wants to continue with.  But is it possible to create a reference within Power Apps, that the user just select the item in the master list and then all other sublists will open in Power Apps as well?

greetings

4 REPLIES 4
Drrickryp
Super User
Super User

@MrYYxx 

you only need 3 columns. Question Answer and comment. 

Pstork1
Dual Super User III
Dual Super User III

Why do you think SPO has a column limit of 160 columns?  SharePoint has an overall storage limit for an item record (8,000 bytes), but individual columns can go up as high as 255 columns per type per list.

 



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

@Pstork1 

According to this thread there is a limit of 96 yes/no colums.
I will have about 80 but need for every yes/no column a text column as well.
Not sure if SPO can handle this...

Pstork1
Dual Super User III
Dual Super User III

Yes there is a limit of 96 Yes/No columns, but that is independent of the limit for Text columns.  You can have up to 255 text columns in addition to the 96 Yes/No columns as long as you don't exceed 8,000 bytes in the record.  So yes, you could have 80 Yes/No columns and 80 Text columns at the same time.



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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

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,937)