Create Teams meeting link from Power Apps and Power Automate for Outlook

[@debbilawson9619]

These videos of yours are GREAT! Years later, they still add value. I am looking for how to find out what Teams the user is a part of, and what tags they have attached to them within the team.

[@mappingman]

Thanks Shane. Great video as always. One thing I have been working on is creating Outlook meetings and using a rooms resource calendar for the location. I have it working for the most part. I had some issues with time zones and ended up having to finagle the start and end times using UTC time which was a pain. This will help me in the next evolution of the app so that we can schedule Teams meetings. I hope to adapt this to use the rooms resources for locations. I'm also going to need recurring meetings so management can have their regularly scheduled meetings. You know, like your previous corporate job :) Looking forward to watching the next video you've made for recurrence. I also need to adapt this to existing meetings.

[@annadewitt123]

Thanks for these great videos on PowerApps. Your videos help me a lot in this journey.

[@ShanesCows]

You’re welcome Anna. 🐶

[@tenisviejos]

Thank you. This new feature opens a lot of possibilities and it was already needed for many applications we're already using at work. Thanks a lot!

[@ShanesCows]

That is great news!

[@Anihe]

Absolutely loved this! One thing I'd really like to see is auto-send calendar invite from a pre-existing event with the click of a button. We host in-house courses, and now we're sending invites manually from sign-ups on forms. But this gave me the idea that the invite could be sent automatically. Btw, I got a lot of creds at work because of your videos :D Thank you!!

[@ShanesCows]

I built exactly that for a customer. 🐶 You have all the pieces here.

[@kristhelorellana7268]

@@ShanesCows URL?

[@latrobe15]

Great video as always Shane. In relation to recurrence, I create teams meetings in Power Automate. It shows recurrence. You can also view the code. Not sure if it can be translated to here but might give you food for thought

[@asimrehan73]

Wow… thats so useful Thanks Shane.

[@ShanesCows]

My pleasure!

[@jwnin94]

Very nice class! You help me so much! Please, help me with recurrence!!

[@kerrymerchant29]

Hi Shane! Love this as always. are we able to "require registration" with an input?.

[@ShanesCows]

I am not sure, I haven't tried that one. 😑

[@PeteLewton]

Awesome vid! Is the teams meeting link durable? Meaning if a customer reschedules will looking up the teams link bring in the latest appointment info?

[@ShanesCows]

I don't think so. :(

[@edoedikson9560]

Hey Shane! Amazing video, even few months later it works like a charm! Do you know if it possible to attach documents to the meeting invite like we can directly in Outlook? Thanks!

[@nikhiljose5124]

Yeah even i was looking for the same but couldn't find it kindly let us know.

[@ShanesCows]

Not that I know of.

[@michaellussem1777]

Nice, but what is with changing event-settings via Powerapps, like "who is allowed to share screen". Any ideas or not possible? Best regards from Germany!

[@ShanesCows]

I don't know how to do any of the fancy stuff. Sorry. You might look to see if the Graph API has any settings that would let you do it that way. Not sure.

[@yvonnewright464]

Excellent. Thanks Shane.

[@ShanesCows]

Glad you liked it. 😀

[@marcocruz8440]

Man great content this week

[@ShanesCows]

Thanks Marco!

[@criikette5000]

not sure if/when you'll see this, but have you come across any way to create a meeting in an MS Teams channel calendar via PowerApps or Power Automate? I was hoping that was what this video was going to show

[@yogeshkapoor116]

Hi Shane, thanks for all the great videos. They are very helpful. I have a question - is there some way such that we can still use on-premise data gateway with Windows server 2008 r2?

[@ShanesCows]

I am not sure. I have never tried.

[@learnalittleeveryday7848]

Great. These videos help so much. For automatically sent invites that don’t need changes this is really useful. Is there any way to make the meeting invite email show to the user before sending so that a formatted email can be personalized? Kinda like the launch mailto approach.

[@ShanesCows]

Not that I know of but I haven't tried. You could make the body an input so they could type that.

[@learnalittleeveryday7848]

@@ShanesCows thanks. yes thought about that and at the moment decided to send the invite to the person with some of the relevant info inside and they can edit, forward it.

[@arekbombka9750]

Hi, awesome stuff. It would be great to include someday how to filter/sort just by date content of a table, for example in form of ascending and equals to the picked date. So far couldnt work it out, maybe you take into considaration. Thank for sharing the clips.

[@ShanesCows]

Great suggestion!

[@SeemotionNl]

Super cool stuff. This helps a lot. One question though. I need to schedule a bunch of invites to the same people. How can I use excel to do this. Eg. in one worksheet I have all the meetings (one per row) and in another worksheet I have a full list of email addresses to invite. Struggling to connect to an excelfile on onedrive...

[@ShanesCows]

Remember your Excel data has to be in a flat table. No formulas

[@SeemotionNl]

