You’re offline. This is a read only version of the page.
137
So I have a checklist that I want to use PowerApps to complete. (Heads up, I'm a self taught amateur with no experience setting up SQL tables or any kind of data structure, which is why I'm using SP 😄 )
The checklist is quite long, and each point on the list has a Yes/No/Positive requirement.
If a user selects No or Positive, then they need to be able to add a text description and a picture.
If no, they have to be able to add names and dates.
I understand using variables to activate text and image input depending on the selection of Yes/No/Positive, so that's not a problem.
However, structuring the SharePont list is giving me a headache. Unless I'm overthinking it, it seems like this may be too big of a dataset to be able to hande in a SharePoint list.
Say I have 10 permanent and pre-defined areas that i need to report on, and 7 possible data entry points.
Just thinking out loud, it seems like the only way to hande this is to have 10x7= 70 columns.
Is that correct, or am I missing something?
For example, I would need the following columns for "Area 1, Arrival" :
Area 1, Arrival Text
Area 1, Arrival Dropdown value
Area 1, Arrival Imagecolumn
Area 1, Arrival Name 1
Area 1, Arrival Date 1
Area 1, Arrival Name 2
Area 1, Arrival Date 2
And then the same for all of the area specifications. Is that correct?
It is a possibility, however I would create another list where you register the names and the dates. This would result in your original SP-list only containing the columns Area, Area specification, Text Input, Dropdown and Picture. Another SP-list would have the columns Name, Date and a lookup-column to relate a row from this second SP-list to a row in your original list.
You can watch this vid on how to add a lookup column: https://www.youtube.com/watch?v=H_8jrMzP4Og
Share
Report
All responses (
Answers (
