Power automate flow to update the SharePoint list from excel data - Unable to run a flow due to date format error

Question

I had a simple power automate flow to read the excel data into SharePoint list. below is the flow that I had used.

In the create item flow, i have used the following format for all dates. I don't need the time. I only need date. When I run the flow i get the following error. Please help how to correct this error.

Output:

Answer 1

Change your date format to 'yyyy-MM-dd' - this is the format computers like (ISO).