Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I am having trouble figuring this one out. We use Zapier to sync updates on a Monday board to fields in Dynamics. Our Monday board has columns that are dropdowns to select users assigned to a specific task. Sometimes a user is unassigned and the field on the Monday board is cleared, but Zapier does not recognize this and does not clear the field in Dynamics, it retains the previous value. 

How can I update my Zap to recognize these blank values and clear the field in Dynamics?

Hi ​@Otto Pinion,

 

Welcome to the Community.

Suppose you're having trouble syncing updates from Monday.com to Dynamics CRM via Zapier. Specifically when unassigning a user from a task. It may be due to how empty values are handled. Zapier should update the Dynamics field with a null value, but if it's not working, double-check that the "Update Record" action is correctly configured. You can also use the "Formatter by Zapier" tool to convert empty values into a format Dynamics recognizes. After making adjustments, test your Zap and share more details if the issue persists.

I hope this helps. Let us know how it goes or if you have any other questions.

That is very vague and general. I’m looking for some specific instructions, like those that have been given to Salesforce users to solve the same issue. 

The ‘Update Record’ action does not recognize null or blank values and does not update Dynamics when a column on the Monday board changes to a null or blank value.

I have tried using the Formatter by Zapier tool, but it’s not clear what I’m supposed to do with it. I must be doing something wrong, as it doesn’t seem to pick up blank or null values from Monday and sync them to Dynamics fields. 

Hi ​@Otto Pinion,

 

The 'Update Record' action in Zapier ignores null or blank values to avoid overwriting data in Dynamics. However, you can work around this using a placeholder value like "NULL" or "EMPTY" to represent blank fields. You can set up a 'Formatter by Zapier' step to replace blank values from Monday with your chosen placeholder. This allows the 'Update Record' action in Dynamics to recognize and sync these values.

Terms & Conditions