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.

Categories:

Building flows

All responses (6)

Answers (1)

Sort by

v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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
EdK99 46 on at

Like
a
(0)

Report
Copy link

Link copied!

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

v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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
EdK99 46 on at

Like
a
(0)

Report
Copy link

Link copied!

It worked, thanks a lot!!
kironr 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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