Zoho Flow - Unable to evaluate formatDate with Zoho Invoice Date Field for Calendar Integration

Zoho Flow - Unable to evaluate formatDate with Zoho Invoice Date Field for Calendar Integration

Hello Community,

I'm trying to automate the creation of all-day events in Zoho Calendar whenever a new invoice is created in Zoho Invoice. I'm using Zoho Flow for this automation.

My Goal: When an invoice is created with a specific "Event Date," I want to create an all-day event in Zoho Calendar on that date, with the customer name in the title. Ideally, I'd also like to format the "Event Date" as MMdd within the event title.

My Setup in Zoho Flow:

  • Trigger: Zoho Invoice - Invoice Created
  • Action: Zoho Calendar - Create Event
    • Calendar: [Name of your calendar]
    • Event Title (Attempted): ${formatDate(trigger.zoho_invoice.Event_Date, 'MMdd')} ${trigger.zoho_invoice.Customer_Name} - Rental Booking (and variations including Invoice Date)
    • Start Date: Mapped to trigger.zoho_invoice.Event_Date (also tried with ${formatDate(trigger.zoho_invoice.Event_Date, 'yyyy-MM-ddT00:00:00Z')} and ${formatDate(trigger.zoho_invoice.Event_Date, 'yyyy-MM-dd')})
    • End Date: Mapped to trigger.zoho_invoice.Event_Date (also tried with the same formatting as Start Date)
    • All Day Event?: true

The Problem: I consistently receive the following error in Zoho Flow when the flow attempts to execute the "Create Event" action:

Unable to evaluate '${formatDate(trigger.zoho_invoice.Event_Date, 'yyyy-MM-ddTHH:mm:ssZ')}'. Please contact support for more details.

(Note: The exact error message sometimes varies slightly depending on the syntax I've tried, but it always involves the formatDate function and the "Event_Date" field.)

What I've Tried:

  • Various syntaxes for the formatDate function.
  • Different date formats (MMdd, yyyy-MM-dd, yyyy-MM-ddTHH:mm:ssZ).
  • Simplifying the event title to just the customer name (this works, so the basic connection seems okay).
  • Ensuring the "Event Date" field in Zoho Invoice is a Date field.

Zoho Support: I have tried contacting Zoho Flow support via email (support@zohoflow.com), but have not yet received a response.

Question for the Community: Has anyone else encountered a similar issue with the formatDate function in Zoho Flow when working with Zoho Invoice date fields? Are there any known workarounds or alternative ways to format the date for the Zoho Calendar event title or the Start/End Date fields?

Any assistance or suggestions would be greatly appreciated.

Thank you,


Nick S