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

Conversion of value to Data and Time format so that it can be uploaded to Sharepoint List

Hi All,

 

I am facing issue in converting the numeric value to Date and Time value.

 

Iam getting below value of date in the excel file:

 

ExcelDate.JPG

 

I want to convert it to the below format which is accepted by Share-Point list while mapping the data:

 

ConvertedFormat.JPG

 

The format is in "mm/dd/yy".

 

Please help here by suggesting the way of converting say "43870" to "mm/dd/yy" format.

 

Thanks,

Rohan Awasthi

rohawasthi@gmail.com 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Conversion of value to Data and Time format so that it can be uploaded to Sharepoint List

@RohanAwasthi 

Here is a link to a post that should help you out.  The issue is that Excel stores dates differently than Flow expects.

Here is another link with a solution.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

1 REPLY 1
Highlighted
Super User III
Super User III

Re: Conversion of value to Data and Time format so that it can be uploaded to Sharepoint List

@RohanAwasthi 

Here is a link to a post that should help you out.  The issue is that Excel stores dates differently than Flow expects.

Here is another link with a solution.

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (9,260)