Others

Fix Power Automate String/Date Input Parameter Error in SharePoint

Aamir Naveed AkramAamir Naveed Akram Nov 3, 2026 870 views

Question details

A Power Automate flow fails at the SharePoint 'Create item' action because a required date field receives an empty or blank value instead of a valid date string.

How to Fix Power Automate String/Date Input Parameter Error
Product
Microsoft Power Automate
Device & OS
not provided
Scenario
Executing a flow that creates a new item in a SharePoint list containing a mandatory date column.
Observed behavior
The flow fails during runtime, displaying an error message indicating that the input must be a String/date, but the received runtime value is blank.
Before you start

Review your recent Power Automate flow run history to identify exactly which dynamic content or variable is unexpectedly passing a blank value to the SharePoint date field.

Solution 1Recommended

Add a Condition to Handle Empty Date Values

Prevent the flow from failing by adding a condition to verify whether the date value is empty before executing the SharePoint Create item action.

By validating the data before it reaches SharePoint, you can branch your flow logic. If the date is missing, you can skip item creation, send an alert, or provide a default date instead of causing a workflow failure.

1
Edit the flow

Open your workflow in the Power Automate portal and click 'Edit' to access the flow designer.

2
Insert a Condition action

Click the '+' icon right before your SharePoint 'Create item' step and select 'Add an action'. Search for and add the 'Condition' control.

3
Configure the condition

Click the left condition box, select your dynamic date value, choose 'is equal to' from the dropdown, and type 'null' in the right box (using the Expression tab to enter the actual null value).

4
Define branching logic

Move your existing 'Create item' action into the 'If no' (false) branch so it only runs when a date is present. In the 'If yes' (true) branch, add logic to handle the missing date, such as sending an error email or assigning a fallback date.

Add a Condition to Handle Empty Date Values
Best Practice: Always validate inputs from external triggers (like Microsoft Forms or emails) before passing them to SharePoint required columns.
Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While resolving Power Automate workflow issues, you may frequently need a robust suite to manage exported SharePoint lists, document your flow configurations, and analyze data. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for all your everyday document needs.

  1. 1. Download the software: Visit the official WPS Office website to download the free installation package for your operating system.
  2. 2. Install the suite: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
  3. 3. Manage your files: Open your SharePoint-exported Excel files or flow documentation directly in WPS Office with perfect compatibility.
Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Easily open and analyze SharePoint list exports without formatting loss.Lightweight installation that runs smoothly even on older computers.Built-in free PDF editing to seamlessly manage workflow reports and documentation.
QA img-9

Frequently Asked Questions

Why does SharePoint require a specific date format in Power Automate?

SharePoint expects dates formatted in the standard ISO 8601 format (e.g., YYYY-MM-DDTHH:mm:ssZ). If a blank value or an improperly formatted string is passed, the system cannot parse it into a valid SharePoint Date/Time column, leading to a flow error.

How can I check if a string is empty using a Power Automate expression?

You can use the empty() function in the expression builder. For instance, typing empty(variables('MyDate')) will return a boolean value of true if the variable has no content, allowing you to route the flow appropriately.

Can I make the SharePoint date column optional to bypass this error?

Yes. If your business rules allow it, you can navigate to your SharePoint List Settings, click on the problematic Date column, and change 'Require that this column contains information' to 'No'. Power Automate will then be able to pass null values without triggering the String/Date input parameter error.