I am having a requirement to convert existing excel document to PowerApp. Excel sheet contains more than 200 fields. Since client is already having E5 license, client want to utilize SharePoint to store the data. But question is, is it good idea to store the 200 fields data into SharePoint list with PowerApp?
I know there is limit for SharePoint list columns based on data type. But I am thinking, it is not good design with PowerApp and SharePoint list form. I am thinking of below options.
Which approach is best and are there any alternatives for this solution?
Perhaps you could segment the fields into functional groups. e.g. fields that apply to users (name, email etc), fields that apply to machines (ip address, manufacturer) etc. Each functional group would have its own Sharepoint list and add each list as a DataSource in the PowerApp. You could then have a top level screen in the app that lets users drill down to the fields they need to change. A bit unwieldy if they have to edit user and machine information but 200 fields is unwieldy anyway.
Alistair
User | Count |
---|---|
257 | |
110 | |
97 | |
57 | |
41 |