Hi,
The file shows a super simplified version of what is going on and hopefully shows what I'm trying to achieve.
I'm trying to build a pretty simple app but I'm struggling combining data sources. I might be doing this all wrong. I'd take ideas on how to do it or if you can solve where I currently am that would be great too.
What the app should do is allow management of user requests from various MS Forms. All the requests need to sit in a master view 'unassigned'. The list should have some key fields visible and when you click on the record you are taken to the full detailed view where it can be assigned and all the response fields from the MS Form can be seen. There's a load of other functionality but I'm sure I can manage that once I've got the data sorted.
Here is where I am:
- There are various MS Forms for users to complete for different services/requests - I can't change this.
- I have created sharepoint lists for each MS Form
- I have also created an 'overview' list with key information from the sharepoint lists for the MS Forms
- I haven't combined all the responses from all the forms into one master list due to all the different questions in the forms - would result in a massive list full of columns with some empty and some populated depending on which form was used (maybe my first mistake?)
- Automations add the results from users MS Forms to it's corresponding sharepoint list and the overview list
- Automation creates unique job number and puts in both lists (forms sharepoint list and overview list)
- The app is basically a gallery with the data source being the sharepoint 'summary list'
- I thought I could use the job number from the summary list to lookup the job detail in the corresponding forms sharepoint list and pull the detail from there with the job id
- I can't figure that part out. If I can get the data working, I can do all the other bits.
Thanks for any advice offered
