In
the previous article Peter Kalmström, CEO and Systems
Designer of kalmstrom.com Business Solutions, created a
Power Automate flow that runs through a SharePoint Task
Templates list each morning and creates instances of the
tasks for the current date in a Tasks to Do list.
In the demo below, Peter describes how to create a powerapp
that shows the unfinished tasks for the current date. With
this app, users can see today's tasks set them to Done directly
in their mobiles.
Create a Tasks To Do powerapp
In the Power Automate site, create a blank canvas
gallery app and connect it to the SharePoint Tasks To
Do list.
Show only the Title, and insert a Text label, "Tasks
To Do".
Add a toggle and set its value to the same as the
Done column in the SharePoint Tasks To Do list. The
toggle is automatically called Toggle1.
Add a Refresh icon and set it to refresh the app
with data from the SharePoint Tasks To Do list.
To save app actions back to the SharePoint Tasks
To Do list, select Onselect and set the toggle to update
the Done column in theSharePoint Tasks To Do list with
the value of the current item: Patch('Tasks To Do',ThisItem,{Done:Toggle1.value}).
Add another action in the formula bar to notify
that the new value is saved: Notify("Task Saved").
Filter the gallery so that only unfinished tasks
are displayed in the app: Filter('Tasks To Do',Done=false).
In the
next article we will enhance the powerapp with a
Search feature.
Learn more
Software that enhances SharePoint
Kanban Task Manager Visualize and co-operate on projects and tasks in SharePoint
and/or Outlook
Pivot Explorer Visualize and analyze list data in SharePoint
Templates Manager
Find, use, manage and distribute Office templates in SharePoint