
Hi, I'm trying to create an power automate flow that syncs my private calendar items over to outlook calendar. Creating the events is fine, and based upon an similar flow I decided to include the Google event id as an text string in the Outlook event body for lookup when deleting/modifying, like so:
{
"inputs": {
"host": {
"connectionName": "shared_office365",
"operationId": "V4CalendarPostItem",
"apiId": "/providers/Microsoft.PowerApps/apis/shared_office365"
},
"parameters": {
"table": "AAMkADM4MDhhMWYxLTM1ODAtNDRjZC1iYmQzLTYxNWI4ZGVkNmUwNQBGAAAAAACvyj_2VQ1UQaS5Dk4hQUbvBwBlem0GYHunTb7PIo3qHPgZAAAAAAEGAABlem0GYHunTb7PIo3qHPgZAAAGnW6XAAA=",
"item/subject": "@triggerOutputs()?['body/summary']",
"item/start": "@body('Start_tid')",
"item/end": "@body('Stop_tid')",
"item/timeZone": "(UTC+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna",
"item/requiredAttendees": "@triggerOutputs()?['body/attendees']",
"item/body": "<p>@{triggerOutputs()?['body/description']}<br>\n<br>\n<br>\n------------------------------------<br>\n@{triggerOutputs()?['body/id']}</p>",
"item/location": "@triggerOutputs()?['body/location']",
"item/reminderMinutesBeforeStart": 60,
"item/isReminderOn": true,
"item/showAs": "oof",
"item/sensitivity": "private"
},
"authentication": "@parameters('$authentication')"
}
}
This works fine.
Now to the issue, when an updated/deleted event hits the switch filter and then further down to my Get Events v4 connector it times out based on this code
{
"inputs": {
"host": {
"connectionName": "shared_office365",
"operationId": "V4CalendarGetItems",
"apiId": "/providers/Microsoft.PowerApps/apis/shared_office365"
},
"parameters": {
"table": "AAMkADM4MDhhMWYxLTM1ODAtNDRjZC1iYmQzLTYxNWI4ZGVkNmUwNQBGAAAAAACvyj_2VQ1UQaS5Dk4hQUbvBwBlem0GYHunTb7PIo3qHPgZAAAAAAEGAABlem0GYHunTb7PIo3qHPgZAAAGnW6XAAA=",
"$filter": "contains(body/content, '@{triggerOutputs()?['body/id']}')"
},
"authentication": "@parameters('$authentication')"
}
}
It's could seem like the contains() function is using to much time which makes the whole flow time out eventully.
What am I doing wrong?
Attached an Image of the entire flow, unfortunately in Norwegian for you none Norwegians 😉