I am looking to create a surveying app in which each survey will be saved (as one row) to a SharePoint (SP) list.
Examples of SP columns
| Project ID | Single line of text |
| Project Name | Single line of text |
| Date of Survey | Date and Time |
| Address | Single Lin of text |
| Surveyor | Person |
| Windows | ??? |
| Notes | Multiple lines of text |
I am comfortable with how I can collect and save the surveyors data in PowerApps (PA) to SP for the most part. However I am not quite sure of the best way to save the "Windows" data. I know how to collect it using inputs, galleries and collections and potentially I'll know how to save / write / submit / patch to the "Windows" column, I just don't know what data type the column should be. What I'm trying to achieve is similar to how a person column works where it can hold the persons name, email, telephone etc.
An example of the data this column will hold is...
| Name | Width | Height | Glazing | Notes |
| Window 1 | 600mm | 1200mm | Double | Needs replacing |
| Window 2 | 800mm | 1200mm | Triple | Needs cleaning |
Options
One way I see it is I could create a separate SharePoint list which all the window data is written to (1 row per window). However this information is not really important enough to warrant it's own sperate list and it doesn't really need to exist outside of this survey.
Another way I can see to do it is to allow the user to enter the data into a gallery with text inputs, patch the inputs to a collection, concatenate the collection into one lump of text (with separators) and save it to a multi line text column. On retrieving a past survey, if needed I can use split to separate the text into a text or gallery.
Another way I can see it working, but I am not sure if it is possible, is to somehow save the collection in it's entirety to a single SP column. I know that you can have collections nested in collections I just don't know if it can be applied to SP.
Help
Does anyone have any ideas, of how I could achieve this? or if there is another or better way to do this? If you need more info, please feel free to ask.
Thanks in advance.
Kind Regards
Ben
