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

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.

Flow SnipFlow Snip

 

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

 

Perry

1 ACCEPTED SOLUTION

Accepted Solutions

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
Community Support

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.

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

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.

@v-litu-msft,

 

Here's the info you requested.

 

Thanks,

Perry

Top 1/3 of formTop 1/3 of formMiddle 1/3Middle 1/3Bottom 1/3Bottom 1/3

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

@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
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (76,210)