Issue updating an D365 Appointment Record After it is Created

[CoffeeQuaffer]

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.

Flow Snip

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

Perry

[v-litu-msft]

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]

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

[v-litu-msft]

Hi @CoffeeQuaffer,

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

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]

@v-litu-msft,

Here's the info you requested.

Thanks,

Perry

Top 1/3 of formMiddle 1/3Bottom 1/3

[v-litu-msft · Accepted solution]

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:

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]

@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