How to Send Out-of-Office Alerts to Slack with Power Automate

My flows > + New flow > Automated cloud flow

Create automated flow in Power Automate

Go to make.powerautomate.com and sign in with your Microsoft account. Click 'My flows' in the left sidebar, then '+ New flow' at the top. Select 'Automated cloud flow' from the dropdown menu. Name your flow 'OOO Calendar Alerts' and leave the trigger selection for the next step.

1. 1Click 'My flows' in the left navigation
2. 2Click '+ New flow' button
3. 3Select 'Automated cloud flow'
4. 4Enter 'OOO Calendar Alerts' as the flow name
5. 5Click 'Skip' on trigger selection

Flow designer > Search connectors > Google Calendar

Add Google Calendar trigger

Search for 'Google Calendar' in the connector search box and select it. Choose 'When an event is added, updated or deleted' as your trigger. This polls your calendar every 3 minutes for changes. You'll need to sign in to your Google account and grant calendar access permissions.

1. 1Type 'Google Calendar' in the search box
2. 2Click on the Google Calendar connector
3. 3Select 'When an event is added, updated or deleted'
4. 4Click 'Sign in' and authenticate your Google account
5. 5Grant calendar read permissions

Google Calendar trigger > Parameters

Configure calendar monitoring

Set the Calendar Id to your primary calendar or the specific calendar where OOO events are created. Leave the time range fields blank to monitor all events. Set the polling frequency - the default 3 minutes works well for most teams without hitting API limits.

1. 1Click the Calendar Id dropdown
2. 2Select your primary calendar or team calendar
3. 3Leave 'Time range start' and 'Time range end' empty
4. 4Keep default polling interval at 180 seconds

Flow designer > + New step > Control > Condition

Add condition to filter OOO events

Click '+ New step' and search for 'Condition' under Control actions. You need to filter for all-day events that contain OOO keywords in the title. The condition will check if the event summary contains 'OOO' or 'Vacation' and if it's an all-day event.

1. 1Click '+ New step' below the Google Calendar trigger
2. 2Search for 'Condition' and select it
3. 3Click in the left condition box
4. 4Select 'Summary' from dynamic content
5. 5Set the operator to 'contains'

Condition > Add condition > Advanced mode

Set OOO keyword conditions

In the condition value field, type 'OOO' to match that exact text. Click 'Add' to create additional conditions and add 'OR' logic for other variations like 'Vacation', 'PTO', 'Out of office'. Each condition should check if the Summary contains these keywords.

1. 1Type 'OOO' in the condition value field
2. 2Click 'Add' next to the condition
3. 3Select 'Add row' and choose 'Or'
4. 4Add conditions for 'Vacation', 'PTO', 'Out of office'
5. 5Click 'Edit in advanced mode' for complex OR logic

Condition > Add condition > And

Filter for all-day events only

Add another condition within the existing condition group to ensure you only catch all-day events. Check if 'Start time' equals 'End time' for all-day events, or look for events where 'All day' is true. This prevents partial-day appointments from triggering notifications.

1. 1Click 'Add' in the condition block
2. 2Select 'Add row' and choose 'And'
3. 3Choose 'All day' from dynamic content
4. 4Set operator to 'is equal to'
5. 5Type 'true' in the value field

Condition > If yes > Add an action > Slack > Post message

Add Slack action for notifications

In the 'If yes' branch of your condition, click 'Add an action' and search for 'Slack'. Select 'Post message' action and authenticate with your Slack workspace. You'll need permissions to post to the target channel where OOO notifications should appear.

1. 1Click 'Add an action' under 'If yes'
2. 2Search for 'Slack' and select the connector
3. 3Choose 'Post message' action
4. 4Click 'Sign in' for Slack authentication
5. 5Authorize Power Automate to access your workspace

Slack Post message > Parameters

Configure Slack message details

Set the Channel to '#team-updates' or your preferred notification channel. Create a message template using dynamic content from the calendar event. Include the person's name, dates, and event title to provide complete OOO context.

1. 1Type '#team-updates' in the Channel field
2. 2Click in the Message field
3. 3Add dynamic content: Organizer, Summary, Start time, End time
4. 4Format the message with clear OOO information
5. 5Set Bot name to 'OOO Bot' for easy identification

Add an action > Data Operation > Compose

Add duplicate prevention

Power Automate's polling can trigger multiple times for the same event if it gets updated. Add a 'Compose' action to create a unique identifier using the event ID and modification timestamp. Store this in a SharePoint list or use 'Do until' loop to prevent duplicate notifications.

1. 1Click 'Add an action' before the Slack step
2. 2Search for 'Compose' under Data Operation
3. 3Combine Event Id and Updated dynamic content
4. 4Add condition to check if this combination was seen before
5. 5Use SharePoint list to store processed event IDs

Flow designer > Save > Test

Test and enable the flow

Click 'Save' to store your flow configuration. Create a test all-day event in Google Calendar with 'OOO' in the title to verify the workflow. Check that the Slack message appears in your target channel within 3-5 minutes. Enable the flow if testing succeeds.

1. 1Click 'Save' in the top right
2. 2Select 'Test' next to the Save button
3. 3Choose 'I'll perform the trigger action'
4. 4Create test OOO event in Google Calendar
5. 5Wait 3-5 minutes and check Slack channel

Use Power Automate expressions to format dates and handle edge cases like single-day vs multi-day time off. Paste this in the Message field of your Slack action to create smart formatting.

concat('🏖️ ', 
  split(triggerOutputs()?['body/organizer'], '@')[0], 
  ' will be out of office ',

concat('🏖️ ', 
  split(triggerOutputs()?['body/organizer'], '@')[0], 
  ' will be out of office ',
  if(equals(formatDateTime(triggerOutputs()?['body/start'], 'yyyy-MM-dd'), 
           formatDateTime(triggerOutputs()?['body/end'], 'yyyy-MM-dd')),
     concat('on ', formatDateTime(triggerOutputs()?['body/start'], 'MMM dd')),
     concat('from ', formatDateTime(triggerOutputs()?['body/start'], 'MMM dd'), 
            ' - ', formatDateTime(triggerOutputs()?['body/end'], 'MMM dd'))
  ),
  ' (', triggerOutputs()?['body/summary'], ')'
)