Auto-syncing Power Pages submissions with calendar invites can streamline event registration, appointment booking, or scheduling experiences for users. This setup typically integrates Power Pages, Power Automate, and a calendar service like Microsoft Outlook (via Microsoft Graph API) or Google Calendar.
Step-by-Step Guide
Use Case Example
Let’s assume:
You have a booking or event form on Power Pages. When a user submits the form, they automatically receive a calendar invite.
Step 1: Setup the Portal Form
- Create a form (Basic Form or Entity Form) on Power Pages.
- Store event-related details in Dataverse:
- Title
- Description
- Event start and end time
- Location
- Attendee email
Step 2: Create Power Automate Flow
Trigger
- Trigger:
When a row is added
(Dataverse connector) - Triggered when a user submits the form.
Step 3: Create Event with Outlook (via Microsoft 365 Outlook connector)
Action: Create Event (V2)
- Calendar: Choose a shared or specific calendar.
- Subject: Dynamic from form (e.g., Event Name).
- Start time & End time: From form inputs.
- Location: Static or from form input.
- Attendees: Use the user’s email.
- Body: Add details (e.g., “You are scheduled for…”).
Optional:
- Enable
Is Reminder On?
: Yes - Set
Reminder Minutes Before Start
: e.g., 30
Alternative: Use Microsoft Graph API (via HTTP action) for deeper control, recurring events, etc.
Step 4: Send Confirmation Email (Optional)
- Action:
Send an email (V2)
- Subject: “Calendar Invite Confirmation – [Event Name]”
- Body: Thank you message + event details
Step 5: Sync to User’s Calendar
If the attendee is internal (Microsoft 365 user), the invite will sync automatically. For external users:
- Outlook sends an .ics invite which users can accept.
- Google Calendar auto-detects the invite from the email.
Advanced: Google Calendar Integration
- Use the Google Calendar connector in Power Automate.
- Action:
Create an event (V4)
- Fill in title, time, location, description, and attendee emails.
Additional Features
- Recurring Events: Set recurrence rules via Microsoft Graph.
- Canceling Events: Create flow to delete/update calendar events.
- Add to Teams Meeting: Use
Online Meeting = True
inCreate Event
(Outlook) for auto-generating Teams links.
Security & Permissions
- Grant appropriate calendar write permissions.
- Use Application Registration if working with Graph API.
- Ensure your Power Automate connection has
Calendars.ReadWrite
.
Example Use Cases
- Event registrations (e.g., webinars, workshops)
- Interview scheduling
- Customer support appointments
- Resource bookings (e.g., rooms or equipment)