I created learning path solution in Teams with Power Automate flows and SharePoint lists. This solution works with basic business license without desktop programs. Business case behind this was my own coach career and need to get online course environment where teams can interact with each other and progress the course the same time. This solution gave me possibility to create the content during the 11 weeks path.

Videos are watched inside Teams but they are actually in SharePoint and presented with Stream
Videos are watched inside Teams but they are actually in SharePoint and presented with Stream

Business Case

  • Learning path instead of education day
  • Walk with the customer (digitally) 11 weeks
  • Offer videos for weekly topic
  • Collect replies for questions every week
  • Ensure discussion about weekly topic
  • Scale consultant time and presence
  • Automate weekly topic information
  • Use Teams as platform for learning

This solution could be used in on-boarding to new Team, creating instructions for new technology, replace small company on-boarding process or in small company solutions when there is willingness to buy separate solution for this kind of functionalities.

User experience

Users get email every week Monday and new week task reveals. User feels that the coach sent the email, created new channel in team’s private team and write questions there. Actually there are Power Automate flows which reads team progression week number, check SharePoint list what are the topics and questions and sends emails, creates channels and posts tagging the team to those.

Architecture

SharePoint lists

Background there are three SharePoint lists containing the weekly topics, questions and links to the videos. Then there is combination of team and team member lists, where email addresses are got and channels created.

Weekly topic list containing descriptions, questions and links to materials
Weekly topic list containing descriptions, questions and links to materials

Power Automate flows

  • Execute weekly topic – Parent flow which will be triggered every Monday and when finds teams that are in progress state, it gets the correct weekly topic and calls child flows
  • Send weekly topic to team – Child flow for sending a email from shared email to team members in combined email. Link to new topic, description and feedback survey link for previous week topic
  • Weekly topic to Teams – Child flow that creates channel for new week topic and posts questions and tags the team members in the teams post
  • Create teams – Runs every day and creates Teams team and other start stuff if it founds new teams in SharePoint list containing create teams status
  • Start test for leadership styles – OBSOLETE, this is done separately manually by email
  • Feedback email to team – OBSOLETE, this is combined in the weekly topic email since it emails only one link to Forms survey about previous week topic
Power Automate flows doing the core logic of the solution
Power Automate flows doing the core logic of the solution

Further AI development ideas

For consultant

  • Process users’ comments and replies, and ask further questions
  • Summarize the discussion about the weekly topic to consultant before weekly meeting
  • Check the participants activity and pinpoint who needs to be reminded to participate
  • Remind users if they have not replied in the end of the week

For team

  • Find tasks from user interaction in written and spoken (Power Automate, AI model)
  • Create summarization of the weekly meeting into Teams channel (Copilot for Teams)
  • Remind about past week agreed tasks in the start of the weekly meeting (which Copilot to use, where is the data and trigger?)