top of page

Power Automate cloud flow that takes a Teams transcript and Summarises via GPT4


A shark and some Power Platform logos

UPDATED, NOW WITH ADDED CONFIGURATION STEPS, what a wally I am.


Hey,


How are you?


It's been a while, but I'm back and below I will show you a Power Automate cloud flow that takes a Teams transcript text file, summarises it with GPT4 via Open AI studio and then sends the summary to the meeting organiser, for them to approve to send it to all participants in the meeting.


I have added the solution as unmanaged and it is on my GitHub repo here:



You know what, it would be helpful if I provided a guide to actually help people configure this, so here we go:


Installation instructions

  1. Download the latest version from the repo.

  2. Go to https://make.powerapps.com

  3. Select the right environment you want to import the solution into

  4. Click Import Solution on the ribbon

  5. Browse to the solution zip file

  6. Click Next

  7. Click Next again

  8. Next you need to make sure you have an Open AI API key, you can get one from https://platform.openai.com

  9. Then you need to go to https://portal.azure.com and click on App Registrations, give it a name and click register.

  10. Take a copy of the Directory (tenant ) ID

  11. Take a copy of the Application (client) ID

  12. Click on API permissions and give all of these permissions to the App Registration:

  13. Click Grant Admin permission for

  14. Click on Certificates and Secrets

  15. Click New client secret

  16. Make a copy of the value

  17. Go back to the solution import, paste this in the TS Graph Client Secret field

  18. Paste the Tenant ID (from step 10) in the TS Graph Tenant ID field

  19. Paste the client ID (from step 11) in the TS Graph Client ID field

Next steps are optional:

  1. Go to https://dev.azure.com (you will be promoted to sign in, and probably taken back to the Azure Portal)

  2. Click on Azure DevOps Organisations

  3. In the top right hand corner click the person cog icon:


  1. Click Personal Access Token 25.Click New Token


  1. Complete as per the screenshot

  2. Click Create

  3. Copy the Personal Access Token (PAT Token)

  4. Click Close

  5. Paste this in the TS ADO PAT Key field back on the solution import page

  6. Click Import

You can find this guide with screenshots on the Readme file in the repo here.


Special thanks to Louisa Kristensen for pointing this out to me, and apologies to anyone who might have struggled.


Please see the video for more details:




Here is the actual summary from the video that used the flow to summarise itself. Yeah. What. I don’t even know if that’s English.


Teams Meeting Summarizer - Meeting Notes (2024-05-04)

Agenda Items

  • Demonstration of the Teams Meeting Transcript Summarization Flow

  • Review of the flow's components and operations

  • Decision making on the approval process for summarized notes distribution

Discussion Points

  • Jon Russell showcased a flow he created that processes and summarizes Teams meeting transcripts.

  • The flow waits 15 minutes post-meeting, then chunks the transcript to avoid exceeding OpenAI's token limit.

  • The summarized notes are sent back to the meeting organizer for review.

  • There's the potential for integration with wikis, although not covered in the meeting.

Decisions Made

  • It was decided to include an approval step where the meeting organizer can confirm before sending the summarized notes to all participants.

  • Jon mentioned plans to make the flow available on GitHub for public use.

  • The flow's challenge with programmatically finding the meeting URL needs addressing.

Action Items

  • Jon Russell to post the flow on GitHub and his blog.

  • Jon to work on a solution for automatically retrieving the meeting URL.

  • Further exploration into adding content to wikis using the flow.

Attachments/Documents Shared

  • Flow demonstration video by Jon Russell.

  • Link to the blog post and GitHub repository for the flow (to be provided).

Additional Information

  • Jon@jondoesflow.com provided insights into the technical details of the flow.

  • Further assistance may be needed for the meeting URL retrieval issue.

 
 
 

Recent Posts

See All

4 Kommentare


rustcat64
09. Apr.

Fascinating approach, cutting edge work. I have (hopefully) a simpler use-case. MS Teams automatically creates the AI-recap (when transcription is turned on) and posts it to the meeting recap section a few minutes after it has ended. We have an anal-retentive retention policy of 30 days after which these recaps disappear. I'd like to simply copy the recap that Teams generated and paste it back into the meeting chat so it exists beyond the 30 day period. Is this possible? Thanks again!

Gefällt mir

Hi Jon, Good video. I found an easy way to dynamically get the online meeting url you mentioned in the video. I added steps Get Event (V3), converted body to text (Html to Text), set substring indexes (from "https://teams.microsoft.com/l/meetup-join/" and 243 characters, because didn't want to waste too much time :) ) and set it in a variable. Hopefully helps

Bearbeitet
Gefällt mir
Antwort an

Hi Timo,


What was your Value for setting the variable? I can't seem to manage to pull out the onlinemeetingID, just sets to 0.

Gefällt mir

tomas kopas
tomas kopas
31. Jan.

Hi Jon,


thank you for a wonderful tool, would you help me out how to get the meeting URL from the BODY of step 1 so it can be used dynamically in step "HTTP call to get the Online Meeting ID" ?


Many thanks and Regards,

Tomas.

Gefällt mir

Subscribe Form

©2019 by Jon Does Flow. Proudly created with Wix.com

bottom of page