Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Flow suddenly broken - Forms -> SharePoint List, String/Date column error when empty

(0) ShareShare
ReportReport
Posted on by

Hi,


Really odd one here, I have a flow that has been running happily for months.  The basic process is there is a Microsoft Form with a bunch of questions, one of the questions is a Date control.  When the form is submitted the Form is processed by Flow and sent to a SharePoint List.  The SharePoint column that is receiving the data from the Date question is a "Date/Time" column. 


The Date question in the form isn't mandatory thus it can be empty.  As mentioned this has been working perfectly until the 4th March when it stopped.  If the Date question is empty I get the following error in Flow, if the date is present the flow completes.

 

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

 

The flow is very basic as you can see

 

flow-date-error.jpg

I've tested a similar form on another tenant I have access to and Flow processes the Date question perfectly if it has data in it or not.

 

Very confused!

 

Any help gratefully recevied.

 

 

 

  • v-litu-msft Profile Picture
    on at
    Re: Flow suddenly broken - Forms -> SharePoint List, String/Date column error when empty

    Hi @Rob_CTL,

     

    Your solution is a workaround that we often use. To prevent the column value empty will make the Flow failed, you could check if it is empty firstly, then use null or blank space to replace it if it is.

    I am glad you solved the issue by yourself. You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

    Best Regards,
    Community Support Team _ Lin Tu

  • Verified answer
    Rob_CTL Profile Picture
    on at
    Re: Flow suddenly broken - Forms -> SharePoint List, String/Date column error when empty

    A quick update:  I am still baffled why this appears to have stopped working and why the same form on a different tenant works but I've implemented the following workaround for now (just in case someone else finds this thread via a search).

     

    Adding the following expression in the Date field on the Create Item control

     

    if(empty(dynamic content),null,dynamic content)

     

    Example

    if(empty(outputs('Get_response_details')?['body/xxxxxxxxxxxxxxxxxx9c0444d0b27d9']),null,outputs('Get_response_details')?['body/xxxxxxxxxxxxxxxxxx9c0444d0b27d9'])

     

    flow-date-fix.jpg

     

    Cheers

    Rob

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492