Question

Date Formatting issue into SharePoint, Microsoft 365

  • 26 October 2023
  • 5 replies
  • 52 views

Webhook Trigger. The connection is good. Item ID and Text data working. Problem is Date Formatting not being accepted by SharePoint. Throwing code shown in attachment.

I have Date being formatted by formatter, and using that (as well as a ton of other attempts). The formatter tool works perfect. Even when I manually type in date with the exact format SharePoint shows and is set to, the fields do work together.

When I type exact format into SharePoint directly it accepts it. Hmmmm...…

https://cdn.zapier.com/storage/photos/daaef04863feac4d783342c1a5411f78.png

 

– Tom Murphy


5 replies

Userlevel 7
Badge +14

Hi @Tomxyz 

Good question.

To help us have more context, we would need to see screenshots with how your SharePoint step is configured in the Zap edit mode.

Here is what I have.

 

Thanks!

Userlevel 7
Badge +14

@Tomxyz 

FYI: This is not a valid From Format as it’s an actual timestamp value instead of the format convention like YYYY-MM-DD

 

SharePoint likely expects a timestamp to be in a specific format. e.g. YYYY-MM-DDTHH:MM:SS

 

Let me give that format a try!

Thanks For Shear This Blog !!

Reply