@Elitezone ,
@Drrickryp has given you some sound advice and can only respond to your requirements as you relate them in the particular comment. I will give you another idea here, but it is syntax/structure guidance and you will need to understand the concept to implement it.
Firstly, do this at App OnStart
Set(varUserMail,User().Email)
Then create a new list in SharePoint with all the columns (same names and types) as the Collection as well as an additional one called UserMail - I have called the List StoreList below - you can call it whatever you want.
At App OnStart after the code above get the contents of the list that belong to the user
ClearCollect(
CollectionName,
Filter(
StoreList,
UserMail=varUserMail
)
)
Now (this is actually the first bit to make it work) when you want to save this before the user exits - you will have to decide where to run this - update the contents of the user's collection, firstly by removing existing records and then adding the collection to it as new records.
RemoveIf(
StoreList,
UserMail=varUserMail
);
Collect(StoreList,CollectionName)
One small thing you will need to do is if the user adds a new record to the collection (you did not specify this), the field UserMail will need to be populated with varUserMail value.
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.
