Proper SPO List Development Technique

Copper Contributor

Hope this question is understandable.  I started out with a simple list, but as things go i was asked to make mods to it to include more data.  The list was originally built so the PowerApp form would allow one form to gather data inputs for a number of global locations.


  • Site 1 - Data Value
  • Site 2- Data Value
  • Site N - data value

Then I was asked to add another type of data for the same sites in a way that the person entering could choose what type of data to enter.  I went with a PowerApp form that loaded the appropriate data input questions for that type.



In the SPO list i added columns for this data type and updated the previous type, below.  When imported to PowerBI i had to 'unpivot' the data to get it to aggregate by site.  That worked okay for the data that I had to input.



Now i am tasked to add 5 more data types for each site.  This is quickly becoming unmanageable.  Being a novice is there a better way to do this than continuing to add columns that describe Site/Data Type?

0 Replies