Unanswered

Check a SharePoint Calendar once a Day and post a message with content from the all day event

(0) Share

Report

Posted on by Community Power Pla...

Hi,

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?

Thanks!

Brian

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

v-xida-msft on at

Like (1)

Report
Hi @Sasscanoodle,

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:

Add Recurrence trigger, Interval set to 1, Frequency set to Day and At these hours set to 9.

Add “Get items” action, specify Site Address and List Name (type your SharePoint calendar list as a custom value).

Add “Select” action, From set to output of “Get items” action. Within Map entry, type the content as below:

Add “Filter array” action, From set to output of “Select” action, click “Edit in advanced mode”, type the following formula:

@equals(formatDateTime(item()?['Created'], 'MM/dd/yyyy'), formatDateTime(utcNow(), 'MM/dd/yyyy'))

Add “Create HTML table” action, From set to output of “Filter array” action.

Add “Post message” action, Message set to output of “Create HTML table” action.

Image reference:

The flow works successfully as below:

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,
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.
Thanks,
Brian

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

Hi @Anonymous,

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.

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
black797 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No