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

Brant F.

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.

Toufong Vang

@Brant F., Hi, Brant, the correct format is a string, yyyy-MM-dd.

Cheers!

Toufong Vang

@Brant F., Hi, Brant, the correct format is a string, yyyy-MM-dd.

Cheers!

rioardila