@@ShanesCows Tnx for the quick reply. I checked and I did this. Just struggling now to get the start/end date of the invite correct. I am using "formatDateTime(String(triggerBody()?['Start']),'YYYY-MM-DDThh:mm:ss')" where the Start column in excel is 01/01/2020 09:00:00 Almost there.... Update: Got it formatDateTime(items('Op_elk(e)_toepassen')?['Start'],'yyyy-MM-ddThh:mm:ss') is the right code ;-) Next steps to send to multiple emails....tbc

[@guddu678910]

Hi Shane, This is excellent. Can we also extract conference ID along with TEAMS meeting invite in anyways ? Appreciate any thoughts

[@ResponsibleXI]

Hey Shane. Thanks a lot for this video. I did try for my app it worked like a charm. But I have a problem. I have a gallery connected to SharePoint list with all the training events. I have a button "Register" in the gallery and on select of the button am scheduling a Teams meeting with the user who clicked on the button "Register". The problem I have is for every other user on button click, Teams Meeting is Scheduled as a separate meeting. Which means for 5 different users, there are 5 different meetings scheduled. I do not want that. I want one single meeting where those 5 users should be attendees of the meeting. How should I be able to do this?

[@ShanesCows]

You need to use Concat to combine all of the users into one To line.

[@mardithpascua8112]

Hi Shane, thank you for this video. This is awesome! Would like to ask if is it possible/applicable to have a join url if I just use the Office365Outlook.V4CalendarPostItem only? I am plannig to post an item to the calendar as invite then send an email notif as well to inform the attendees that an invite was already posted in their calendar.

[@mardithpascua8112]

@Shane, also I notice that there is a Preview Icon for Microsoft Teams, what's it for?

[@ShanesCows]

Not sure you can get the URL but haven’t tried.

[@latrobe15]

FYI I found the number of occurrences always had to be 1. The flow uses the recurrence pattern for the days. So if your your pattern is weekly and the number is 1 it puts an event every seven days in your Colander between the start recurrence and the end recurrence dates. If I use daily it does an event every day. Number of recurrences seem to be an incorrect or confusing statement as I thing

[@darylbingham8332]

What is the best, most current method for checking the calendars of other meeting participants?

[@ShanesCows]

I am not sure, I haven't had to check another person's calendar.... maybe ever, with Power Apps. Sorry. I know other calendars tend to be a pain and I think you end up having to use the Graph API but not sure.

[@prasadsabnis19]

hii Shane, have one question on this, how in dropdown all the your company people list came? what we need to add their?

[@RanmaSaotome666]

Yesssss yessss yesssssss!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! :D

[@ShanesCows]

😎

[@mardithpascua8112]

Hi Shane, can a user select a schedule from a series of schedule (stored in SharePoint list) then once they've selected - they will download a invite file? Or is there a way that they can be included in a meeting invite without requiring the organizer to send it to them?

[@JoseLuisGarciaA]

Muchas gracias... he intentado hacer esto en una app, con un calendario compartido, ero cuando los demás compañeros agregan una cita aparezco yo como el organizador en lugar de ellos. hay una manera de arreglarlo?

[@jamesmoisesllalleperez3079]

good video, could you pass me the first video where you do all those forms? please

[@ShanesCows]

I think you found that video based on your other comment.

[@npyatt5531]

This is super-cool and I definitely had a use case, but with meeting times gobbled up so quickly, it's difficult to use this without verifying conflicts in Outlook or Teams. At that point, why not just create the meeting there. It's asking for the moon for sure, but is there any way to validate recipients' availability prior to sending? I can't even comprehend how to do this, and even if possible the time investment in development may be too much to make viable.

[@satyanarayanach3038]

Hello Shane Thanks for the great session. According to my requirement I need to give only particular user email address which is static under required attendies, so I did the same but unfortunately it is not working. Is there any other way to achieve it, if so could you please suggest me?

[@andrewng7110]

Is there a way to set the sensitivity of the meeting? You can click on private once the meeting is created but I do not see that as something you can set with the CreateTeamsMeeting action. You can set the sensitivity with a normal outlook meeting create

[@michelkroon9448]

for all the people that need all time zones in a table but are to lazy to type them one by one here i made it already (a little late lol) `Table( ["Dateline Standard Time"], ["Samoa Standard Time"], ["Hawaiian Standard Time"], ["Alaskan Standard Time"], ["Pacific Standard Time"], ["Mountain Standard Time"], ["Mexico Standard Time 2"], ["U.S. Mountain Standard Time"], ["Central Standard Time"], ["Canada Central Standard Time"], ["Mexico Standard Time"], ["Central America Standard Time"], ["Eastern Standard Time"], ["U.S. Eastern Standard Time"], ["S.A. Pacific Standard Time"], ["Atlantic Standard Time"], ["S.A. Western Standard Time"] )`

[@ShanesCows]

Thanks for sharing. 😎

[@michelkroon9448]

@@ShanesCows Your welcome :)

[@TurinBard]

I've tried several ways of adding more than 1 optional attendee, but I haven't been able to. Do you know if it is possible?

[@ShanesCows]

I haven’t tried but I think a ; between each should work.

[@TurinBard]

@@ShanesCows I tried that, both with one variable with all the emails and several variables with one email each and a ; between them, but the meetings is only recieved by the first email.

[@vijay3438]

