Microsoft Dynamics 365 CRM error: The app returned "')' or ',' expected at position 9 in '(Testing Company)`."

Hi @Kennedy Alvarez 

For us to have context about the error, post screenshots with how the Zap step is configured in EDIT mode for the ‘Action’ tab section.

Here you go! Please let me know if you need any additional information here. 

Zap Step - Update Account in Microsoft Dynamics 365

Here are the filled fields:

@Kennedy Alvarez 

Check the field description for the Account field.

You need to map the ID of the Account.

Hi @Kennedy Alvarez,

I wanted to check in here to see how you’re getting on. Were you able to Troy’s suggestion to map the ID of the account?

Please do let us know if you’re still in need of some help on this at all - happy to assist further! 🤗

Good morning - 

I have replaced the Account field with the Account ID but am now receiving the following error. Do you all have any advice on how to troubleshoot this?

Hi @Kennedy Alvarez,

This error might be related to the “Primary Contact” field. Could you please try removing the mapped data on that field and test the Zap afterwards? Does it still run into the same error?

I'll be keeping an eye out for your response!

Good morning, 

Yes, removing the Primary Contact field ID allowed the Zap to run successfully; however, I am needing to attach the Contact created in the previous Zap to the Account created in Zap #2. Is it possible to utilize the Primary Contact field to attach this information to the Account? 

Hi @Kennedy Alvarez,

Thanks for confirming.

Could you please send a screenshot of the choices of the “Primary Contact” field? The “Primary Contact” field might be formatted differently and requires more than just mapping the ID.

I'll be keeping an eye out for your response!

Good morning, 

I have attached screenshots of the Primary Contact field setup. Please let me know if you need any additional information here and I appreciate the ongoing help!

Hi @Kennedy Alvarez,

Thanks for the screenshot. Could you also please send a screenshot of the choices in the “Primary Contact” tab? Like so:

(view larger)

I'll be keeping an eye out for your response!

Good morning - 

It looks like it is pulling previously created and existing Primary Contacts from Dynamics. 

The top portion is the name of the Contact and the bottom parentheses shows the Contact ID. 

Thank you  

Thanks for the screenshot @Kennedy Alvarez!

It looks like the Primary Contact ID is formatted in a certain way like “/contacts(Contact ID)”. Could you please try to format the mapping the same way you see the Primary Contact dropdown choices? Like so:

(view larger)

Then you’d want to map the Contact ID inside the parenthesis.

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Good morning, 

That did resolve the issue of the final Zap in my sequence returning an error code; however the Contact is still not assigned within the original Account which is my goal with these Zaps. Are you familiar with how to attach the Contact to the Account? My final Zap of updating the Account with the created Contact is not working. 

Thank you! 

That’s great news @Kennedy Alvarez! Glad to hear that we’re able to help you out!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