Forum Discussion
How to create multiple “task” items using PowerApps
- Yes that is possible, but I sorry when you said multiple stores I thought you might be using multiple destination lists. The command you want in the forecast is patch.
I'd use Planner if I could lock down everything except allow the user to only see their own store's tasks and only be able to select "Done". We need to issue task in bulk and then ensure nothing gets changed.
Meanwhile, I have managed to create a working prototype to prove the concept.
I start with an Input list where a Home Office person will issue the task and assign it to a group of stores.
Then, I have a button using ClearCollect and ForAll against a table of stores to create a table of tasks with one row per store. That is displayed in a gallery for a preview.
Then, a button uses another ForAll and a Patch function to write it all into a SharePoint List which will function as the Task list. I will secure these with a workflow so that stores can see only their own tasks. A simple PowerApp form will give them only the option to check it as done and probably some comments.
This is all to me quite amazing considering this is something we likely would have purchased a third party product for (and we still might, if I don't perfect it...but I suspect I will).
Thanks so much!