Collection Data Deletes After Closing

[tbush33]

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!! 

[WarrenBelz · Accepted solution]

Hi @tbush33 ,

You cannot store locally with Power Apps as it is a cloud-based solution, however the only way to solve your issue would be to set up another list with the fields from the collection and at App OnStart load all the records belonging to the user into the collection. You would then need a disciplined exit/save process (closing the tab will not work here) which firstly deletes all current user records that would have been loaded and replace them with what is in the collection.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[WarrenBelz]

Hi @tbush33 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.