Answered

Create event V4 gives an error when using a date from Get item (SharePoint)

(0) Share

Report

Posted on by EdK99

Hello all,

I'm building a flow to trigger when a new item is created in a sharepoint list, the flow will take that item's details (Subject, Start date, end date, location) and create a calendar event using these details.

in the create event connector I have the calendar ID, Subject, Start time and End time, and time zone. I am getting this error when I try to save the flow:

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_event_(V4)': The parameter with value '"@outputs('Get_item')?['body/field_7']"' in path 'item/start' with type/format 'String/date-time' is not convertible to type/format 'String/date-no-tz'.'.

Can anyone help me out with this? the date column in sharepoint list includes time, and the records into the sharepoint list are being entered through a powerapp.

I have the same question (0)

All responses (6)

Answers (1)

v-liwei-msft on at

Like (0)

Report

Re: Create event V4 gives an error when using a date from Get item (SharePoint)

Hi @EdK99

Could you please tell me:

Is this field a text column rather than a date column in SharePoint?
Could you please provide the date format in that column.

Best Regards,

Levi

Was this reply helpful? Yes No
EdK99 46 on at

Like (0)

Report

Re: Create event V4 gives an error when using a date from Get item (SharePoint)

Hi @v-liwei-msft , thank you for the swift response

it is a date column that includes time and the friendly format option is not enabled.

the output that I'm getting from the get item action in power automate is: "2022-12-04T21:00:00Z", so I think this is the format.

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (0)

Report
Re: Create event V4 gives an error when using a date from Get item (SharePoint)

Hi @EdK99

You can use formatDateTime to convert the date to the format required by Create Event.

formatDateTime(outputs('Get_item')?['body/field_7'],'yyyy-MM-dd hh:mm:ss')

Best Regards,

Levi

Was this reply helpful? Yes No
EdK99 46 on at

Like (0)

Report

Re: Create event V4 gives an error when using a date from Get item (SharePoint)

It worked, thanks a lot!!

Was this reply helpful? Yes No
kironr 2 on at

Like (0)

Report

Re: Create event V4 gives an error when using a date from Get item (SharePoint)

Where do I add this line? In the code view or the gui after the dyanamic field "start date-time"?

Was this reply helpful? Yes No
SCFowler 2 on at

Like (0)

Report

Re: Create event V4 gives an error when using a date from Get item (SharePoint)

Hi - I have tried to use this solution when creating an event - but I get this error

The string was not recognized as a valid DateTime. There is an unknown word starting at index 0.
clientRequestId: 77cec753-f9b0-4f28-a62a-edf65be219fb

Was this reply helpful? Yes No