Fix Power Automate String/Date Input Parameter Error in SharePoint
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.

- 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.
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.
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.
Open your workflow in the Power Automate portal and click 'Edit' to access the flow designer.
Click the '+' icon right before your SharePoint 'Create item' step and select 'Add an action'. Search for and add the 'Condition' control.
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).
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.

Use an Expression to Provide a Default Date
Use the coalesce expression directly within the SharePoint action to automatically substitute a blank value with a valid default date.
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. Download the software: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install the suite: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
- 3. Manage your files: Open your SharePoint-exported Excel files or flow documentation directly in WPS Office with perfect compatibility.

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.




