Keep getting this error about formatting of date

(0) Share

Report

Posted on by KevinGador

824 Moderator

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)

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
Verified answer

v-qiaqi@microsoft.com Microsoft Employee 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