cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CoffeeQuaffer
Level: Power Up

Issue updating an D365 Appointment Record After it is Created

We're trying to update a single field in new D365 CE appointments when our reps schedule them using Outlook.  Here's what I'm trying to do in a nutshell:

  • When a new appt. is created...
  • IF the location contains a meeting room (prefixed with 'Finite-')
  • Update the appt type field to 'Booked'

The failure reads:  

Invalid Template. Unable to process template language expressions for action 'Condition' at line '1' and column '2680': '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'.'.
 

Here's what I've built, and it passes the Flow Checker, but fails the test every time.

2019-12-16 16_59_49-Edit your flow _ Microsoft Power Automate - Personal - Microsoft Edge.pngFlow Snip

 

Thanks in advance to all who can help a n00b out!

 

Perry

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Issue updating an D365 Appointment Record After it is Created

Hi @CoffeeQuaffer,

 

It looks like have no field of Location, could you please put the dynamic content of Location into a Compose to check whether it has value, for example:

Annotation 2019-12-24 150545.png

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
Community Support Team
Community Support Team

Re: Issue updating an D365 Appointment Record After it is Created

Hi @CoffeeQuaffer,

 

Could you please share the output body of the trigger? (Please shield personal information) 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

CoffeeQuaffer
Level: Power Up

Re: Issue updating an D365 Appointment Record After it is Created

Hi @v-litu-msft,

I'm not sure what you're asking for. Do you mean output from the failed job or something hiding in the design snip? Thanks for your patience!

Perry
Community Support Team
Community Support Team

Re: Issue updating an D365 Appointment Record After it is Created

Hi @CoffeeQuaffer,

 

The output body of the trigger is when you run the Flow, it will have a output from the trigger, for example:

Annotation 2019-12-18 164328.png

If we could get the Location field, it will be better to analyze the root of your issue.

And please pay attention to protect your personal information, thank you.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

CoffeeQuaffer
Level: Power Up

Re: Issue updating an D365 Appointment Record After it is Created

@v-litu-msft,

 

Here's the info you requested.

 

Thanks,

Perry

2019-12-23 15_37_54-Run History _Trigger1.pngTop 1/3 of form2019-12-23 15_37_54-Run History _Trigger2.pngMiddle 1/32019-12-23 15_37_54-Run History _Trigger3.pngBottom 1/3

Community Support Team
Community Support Team

Re: Issue updating an D365 Appointment Record After it is Created

Hi @CoffeeQuaffer,

 

It looks like have no field of Location, could you please put the dynamic content of Location into a Compose to check whether it has value, for example:

Annotation 2019-12-24 150545.png

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

CoffeeQuaffer
Level: Power Up

Re: Issue updating an D365 Appointment Record After it is Created

@v-litu-msft ,

 

You lead me right to the problem, thank you!  The 'Location' field is NULL when it fails.  I tried very quickly to find a way to check for NULL before this condition, and didn't find anything helpful.  I think I'd like to insert a condition before this one and check for NULL.  If the location is NULL, then do nothing.  If the location is not NULL, then do the existing condition.  If the location contains 'Finite-' then perform the action as already configured.

 

Thanks,

Perry

Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (5,871)