powerapps - Save progress of users in powerapps and it doesn't start with new instance everytime same user opens the app

Question

I have created an new joiner onboarding app for my team in PowerApps. I am using an excel connector to add data in a collection. This collection is then used to create a list of to-do-tasks. I am giving user the option to mark a task as completed (i.e. patch the relevant row in my collection). I am not updating records in my excel file because that is a common data source for all new joinees.

Now, everytime the user exits and restarts the app, the collection gets loaded from scratch and all the progress (tasks completed are reset).

Is there a way to save the progress of these tasks per user basis?

PS: I know one way is to create outlook tasks (by using o365 user profile) from the powerapps and load it everytime. But I don't want to use Outlook tasks.

标签： powerapps

Answer 1

PowerApps 集合是临时数据存储。将它们视为一种内存类型的表，当用户关闭应用程序时会被擦除。您将需要一个适当的数据源来存储用户会话之外的记录。有很多选择。最简单的是 Sharepoint 列表。

就像您从电子表格中修补集合一样，您需要让用户“提交”他们的数据并将其修补到适当的长期数据源。