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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow to create item in...
Power Automate
Unanswered

Flow to create item in SharePoint List when Form is submitted fails when no date entered for one question

(0) ShareShare
ReportReport
Posted on by 8

I have a Microsoft Form which will populate a SharePoint list.

 

On the form is a "date access required until" question, which is a date field. This question does not always require an answer so may be left blank. However when it is left blank the Flow to create the item in the SharePoint list fails with:

 

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

 

Can I get round this at all?

 

Secondary question - If there is a date entered, and this appears in the SharePoint List, I would like an email notification on the date that has been entered. Does this require me to NOt have this field as a date/time filed in SharePoint List?

 

Thank you.

Categories:
I have the same question (0)
  • Lochwood Profile Picture
    16 on at

    I cant seem to get this working.. the error I get in flow.. " The expression is invalid"

  • RezaDorrani Profile Picture
    12,143 on at

    Hi @MS07 

     

    You can keep the date field in SharePoint

     

    when adding item in SharePoint using Flow

     

    for the date field add the following expression

     

    if(empty(datefield),null,datefield)
     
    Where datefield - dynamic content date field value from MS Form
     
    This will set it to null/empty in SharePoint if no value
    or populate it with data
     
    For sending email id date is filled
    Add a condition in flow
    Use flow condition your datefield is not equal to null and send email
     

    Regards,

    Reza Dorrani

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     
     
  • ScottShearer Profile Picture
    25,270 Most Valuable Professional on at

    @MS07 

    I am unable to replicate your issue.  Can you please do the following so that I and others might assist:

    1) Verify that both the SharePoint column and the Forms field are both configured to be dates?

    2) Post a screen shot of your Flow

     

    I tested a Flow and it ran successfully with and without a date entered in Forms.

     

    Also, regarding the email, you'll probably want to create a separate Flow with a recurrence trigger configured to run once a day.  Then, use a Get Items action with an OData filter.  Using the filter will limit the items returned to those with a date in your date column of today.  Then simply loop through the results and send your email.  The SharePoint column should be a date column.

    DateFilter.jpg

     

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 211 Most Valuable Professional

#3
trice602 Profile Picture

trice602 198 Super User 2025 Season 2

Last 30 days Overall leaderboard