cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MihirY
Advocate IV
Advocate IV

Is it possible to create PowerApp with 200 fields and i want to store the data in SharePoint list

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.

  1. Create 50 fields in SP list and store remaining fields data into PowerApp local collection. But problem with this approach is, if for some PowerApp got corrupted/deleted then we will be loosing all the existed data.
  2. Create HTML form (with SPFx/.html file with content editor) - This way I can have few fields in SP list, and I can create sub lists with lookup data or I can store some of the fields as json format in multiple lines of text field.

Which approach is best and are there any alternatives for this solution?

1 REPLY 1
codebrane
Resolver I
Resolver I

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

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,953)