Hi all!
I'm relatively new to PowerApps and currently building an accident reporting form, this has grown arms and legs but it's been quite enjoyable learning more as I go. I'm almost finished and have patching in place to send all answers to a list. But, now I'm going to need to patch this to multiple lists based on the location of the person logging the incident. I have the app grabbing the persons location so there won't be any human error (or less so). So ideally this would happen...
Person A is from Edinburgh, they will open and complete the app. The dropdown that collects the location will automatically populate Edinburgh so when they hit submit it will go to the Edinburgh SP List I've created.
Person B is from Glasgow, same thing again - once complete they hit submit and it goes to the Glasgow SP List.
Then I'm going to have a "master" List that collates all column values from the other Lists using Lookups or Power Automate - Not sure the best way yet.
Here's an example of my current patch formula....
Set(varRecord, Patch(Results,Defaults(Results),{
'Person Logging Incident':Person_Logging_Incident.Text,
'Reference ID':Reference_ID.Text,
'Affected Staff Member':PeoplePickerBox.Selected.UserPrincipalName,
'Service Location':Dropdown_Service_Location.Selected.Result)
}));
If(!IsBlank(varRecord),
Notify("Your Incident has been reported!", NotificationType.Success),
Notify("Your Incident was not submitted", NotificationType.Error));
Navigate(End_Screen,ScreenTransition.Fade)
Thanks in advance!!
