Answered

Import Empty Date Fields from Excel to SharePoint

(0) Share

Report

Posted on by FF-16012350-0

I have a flow that imports the data from an Excel worksheet into a SharePoint list. If a date field is left blank, we get an error importing. Is there a formula I can use to either leave the field blank in SharePoint or enter a date that users will know isn't correct, like 1/1/1900?

The error is:

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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

FF-16012350-0 6 on at

Like (0)

Report
Copy link

Link copied!

I have created this formula that doesn't fail, but it isn't importing the expected results. Any thoughts on how to update this formula to work correctly?

if(equals(item()?['Effective Date'], ''), parseDateTime('1/1/1900'), item()?['Effective Date'])

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,508 Moderator on at

Like (1)

Report
Copy link

Link copied!
@FF-16012350-0 Use a Compose action to store an expression. The expression will first check to see if the dynamic content is empty. If so, it'll output a null value, if not—it'll output the date.

if(empty([insert your date dynamic content]), null, [insert your date dynamic content])

Insert the output of the Compose action into the appropriate field of the Create Item action.

You may be interested in this YT Tutorial:

How to Work with 📆 Dates in Power Automate | Example Scenarios and Tips & Tricks

Are you easily stumped when working with Dates in Power Automate? In this Power Automate tutorial, I’ll show you how to compose an expression that will return a future date, a past date, how to count the number of days between two dates, how to check for a birthdate and anniversary date as well as tips and tricks when working with dates in Power Automate. I’ll cover some common use cases and concepts that can help you to build better Power Automate flows.

Feel free to skip ahead using the timestamps listed below. I’ve also linked a few other tutorials that you might be interested in as well.

IN THIS VIDEO:
✓ 4 Date Functions You Need to Know
✓ How to use the Convert Time Zone Action
✓ How to Get a Future Date
✓ How to Get a Past Date
✓ How to Return SharePoint Items Due in a Number of Days
✓ How to Return SharePoint Items Due within a Date Range
✓ How to write a Filter Query for SharePoint Items Due in 30, 60 and 90 Days
✓ How to Calculate the Number of Days between Two Dates
✓ How to Check for a Birthdate and Anniversary Date
✓ How to work with Dates and Times in Excel
✓ How to use a Manual Trigger with Date Input
✓ How to Output Dynamic Text with an Expression
✓ How to Check if a Date Falls on a Weekend

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
FF-16012350-0 6 on at

Like (0)

Report
Copy link

Link copied!

@creativeopinion - Thanks so much, that worked!

Was this reply helpful? Yes No