Covi Org

• 

  Covi Org is a Power App that provides you the ability to view trends and tracker your employees status

Inspiration

Was looking for an easier way to update and share the vaccination status with the employer and then this idea sparked in me

What it does

The core of this project is to minimize the effort need to update the vaccination status of the employees, send adaptive cards to the unvaccinated employees from Power Apps which in turn triggers a Flow from Power automate to send out emails

These details are gathered in Cosmos DB and the graphs are generated in configurable timer trigger

Challenges I ran into

How do to push images separately into blob storage, the images were overlapping initially when I used pandas plot (under the hood matplotlib) to generate them

Accomplishments that I'm proud of

Pulling off this entire thing in just 2 weeks (weekends work)

What we learned

How to use an adaptive card to get data and store it in DB How to generate graphs in near real-time

What's next for Covi Org

To add more features such as having a configurable timer trigger (1 month or every week) that can send out emails to the unvaccinated employees

Built With

• adaptivecard
• azure
• azureblobstorage
• cosmosdb
• powerapps
• powerautomate
• python