cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Copy new events in Office 365 to Google Calendar and send a notification

I'm trying to use the aforementioned Flow but keep getting this error:

 

Unable to process template language expressions for action 'Condition' at line '1' and column '24408': 'The template language function 'contains' expects its first argument 'collection' to be a dictionary (object), an array or a string. The provided value is of type 'Null'.'.

 

Can anyone help? Any suggestions will be greatly appreciated!

7 REPLIES 7
Highlighted
Community Support
Community Support

Re: Copy new events in Office 365 to Google Calendar and send a notification

 

Hi @xaphc ,

 

Could you share a screenshot of the Flow configuration and Flow run history?

We need to know the specific configuration in the Condition, it seems that the value of the parameter on the left is empty, but the value of the parameter expected by contains cannot be empty, so it failed.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Copy new events in Office 365 to Google Calendar and send a notification

Screen Shot 2019-10-19 at 10.54.08.pngScreen Shot 2019-10-19 at 10.57.28.png

Highlighted
Community Support
Community Support

Re: Copy new events in Office 365 to Google Calendar and send a notification

 

Hi @xaphc ,

 

Would you please provide the screen shoot of Flow configuration?

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Copy new events in Office 365 to Google Calendar and send a notification

Where can I find the Flow configuration?

Highlighted
Dual Super User III
Dual Super User III

Re: Copy new events in Office 365 to Google Calendar and send a notification

Hey @xaphc 

 

I can see that there is an error on the condition step in your flow. As the error states that you are using the contains function if the particular value you selected contains a particular item or not and this is failing as the attribute that you are trying to a[ply the contains function has returned a null value. 

 

If you can share a screenshot of the flow in edit mode and some details on the scenario you are trying to build, we might be able to assist you better with this. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
New Member

Re: Copy new events in Office 365 to Google Calendar and send a notification

Here are the screenshots:

 

Screen Shot 2019-10-21 at 12.50.21.pngScreen Shot 2019-10-21 at 12.50.30.png

 

And this is the code I get when I copy the Condition to my clipboard:

 

{"id":"8f1eca51-5d44-4b12-8770-a720-e1849342","brandColor":"#464F59","connectionReferences":{"shared_office365":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_office365/connections/shared-office365-688ec2f4-58dc-4c59-99ec-1a71f91fb45e"}},"shared_flowpush":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_flowpush/connections/shared-flowpush-41453a5c-3dbf-448e-a2f1-83f4dff4e903"}},"shared_googlecalendar":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_googlecalendar/connections/shared-googlecalenda-c73a00a4-7f78-4818-bd13-f665c8c837c1"}},"shared_conversionservice":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_conversionservice/connections/shared-conversionser-f1007f64-8241-4d21-a2cc-b28d37449db2"}}},"connectorDisplayName":"Control","icon":"data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iMzIiIGhlaWdodD0iMzIiIHZlcnNpb249IjEuMSIgdmlld0JveD0iLTQgLTQgNjAgNjAiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+DQogPHBhdGggZD0ibS00LTRoNjB2NjBoLTYweiIgZmlsbD0iIzQ2NEY1OSIvPg0KIDxwYXRoIGQ9Ik00MSAxOC41di03LjVoLTMwdjcuNWg1LjY0djEzLjgzbC0zLjI4NS0zLjI4NS0xLjA2NSAxLjA2NSA0LjAzNSA0LjA1Ljg3Ljg0aC02LjE5NXY2aDEzLjV2LTZoLTYuOWwuODU1LS44NTUgNC4wMzUtNC4wNS0xLjA2NS0xLjA2NS0zLjI4NSAzLjI4NXYtMTMuODE1aDE1djEzLjgzbC0zLjI4NS0zLjI4NS0xLjA2NSAxLjA2NSA0LjAzNSA0LjA1Ljg3Ljg0aC02LjE5NXY2aDEzLjV2LTZoLTYuOWwuODU1LS44NTUgNC4wMzUtNC4wNS0xLjA2NS0xLjA2NS0zLjI4NSAzLjI4NXYtMTMuODE1em0tMjguNS02aDI3djQuNWgtMjd6IiBmaWxsPSIjZmZmIi8+DQo8L3N2Zz4NCg==","isTrigger":false,"operationName":"Condition","operationDefinition":{"type":"If","expression":{"not":{"contains":["@triggerOutputs()?['body/Body']","on your Google Calendar"]}},"actions":{"Html_to_text":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_conversionservice","operationId":"HtmlToText","apiId":"/providers/Microsoft.PowerApps/apis/shared_conversionservice"},"parameters":{"Content":"@triggerOutputs()['body/Body']"},"authentication":"@parameters('$authentication')"},"runAfter":{}},"Create_an_event":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_googlecalendar","operationId":"CreateEvent","apiId":"/providers/Microsoft.PowerApps/apis/shared_googlecalendar"},"parameters":{"calendarId":"ebpqg4qvqs1e74rr5bbeoh5o7o@group.calendar.google.com","newEvent/start":"@triggerOutputs()?['body/Start']","newEvent/end":"@triggerOutputs()?['body/End']","newEvent/summary":"@triggerOutputs()?['body/Subject']","newEvent/description":"@{if(triggerOutputs()?['body/IsHtml'],body('Html_to_text'),triggerOutputs()?['body/Body'])}\n----\n@{if(empty(triggerOutputs()?['body/RequiredAttendees']),'',concat('Required attendees: ',replace(triggerOutputs()?['body/RequiredAttendees'],';',', ')))} @{if(empty(triggerOutputs()?['body/OptionalAttendees']),'',concat('Optional attendees: ',replace(triggerOutputs()?['body/OptionalAttendees'],';',', ')))}\nCopied from your Office 365 calendar (@{triggerOutputs()?['body/Id']})","newEvent/location":"@triggerOutputs()?['body/Location']","newEvent/status":"confirmed"},"authentication":"@parameters('$authentication')"},"runAfter":{"Html_to_text":["Succeeded"]}},"Send_a_push_notification":{"type":"OpenApiConnection","inputs":{"host":{"connectionName":"shared_flowpush","operationId":"SendNotification","apiId":"/providers/Microsoft.PowerApps/apis/shared_flowpush"},"parameters":{"NotificationDefinition/notificationText":"\"@{triggerOutputs()?['body/Subject']}\" was copied to your Google Calendar from Office 365 Calendar.","NotificationDefinition/notificationLink/uri":"https://www.google.com/calendar","NotificationDefinition/notificationLink/label":"Go to your Google Calendar"},"authentication":"@parameters('$authentication')"},"runAfter":{"Create_an_event":["Succeeded"]}}},"runAfter":{}}}

Highlighted
Dual Super User III
Dual Super User III

Re: Copy new events in Office 365 to Google Calendar and send a notification

Hey @xaphc 

 

I am still trying to understand why you have body/** for each of the dynamic selector? I tried replicating the issue but am unable to. As you can see the blow screenshot, I just have the body while selecting from the dynamic selector:ee4.PNG

 

Can you check and confirm this? 

 

Also, was this flow saved and created as a copy? If so, can you try creating another one and see if you see the same issue?

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
secondImage

August 2020 CYST Winners!

Check out the winners of the recent 'Can You Solve These?' community challenge!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Users online (3,975)