Hello Everyone,
I created an app in PowerApps for a cleaning business. The users are the cleaners which allows them to enter the location they are cleaning and pull up a checklist/list of items to do. They are able to update the status of the checklist items as they go through it.
SharePoint Lists
List 1 Incident Information - Users enter the home address, date of service
List 2 Checklist Items - a predetermined task lists that they need to accomplish. users must update each checklist item status (open, pending, closed)
List 3 Unique Incident Checklist - Checklist items that are tied specifically to a unique incident
My problem is there could be multiple teams of cleaners that go to different locations at once. So different users could use the checklist template at the same time. I tried to solve for this by creating List 3 that will store all of the checklist items with the Incident ID.
In order to manage this, I tried to create a flow in which the trigger is when users enter an incident information in List 1, all checklist items in List 2 will be copied into List 3. There will be a column in List 3 for List 1's ID.
Is there a way to get the last submit ID in List 1 and update all the copied item column in List 3 to show that particular ID?
