Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : QlBz7CKvkEanI7R0OEUe3R
Power Platform Community / Forums / Power Automate - Building Flows / Error when running flo...
Power Automate - Building Flows
Suggested answer

Error when running flow that moves data from Forms to SharePoint in just one date/time field

Like (0) ShareShare
ReportReport
Posted on 14 Mar 2025 21:03:26 by EB-14032055-0 2
We have two flows that are built in the same manner as the flow that errors that work with no issues. The flow that isn't working is supposed to move data from Microsoft Forms to a SharePoint list and it fails only one one date field. This is the error we receive:
 
The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/ExpectedEndDate' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.
 
This is the date field in the flow below and in the form this is a date field, just like in the other flows that work. In the SharePoint list, it is a date field that doesn't show the time and is in friendly format.
 
Does anybody have any idea why I'm getting a string date error?
 
Thanks!
Categories:
Business Process Flows
  • Suggested answer
    Ellis Karim Profile Picture
    Ellis Karim 10,725 Super User 2025 Season 1 on 15 Mar 2025 at 11:46:36
    Error when running flow that moves data from Forms to SharePoint in just one date/time field
    Hi 
     
    It seems that outputs('Get_response_details')?['body']['f79a70660ecf14b1b9c13d1b2d131d445'] is empty (i.e. a blank string ""), and you can't set a date to an empty string.
     
    Try the following expression for the Effective Date Change column. It checks to see if the response is empty:
    if(
    empty(
        outputs('Get_response_details')?['body']['f79a70660ecf14b1b9c13d1b2d131d445']
    ), 
    null, 
    outputs('Get_response_details')?['body']['f79a70660ecf14b1b9c13d1b2d131d445']
)
     
     

    Ellis Karim Ellis Karim
    Blog | LinkedIn | Bluesky

  • Suggested answer
    EB-14032055-0 Profile Picture
    EB-14032055-0 2 on 14 Mar 2025 at 21:44:32
    Error when running flow that moves data from Forms to SharePoint in just one date/time field
    The issue was in the "create Items" SharePoint action in the flow. Removing it and re-creating it fixed the issue.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Thomas Rice – Community Spotlight

We are honored to recognize Thomas Rice as our March 2025 Community…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,508 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,436 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans