Failing due to error

(1) Share

Report

Posted on by AS-15050417-0

I have built a form and a power automate flow to take form data a publish in a sharepoint list. I am getting the following error in the power automate flow The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_7' is required to be of type 'String/date'. The runtime value '" "' to be converted doesn't have the expected format 'String/date'.

I believe it is the DOB date that is causing this issue, I have tried to convert the date but it is still not working? The date is appearing in the form data as YYYY/MM/DD this may be due to regional settings across our tenancy as USA when in australia but that aside...???

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

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @AS-15050417-0,

You need an if statement that checks if the date is null.

If %DateFromForm% = "" then null else %DateFromForm%.

------------------------------------------------

⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
Suggested answer

Riyaz_riz11 4,150 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
HI,

Solution 1: Add Condition to Check for Empty Date

Add a Condition before your "Create item" action

Condition Logic: Check if the date field is not empty

triggerOutputs()?['body/field_7']

Choose "is not equal to"

Leave the value empty or use null

If Yes Branch: Include your "Create item" action with the date field

If No Branch: Either skip the item creation or set a default date

Solution 2: Use Expression to Handle Empty Dates

In your "Create item" action, replace the direct field reference with this expression:

if(empty(triggerOutputs()?['body/field_7']), null, triggerOutputs()?['body/field_7'])

This will set the field to null if it's empty, which SharePoint can handle.

Solution 3: Format the Date Properly

Since you mentioned the date format might be causing issues, use this expression to ensure proper formatting:

if(empty(triggerOutputs()?['body/field_7']), null, formatDateTime(triggerOutputs()?['body/field_7'], 'yyyy-MM-dd'))

Solution 4: Use Compose Action for Date Conversion

Add a Compose action before "Create item"

Inputs:

if(empty(triggerOutputs()?['body/field_7']), null, convertTimeZone(triggerOutputs()?['body/field_7'], 'UTC', 'AUS Eastern Standard Time', 'yyyy-MM-dd'))

In Create item: Reference the output of the Compose action

Solution 5: Modify SharePoint Column Settings

Go to your SharePoint list

Edit the date column (field_7)

Under Additional Column Settings:

Set "Require that this column contains information" to No

This allows null/empty value

Solution 6: Handle Regional Settings

Since you mentioned regional settings differences, try this expression:

if(empty(triggerOutputs()?['body/field_7']), null, convertTimeZone(triggerOutputs()?['body/field_7'], 'UTC', 'AUS Eastern Standard Time'))

Best Practice Recommendation

I recommend using Solution 2 combined with Solution 5 as it's the most robust approach:

Set the SharePoint column to not require information

Use the expression to handle empty values

This handles both empty submissions and regional formatting issues

The key issue is that Power Automate is trying to convert an empty string to a date, which fails. By explicitly checking for empty values and setting them to null, you avoid this conversion error entirely.

If I have answered your question, please mark it as the preferred solution ✅ . If you like my response, please give it a Thumbs Up 👍.
Regards,
Riyaz

Was this reply helpful? Yes No