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.
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')​
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.