Adventures with Power Platform: Agilicious

I am part of a small team at Microsoft that covers the Power Platform for over 100 customers.

We are all very busy, and we rarely have the opportunity to sync on what we are all up to or what help we need.

I decided to write an app, with the features:

• We can share what we recently completed.
• We can also share what we are doing and what help we need.
• Post notifications to Teams and/or Outlook.

I called the app Agilicious.

Solution components

Let’s take a look at the components of the Solution.

Tables

Agilicious Report – Captures daily activity in a Scrum like format.

Agilicious Filter – Events can be imported from Outlook to populate daily activity. This table includes filters to limit what is pulled in automatically.

Agilicious Notification – Notifications can be sent to Teams. They can be directed to either a Channel or a Chat. You can also send them to Outlook as an email notification.

Choices

Agilicious Notification Type – Used by Agilicious Notification to decide if the notification is for Teams or Outlook.

Agilicious Notification Teams Integration – Used by Agilicious Notification to decide if the Teams notification should post to a Channel or a Chat.

Security roles

One Security Role for Users, called Agilicious Users, and another for Administrators, called Agilicious Administrators, each providing access to the Tables.

Connection references

Agilicious Microsoft Dataverse Connection Reference – Manages connection to Microsoft Dataverse.

Agilicious Microsoft Teams Connection Reference – Manages connection to Microsoft Teams.

Agilicious Office 365 Outlook Connection Reference – Manages connection Outlook.

Cloud flows

Agilicious Report Name Update On Added Or Modified (Automated) – Updates the Name of the Agilicious Reports whenever a record is added.

Agilicious Notification Send (Power Apps) – Sends notifications to Microsoft Teams and/or email, the latter using the Outlook connector.

Agilicious Notification Text Format (Power Apps) – Child flow to format text for Teams and Outlook notifications.

Agilicious Event List (Power Apps) – Imports a list of Events from Outlook for a specific date.

Apps

Agilicious Admin – Model-Driven App for Administrators to manage the application. They can manage global Filters and Notifications. They can also fix data entry errors.

Agilicious – Canvas App to manage user Agilicious Reports, Agilicious Filters and Agilicious Notifications.

Let’s go on a tour

Let’s take a look at the application, which you can download for yourself at the end of this article.

Loading Screen

This is my StartScreen, where I do all my start-up activities, everything I used to do in OnStart.

Home Screen

This is what the user sees after they log in.

Users can view their most recent reports, add a new report and manage both filters and notifications.

Report Edit Screen

This is how users can add, edit, and delete reports.

What did I accomplish yesterday is populated with the value of What will I do today from the previous day.

What will I do today is populated with Outlook events for the current day.

Report List Screen

Displays a list of user reports.

Additional Screens

Filter List Screen – Displays a list of both Global and User defined filters.

Filter Edit Screen – Add, edit or delete User defined filters.

Notification List Screen – Displays a list of both Global and User defined notifications.

Notification Edit Screen – Add, edit or delete User defined notifications.

Embedded in Teams

Lastly, for kicks and grins, I embedded it with in a Teams chat.

You can find the entire solution at https://github.com/mattruma/Agilicious.

Let me know what you think!