Inspiration

I have always used Azure for all my hackathons and personal workloads for the past three years and had some curiosity to get into multi-cloud and this hackathon gave me an awesome platform for exploring GCP and AWS. Microsoft Teams is almost used by all teams as their primary communication channel so anything that is connected to it makes dev's life easier and that's what this project is all about. Give developers a single platform to get a clear picture of how things work.

What it does

  • Assigning and managing tasks for each report according to employee's available bandwidth with duration
  • Created an end-to-end workflow from EPM reports to Teams messages
  • Extract insights from reports and post about them in the Teams channel
  • Create an emergency SMS alert system with Azure Communication Services (work in progress)
  • Alert people on the Teams channel about tasks and reports

How we built it

  • Azure Functions - process lists and find people with available bandwidth
  • Power Automate - Flow management and access various services to store and manipulate data
  • Microsoft Teams - Alert team members on the work in progress and updates
  • Microsoft Outlook - Receive reports and alerts from Entra Permission Management system
  • Power Apps - for better visibility of data and flow control

Challenges we ran into

  • initial effort on setting up the account and getting the free trial setup in the correct Azure account
  • No API to directly integrate with Azure Functions

Accomplishments that we're proud of

  • Connecting and authorizing Entra Permission Management to all the three cloud platforms
  • Made the connection to SharePoint via Graph API seamlessly
  • Learnings of how to be security conscious and compliant with Entra Permission Management

What we learned

  • How difficult is it to setup best practices and security best practices
  • Monitoring systems across various cloud platforms is important
  • Use less or permissions only ask for what you need

What's next for Secure Flow

  • Work in progress to extract data from a CSV file and use it in a Power BI dashboard
  • Automatic download of CSV file into Azure Function and process relevant data
  • Answer questions and queries from Teams Channel
  • Use Power Apps to kind of give an easy interface to work

Built With

Share this project:

Updates