I am hoping to simplify a current process where we have a SharePoint calendar to schedule on-call time. The support desk is beginning to use a Team site, and I would like to make a flow that does the following:
1. Each morning at a set time, the calendar is checked for the event of the day.
2. A new message is posted to a Team channel, with some information from the calendar event, like the name, and some additional text.
Is this possible?
Do you want to post a new message to Team channel with some information from all calendar events of the day?
I have made a test on my side and please take a try with the following workaround:
@equals(formatDateTime(item()?['Created'], 'MM/dd/yyyy'), formatDateTime(utcNow(), 'MM/dd/yyyy'))
The flow works successfully as below:
This looks great, I am running into one issue though. When trying to create the mapping on the Select, I am not getting option choices for the details of events, which makes me think I am missing something....any thoughts?
As a different work around, I was thinking of pulling in the RSS feed for the calendar and get that working, seems to work that way as well.
When you add a "Select" action, From field should be set to output of "Get items" action. Then you should click "Enter key" box and type a value. When you click the "Enter value" box, the dynamic content would be shown up automatically.
Besides, please take a try to remove "Select" action and add it again to check if the issue still exists. Also please check if the connection to "Get items" action is valid, if it is invalid, update the connection.
Thanks, I did try those, was hoping I was forgetting something silly. I have a feeling it is something with the sharepoint and calendar urls.
I'm having an issue with your flow. When I run it, it outputs in the HTML table every event that's on the calendar, not just what's happening today. How do I limit it to get items from todays date only?
Look out for new contribution recognition badges coming SOON!
Join us for the first ever Power Platform Online Conference!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!