cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

https://powerusers.microsoft.com/t5/Building-Flows/Create-SharePoint-list-items-from-Excel-rows/td-p...

 

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.

1 REPLY 1
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

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

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!

Top Solution Authors
Users online (3,687)