Hi @Sam,
Thanks for providing the error details—it’s a common issue when working with shared calendars in Power Automate. The "Id is malformed" error typically occurs because Power Automate does not recognize the shared calendar email address as a valid Calendar ID. Let me walk you through a workaround and alternative approaches to solve this.
id
field.If the flow continues to face issues, consider exporting calendar events from the shared calendar as a CSV file and using a Power Automate flow to import the data into a SharePoint list.
Let me know if you encounter further challenges. I’m happy to assist with refining the flow configuration or troubleshooting additional errors!
Best regards,
@Ninjasabi
To create a flow that takes calendar items from a shared calendar and inputs them into a Microsoft SharePoint list, you need to ensure that you have the correct permissions and can access the shared calendar through Power Automate. Since you are experiencing issues with the shared calendar not appearing in your calendar IDs, let's go through a step-by-step process to troubleshoot and set up the flow.
Verify Permissions:
Access the Shared Calendar in Power Automate:
Create the Flow:
Trigger:
Get Calendar View of Events:
utcNow()
).utcNow()
).Apply to Each:
value
array from the "Get calendar view of events" action.Create Item in SharePoint List:
Recurrence Trigger:
Get Calendar View of Events:
sharedcalendar@example.com
(replace with the actual email address of the shared calendar).@{addMinutes(utcNow(), -15)}
@{utcNow()}
Apply to Each:
value
from the "Get calendar view of events" action.Create Item in SharePoint List:
https://yoursharepointsite.sharepoint.com
YourListName
@{items('Apply_to_each')?['subject']}
@{items('Apply_to_each')?['start']['dateTime']}
@{items('Apply_to_each')?['end']['dateTime']}
By following these steps, you should be able to create a flow that retrieves events from a shared calendar and inputs them into a SharePoint list. If you continue to encounter issues, please provide additional details, and I can assist further.
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,089
Most Valuable Professional