Keep getting this error about formatting of date

(0) Share

Report

Posted on by KevinGador

822 Super User 2025 Season 2

I keep receiving this error

The 'inputs.parameters' of workflow operation 'Update_item_-_Pending_Approver_1_AND_Approval_1_Link' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/RequestCreated' is required to be of type 'String/date'. The runtime value '"23-02-2024"' to be converted doesn't have the expected format 'String/date'.

when i try to do this to a DateTime column in my sharepoint list.

formatDateTime(convertTimeZone(utcNow(), 'UTC', 'AUS Eastern Standard Time'), 'dd/MM/yyyy')

what seems to be the problem? I don't understand at all.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (1)

Report
Copy link

Link copied!
Hi @kej,

That depends on if you have set the site settings with your timezone.

Generally, you send datetime to SharePoint as UTC and then the Site Settings will display it in your timezone if you have set the site settings with your timezone, you couls send the data from power automate to the sharepoint list without converting the timezone.

You just need to save the utc time as below:

formatDateTime(utcNow(), 'yyyy-MM-dd')

Was this reply helpful? Yes No
The21k 33 on at

Like (1)

Report
Copy link

Link copied!

From what i've read, some operations need to have the date format be like yyyy-MM-dd, meaning an ISO8601 date format. Give it a try to make your input date with the previous format, and don't worry about your output as it should be in the dd/MM/yyyy format.

Was this reply helpful? Yes No