How To Schedule A Recurring Message In Microsoft Teams Using Power Automate

[@LuiIacobellis]

🆓GUIDE TO THE BEST FREE MICROSOFT TEAMS APPS: bit.ly/4goXEoF

[@fallacy3733]

We all know why we're here... :) Need to automate check-in responses for our micromanagers.

[@michaelboyles8988]

Hi. Thanks for this helpful video. Just want to ask if you have tutorial on how to send recurring messgae that are tagged as "Important" or "Urgent" and will mention "everyone" in a Group chat?

[@MrH20baby]

Well done presentation - Concise and to the point.

[@LuiIacobellis]

Thank you for the kind words and for watching

[@ambere2106]

This is so helpful! Thank you for creating this tutorial.

[@LuiIacobellis]

@ambere2106 You're very welcome! Thanks for watching!

[@sltwtr806]

You got me to where I needed to be. Thank you

[@LuiIacobellis]

You're very welcome and thanks for watching

[@naveensurya1041]

Works like a charm, thank you Lui Iacobellis

[@LuiIacobellis]

@naveensurya1041 You're very welcome! Thanks for watching!

[@linosemira810]

Hello! Is it possible to send a notification individually via MS teams? The scenario is I want to notify each employees who has expiring and missing documents. I have a record in a spreadsheet about their names, email address, document type and date of expiration..

[@LuiIacobellis]

Hi there, this is possible. I do not have a tutorial that demonstrates how to do it but you can combine the steps from this tutorial and this one: kzbin.info/www/bejne/Y5awgqh5fbhpY9E to devise a solution. You could replace your spreadsheet with a SharePoint list! Hope this helps!

[@VinaySingh-ox7bl]

With scheduled flow, we only need to save them, dont need to run them, right ? They automatically run on there trigger time ?

[@patrickkea3088]

I like you my guy. I appreciate you. This was solid. Thank you. Keep up the good work.

[@LuiIacobellis]

Glad I could help and thanks for watching

[@mssatyarthi4208]

Very helpfull

[@pierrickdefossez3157]

Many thanks Lui, at the end you talk about adaptive cards only in channels, does that mean you cannot leverage adaptive cards within group chats?

[@LuiIacobellis]

Hi there, you can totally use Adaptive Cards in Group chats. There is even an option to post Adaptive Cards to group chats in the workflow action. Hope this helps!

[@chewnss]

Really helpful and well-explained! Is there a way to mark thr message as Important or Urgent? Thanks!

[@LuiIacobellis]

I'm glad you found this helpful! Unfortunately, the post a message workflow action doesn't allow you to mark the message as urgent. Hope this helps!

[@aniketsalvi651]

Hi thanks for this video . I want to schedule a recurring flow where a message should post on teams channel on 20th of every month but their is one condition let’s say if 20th is either Saturday or Sunday then it should post message on Friday . Can we do this using power automate ?

[@matthewhughes3443]

Did you ever get an answer to this? I’m trying to do the same thing

[@ChandraShekhar]

Thanks for making video on this topic that I am curious on. Somehow may be MS-Teams version mismatch or some other I do not see Schedule Cloud Flow on Power Automate app. I may have to wait for next update

[@LuiIacobellis]

Unfortunately I've never experienced this issue. I'd suggest posting it over in the Microsoft Tech Community with some screenshots as someone else may have and may have a solution. Hope this helps and thanks for watching

[@melyscetti799]

Hi! Great video!Just what I needed! QQ Is it possible to build a flow which sends individual messages from any app such as Excel, Power BI??

[@LuiIacobellis]

I'm glad this video was useful. You would need to review the power automate documentation for each app to see what actions are supported.

[@kamunidrushya6784]

Hi, I m using slack to get notified if my jenkins CI success or fails. After sending the notification in slack channel it starts a thread (reply for that notification) which shows the latest updates in the pipeline. I have migrated this notification to MS teams channel. Now i want to achieve to start a thread and post the changes to that specific notification as a reply. Is it possible to achieve for MS teams as it is not fixed message. It gets updated for every build.

[@harlansantos7484]

Thanks! This content helped me a lot.

[@LuiIacobellis]

I'm glad this helped! Thank you for watching

[@funzonekerala]

Hello can you create for monthly first business day, mon to Friday is working days. If 1st of month falls on Saturday and Sunday the message should be triggered on the next working day

[@mauriciomartins1413]

Hi.. i created a flow when receive an email save attachments in sharepoint and send a notification in group chat teams, but my flow is sending 5 notifications in group chat, what can be? please

[@jackemanalo7741]

Thanks for another informative video, easy to follow

[@LuiIacobellis]

Thank you for the kind words MJ! I'm glad you found it informative

[@purvajagtap]

Hi Lui Great share By any means is it possible to schedule messages based on dynamic time and message For example, it will pick both time and date from excel sheet and then send message

