Hello , I hope someone could guide me in order to fix this issue.
I'm getting the start date from a Get Calendar View Event
"start": "2023-05-26T13:00:00.0000000",
Also, Initialized a variable (DateWithoutFormat) type string to extract and save the date.
The expression value to extract the day,month and year is the following:
formatDateTime(substring(items('Apply_to_each')['startWithTimeZone'],0,10),'dd-MM-yyyy')
Then I use 2 compose actions with the following expression:
1. Action: DateWithoutFormat2 Value: The value is the variable DateWithoutFormat
2. Action: DateWithFormat Value: formatDateTime(parseDateTime(outputs('DateWithoutFormat2'),'en-US'),'dd/MM/yyyy')
So that solve the ISO issue
Then in the "Create Item" Action, I've a field named "Date_MT", wich is a date field and the value is the Output from the compose DateWithFormat.
but when I´m creating an item into my Sharepoint list this error message appears:
"The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/OData__x0041_TT3' is required to be of type 'String/date'. The runtime value '"26/05/2023"' to be converted doesn't have the expected format 'String/date'."
I already checked the Date Field on my SharePoint list , but I don´t know what I´m missing .
If someone could help me I appreciate it.
