Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Importing Excel dates to Sharepoint List

I have an excel spreadsheet that I want to import to a Sharepoint list.  I can do so using the flow in the link below


However, one of the columns in my excel spreadsheet is Due Date.  The Due Date = Today()+X, where X represents number of days (i.e., Today()+5 or Today()+10).  Each row in the excel spreadsheet has a different Due Date.  


When I import the spreadsheet into a Sharepoint list, I want to keep the format for the Due Date the same as the excel spreadsheet (Due Date=Today()+X , where X is the number of days).  How do I make that happen?  Thank you in advance.

Super User
Super User

Hello @augustine2 

This sounds more like you want a default value in column for the Due Date. Modify the column in your list to the formular you need.

Then when you import the data from Excel, just leave out the Due Date, so that when an item is created, it will take the default value - your formular - instead.

Does the above seems like what you need?

Kind regards, John

Helpful resources

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (78,287)