[@LuiIacobellis]

Yes this is totally possible. It might be easier to use a Sharepoint List instead of an excel file. You would also need to build the flow as a scheduled cloud flow that executes daily and then checka a date time field in your list.

[@chubibx4619]

Hi Lui. I've created a scheduled flow that should post twice per month different texts on Teams channel. I created list on sharepoint and have dates there so flow will understand when it needs to be triggered. However, it works only for one text while I need one flow to be posted on Teams channel on different dates and different text. Could you please let me know how to do that?

[@LuiIacobellis]

Hi there unfortunately I can't provide troubleshooting support for individuals. I would however recommend you post your question with screenshots over on the Microsoft Tech Community at this link techcommunity.microsoft.com/

[@alberttimothy]

Hello Lui, have you ever try to show the information from the link/files, in body message ?

[@LuiIacobellis]

Hi Albert, Yes I have. I actually have a tutorial that demonstrates how to insert a clickable link in Power Automate and specifically a MS Teams message that will be posted using Power Automate. You can view it here: kzbin.info/www/bejne/f5rGeaeFg66Cp9k - Hope this helps!

[@alberttimothy]

@@LuiIacobellis Thankyou Lui for your information, however i would to know if i put dynamic value in body mesage from the link/files that i attached in body message, is that possible too?

[@LuiIacobellis]

@alberttimothy ​ I think this is technically possible however I've never done this. It would likely require that you fetch the content and then store it in a variable and insert the variable into the message. Hope this helps

[@g_ross_]

thanks mate. Much appreciated 😊

[@LuiIacobellis]

You are very welcome Grant! Thank you for watching!

[@hdp6612]

There is still no way to change the appearance of Flow bot right? Like a custom icon and a custom name instead of x via power automate

[@LuiIacobellis]

To the best of my knowledge, no it is not possible to change the appearance of the flow bot.

[@JoãoBotaro-b9g]

Hi Lui, well done presentation. Do you know if it's possible to send the messages as other name instead of mine?

[@LuiIacobellis]

Thank you! I do not believe you can send a message as another user. You can send emails on behalf of another user but not Teams messages. Hope this helps!

[@hollywixon8980]

This was SO helpful! If I wanted it to run on the first and third Monday of the month, is that possible? I'm not seeing a ton of advanced option within recurrence.

[@LuiIacobellis]

I'm glad you found this video helpful! You can totally schedule the flow to execute on a specific day however I'm not sure if would be easy to build the recurrence to trigger on the first and third Monday of the month. You could easily do either or but may need to implement some additional actions using control blocks to help you do that. I do outline how to amend the trigger at about the 11:30 mark. Hope this helps and thanks for watching

[@Dan0RP]

how can i send different random messages based on a schedule to teams?, for example send 1 random tip message once a day

[@LuiIacobellis]

You would need to incorporate a source list with your message content such as a SharePoint list and built in a loop that randomly picks the message content

[@cristianodadda2679]

you can send a message to a private chat and not to a group ?

[@LuiIacobellis]

At the time of recording this video, you can post a message to the channel of a Team, a group chat or a single chat. Those are the actions supported by the "Post message in chat or channel" workflow action. You can read more about it here: learn.microsoft.com/en-us/connectors/teams/#post-message-in-a-chat-or-channel

[@chloeeg]

Hi Lui, how to include table in the Team message sent coming from excel file in Sharepoint?

[@LuiIacobellis]

Hi there, this is a pretty complex use-case. I'd suggest posting the question over on the Microsoft Tech community as that forum is more conducive to answering these questions. Thanks!

[@pierrickdefossez3157]

Can you @mention someone or all members of the group chat in the message?

[@LuiIacobellis]

Unfortunately, to the best of my knowledge you cannot use the @mention functionality in Power Automate workflows as of yet. Thanks!

[@moveworkforward]

Nice, thanks.

[@LuiIacobellis]

No problem!

[@lokesh411]

in the message How to use the @ everyone functionality?

[@LuiIacobellis]

Unfortunately, it is not possible to use the at everyone tag in Power Automate workflows at this time. Hope this helps and thanks for watching!

[@carlafoote7963]

@@LuiIacobellis Is this still the case?

[@ijonm7875]

How can I send an hourly message with a new screenshot everytime?

[@LuiIacobellis]

You might want to use a SharePoint list and a scheduled flow for this.

[@nvidiagt7105]

How to add hyperlink ? It’s still not showing. Please help brother

[@LuiIacobellis]

I actually have a tutorial coming out in the next 1-2 weeks thay will demonstrate how to add clickable links in workflow actions!

[@nvidiagt7105]

@@LuiIacobellis Thank you so much

[@LuiIacobellis]

@@nvidiagt7105 anytime!