Hello,
I am trying to create a log that a single user per shift (AM/PM/Overnight) uses to track completion of certain duties. I used Shane's video series (https://youtu.be/HUX_0AA4-Hs) on an expense report tool as a baseline to make it. It uses Collections and Galleries to create an editable list that will ultimately submit to Sharepoint. I am running into some problems however with the transition of usage. Since Powerapps only keeps locally stored data for Collections and will delete the data if the app is closed...I have a few problems:
1. I would like the user to be able to leave the app (it is integrated into Teams) and come back and resume progress. This currently clears the collection and they lose all of their work.
2. It cannot be stored locally, because another user at shift transition will log into a different computer and access the app to "take over" responsibility of this duty. So it would need to be a data source accessed remotely.
3. At the end of the day, the data needs to be submitted in a final Sharepoint List that can be used for reporting purposes. So, cannot have any duplicates and needs to be clean and accurate. I am afraid that if I have some sort of Sharepoint connection that pulls the data from a list where the previous user saved it, it will pull all the data from previous days and duplicate it in the final Sharepoint list. Not sure exactly how that works.
Any help with this would be very much appreciated!!