Hi Shane Young, Can we Edit / Delete Team meeting with Power app connector ?

[@powermykola]

hi, can i create meetings in team channels?

[@ShanesCows]

NOt that I know of.

[@ashokpershad]

Way to go.... yeh.......

[@ShanesCows]

Thanks 😊

[@ashokpershad]

@@ShanesCows Textbox input "Default and "Reset" control not there in PowerApps for Teams. Is this bug?

[@viditgang7493]

How do we take care of the timezone difference? I want to schedule a meeting from India with some folks at the US.

[@viditgang7493]

And i can't hardcore the timezone field as this app would be used by multiple people across the globe.

[@dikshasawant9493]

How can you add an attachment as well in the same mail where you are sending the teams link?

[@ShanesCows]

Sure. This video on sending emails will help. kzbin.info/www/bejne/rKG8nIKZmNyhars

[@vishvajitgirase7572]

Can we share existing meeting invitation with attendees?

[@ShanesCows]

I am not sure, I haven't tried to edit an existing meeting.

[@vishvajitgirase7572]

I am trying it but looks like it's not possible it may be another limitation of meeting connector thank you for your help

[@vishvajitgirase7572]

We can share this link with attendees but it won't block their calendar time

[@barnaliroy8703]

Can I somehow edit/reschedule the meeting through PowerApps using this connector?

[@ShanesCows]

I don’t know. Sorry hasn’t been something I have done.

[@MichaelFermin-il9tb]

I was working on this very thing today. However, I want to send to a different Team. how do you find that calendar ID?

[@fabianorocha503]

Thanks for the content, Shane! I have a problem, you can help me? I'm in Brasil and In my case, i created a PowerApps with this resource of create a TEAMS meeting, who works fine for me, but the PowerApps is share with other users, who when click in the button have te message "MicrosoftTeams.CreateTeamsMeeting with error: {"error":{ "code": "ErrorInvalidIdMalformed", "message": "Id is malformed."}} ". It seems like is calendar of the user isn't recognized or finded, maybe by the "name" obtained in the part "Office365Outlok.CalendarGetTables().value". Some tip or suggestion? Exists anything way of obtains the name of calendar of user, like customized?

[@jwnin94]

LookUp( Office365Outlook.CalendarGetTables().value; DisplayName = "Calendário" ).Name try this

[@toastymmo]

Any quick change to make this a Teams Webinar?

[@ShanesCows]

Not that I know of but I haven't tried. You might have to use the Graph API. Not sure.

[@tudzH]

How do I patch the invitation now that it's created? if I use Office365Outlook.V4CalendarPatchItem I'll lose the meeting link and formatting . The only way I can think of right now is to store the url and add it to the V4CalendarPatchItem body, but I'll lose the initial formatting

[@ShanesCows]

I have never tried to edit one so not sure. Sorry

[@pranjalgupta5645]

JoinUrl is blank for me and there is no meeting URL generated in outlook calendar

[@ShanesCows]

Look at your code again. Guessing you have a typo.

[@pranjalgupta9148]

@@ShanesCows , Typo isn't there but I do not have access to create Teams in the environment. May be the connector will create URL if we have that much access. As the connect helps in creating Teams channel as well. This is what I think. My friend is able to get link in Calendar and she is having access to create Teams.

[@asimrehan73]

Hi Shane, I will appreciate your help, if you can please. I made a similar app and it works perfectly but for some of the users when they sent a meeting request; the month & day are swapped for the meeting request. e.g. the selected date of meeting is 07th Dec, but the meeting is generated for 12th July.

[@gabeword]

Hello Shane, can you assist me with location? my Datasource is [ {displayName:"1 Conference Room",value:1}, {displayName:"2 Conference Room",Value:2}, {displayName:"3 Conference Room",value:3} ] but the location is blank.

[@christianigbaras138]

how to update teams meeting on powerapps?

[@ShanesCows]

A teams meeting is really just an OUtlook meeting with a Teams URL in it. So use the Outlook Connector and Update Event action and you should be in business.

[@christianigbaras138]

@@ShanesCows Thanks Shane, I would try that!

[@MizanurRahman-dd5mq]

Is there a way to Make audio call from team to team? I know you can dial to a number? Launch(tel://12*)

[@ShanesCows]

I am not sure. I need to look into it because would be cool 😎

[@mlohr1]

"came to this video learning how to build recurring meetings"... After 12 minutes: Shane says I guess you guys are not going to do that... [facepalm]

[@ShanesCows]

Hey Michel - So I haven't done it before. Looks like it is possible. I THINK I covered the recurrence settings in the Outlook version of this. kzbin.info/www/bejne/g5a0dXx4p6-diMk You might be able to get an idea from there. Sorry this one didn't have recurrence for you.

[@mlohr1]

@@ShanesCows no worries, for my solution I probably need a (shared) SharePoint calender. To get the ms meetings url I am thinking of creating a temporary teams meeting, take the body and delete it. Or do you have a better suggestion?

[@MaheshwariLakshmanan]

Llk

[@ShanesCows]

😀

[@khargos7602]

Something's starting to click...I need to actually read the documentation..