cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Collection Data Deletes After Closing

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

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.

 

 

 

View solution in original post

2 REPLIES 2
Super User III
Super User III

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.

 

 

 

View solution in original post

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.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (101,761)