Power Automate + SharePoint List = Teams Meeting

Like (0) Share

Report

Posted on 24 Jan 2024 09:36:00 by JeetS

Good morning,

I have been trying to do the following since Monday (bear in mind I am relatively new to PA and SharePoint Lists):

I have created a List with the following columns -

I am trying to setup a Flow using PA to read the User Name column from the List and send a Teams Calendar invite to that user. At this present moment this needs to be a manually triggered Flow rather than automatic as we need to be able to control when the invites are sent out.

I have gone through the process of setting up the Flow but try as I might I am unable to figure out how to get it to read from the SharePoint List. I am up to the point where I have added the step to Create a Teams Meeting and I have added the Required Attendees parameter and thought this is where I would be able to point to the List -

Any help and guidance would be much appreciated.

PS. Please note that I am locked down to these apps only therefore please do not suggest using anything other than Power Automate, Lists and Teams.

All responses (2)

Answers (0)

JeetS on 24 Jan 2024 at 16:33:52

Like (0)

Report

Re: Power Automate + SharePoint List = Teams Meeting

Hi Tjan,

I will add this and give it a go. I have also amended my List so that it looks like such -
The attendees column is also setup as a Person columne as opposed to just a text column like I had earlier.

Appreciate your suggestion and I will update to confirm if it helps.

Regards
Jeet
Tjan 1,087 Super User 2024 Season 2 on 24 Jan 2024 at 12:49:44

Like (0)

Report

Re: Power Automate + SharePoint List = Teams Meeting

Hi @JeetS , have you used the ''Sharepoint List Rows'' actions before the Create a Team Meeting action? This is necessary because you need to fetch all rows first. Afterwards you can map the mail of the attendee to the required attendees field (maybe you need to add this column since I don't see it in your list).