cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jasper1234
Helper II
Helper II

Flow - Forms to sharepoint / create new item -> Date problem

Hi,

i have a strange issue all of the sudden. I have a form for externals to submit planning details and dates (date picker) for projects. Upon a new submitted form, a flow is triggered to create a new item in a sharepoint list (regular date/time columns). 

It worked well, no issues. 

 

Then i had to force a logout and password change for my admin user and now all of the sudden the flow fails for below reason:

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Contractual_x0020_shipment_x00200' is required to be of type 'String/date-time'. The runtime value '""' to be converted doesn't have the expected format 'String/date-time'.

 

So apparently there is a time format issue, coming out of nowhere. It was fine before and worked, i didnt change anything in this sense. 

 

Any idea? i mean afterall if i have a forms date picker and the sharepoint list columns are date/time as well. I want to assume no matter in which format, these two microsoft tools should speak the same language and the format should only be a kind of "display" option. No matter the input, both tools should know the date and be able to display it in whatever format, even if its different, right?! 

 

its a bit strange, but maybe someone has an idea what caused this?

 

thanks

1 ACCEPTED SOLUTION

Accepted Solutions
RobElliott
Super User
Super User

@Jasper1234 it looks like the date was empty because the error message is the runtime value '""'.....

View solution in original post

5 REPLIES 5
RobElliott
Super User
Super User

@Jasper1234 it looks like the date was empty because the error message is the runtime value '""'.....

@RobElliott thanks. I just noticed the raw data delivers a "" if the date field was left empty in the form. And apparently this is not convertable to a date for the flow. makes sense. 

But how do i avoid this issue? not every date picker field in the form is required, some will always be empty. also for the sharepoint lists these date columns are not required. 

 

no idea from which side to appraoch this, but i want to say microsoft forms is quite limited in options and i cant change how the data comes in. Do i need to change something in the flow, or do i need to change it in the sharepoint list itself?

 

ms_flow
Frequent Visitor

@Jasper1234  I am also facing the same issue . Did you find any solution for this ? This will be of great help.

Appreciate any suggestion/pointers 

Is there a way to avoid this error if no date is entered?

Barking_Mad1
Helper I
Helper I

I've just got this problem too, although I'm pretty sure this was working fine previously as ive had people using the form, but I then had to delete it and start again.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,615)