web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Copy from Form to Shar...
Power Automate
Unanswered

Copy from Form to SharePoint List fails - Date column blank/null?

(0) ShareShare
ReportReport
Posted on by 181

Hi All.

 

I've had a flow in place for a while to copy form submissions to SharePoint, the form contains a number of date picker fields which copy to date fields in the list. Not all of the date fields will be populated depending on what the end user enters. 

 

Everything worked fine up until I made a minor change to the form to add a multiple-choice question and updated the flow accordingly (no change to any date questions either within the form or flow) but now the flow is constantly failing as, I'm going to make an assumption from the following output, there are date fields in the form with 'Null' value:

 

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

 

I don't understand why this flow, when I made not changes to the date fields has suddenly stopped working due to the other date fields being null.

 

I'm guessing I need to insert an expression to make it 'OK' for the field to be null but I don't know what I'm doing with expressions so any help would be appreciated. 

 

 

Categories:
I have the same question (0)
  • OliverR-82 Profile Picture
    621 on at

    Hi,

    Can you maybe post a screenshot of your flow, or at least of the action that fails? That may help us understand where the cause for the problem comes from.

  • Angry_Sys_Admin Profile Picture
    181 on at

    @OliverR-82 

     

    As requested, in the second image, the parts highlighted in Yellow are date pickers in both the form and the SharePoint list. The last image is the failure report when I tested.

     

    Angry_Sys_Admin_0-1665906251726.png

     

    Angry_Sys_Admin_1-1665906421975.png

     

     

    Angry_Sys_Admin_2-1665906605638.png

     

     

  • v-liwei-msft Profile Picture
    Microsoft Employee on at

    Hi @Angry_Sys_Admin 

     

    Could you please tell me:

    Are you trying to submit a null value to SharePoint when the field is empty?

     

    I have made a test for your reference:

    vliweimsft_0-1665999286025.png

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

     

     

    Best Regards,

    Levi

  • Angry_Sys_Admin Profile Picture
    181 on at

    @v-liwei-msft 

     

    Yes I'm trying to submit the form to a SharePoint List with several date picker fields which will be Null/Blank

     

    I have tried your formula and it is now copying everything in the form contents to SharePoint EXCEPT the actual date, this is being copied to SharePoint blank even when the end user has put a date in the form field

  • v-liwei-msft Profile Picture
    Microsoft Employee on at

    Hi @Angry_Sys_Admin 

     

    Could you please show your flow and the formula.

     

    Best Regards,

    Levi

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard