What date format works for Power Automate to input a date in Smartsheet?

Brant F.
Brant F. ✭✭
edited 01/09/23 in API & Developers

I am creating a Power Automate flow to input Form entries into a new row in Smartsheet. I am using Microsoft Forms and not Smartsheet's form because Power Automate will also perform other actions outside of smartsheet.

One of my form fields is a date entry. I am trying to get Power Automate to enter this in a Date field in Smartsheet. However, I get a message "The value for cell in column 5171285765973892, 07/20/23, did not conform to the strict requirements for type DATE." I have tried multiple formats with success. What date format should I use for Smartsheet to accept the date?

Or how should I make this work?

Thanks in advance.

Best Answer