cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jkeckard007 Helper III
Helper III

Excel to Sharepoint

I am adding a date from excel to SharePoint.  I can not use one drive multiple people need to add to this file so I am using Excell Bussiness Connections.

I want to do similar to what is listed here

https://powerusers.microsoft.com/t5/Building-Flows/Date-from-Excel-to-SPList/m-p/125785#M12292

However, I am having difficulty following this setup

my workflow fails at the step where I subtract the two days I am not sure where I am going wrong.  The date in Excel is general and only a date no time

Flow1.PNG

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jkeckard007 Helper III
Helper III

Re: Excel to Sharepoint

I was able to use the post at the bottom from Ireinhard7 to get this working

https://powerusers.microsoft.com/t5/Building-Flows/Convert-Excel-date-value/td-p/105686

 

View solution in original post

5 REPLIES 5
Erik-de-Rooij
Frequent Visitor

Re: Excel to Sharepoint

It seems there is an issue with the date format you have in Excel. Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1. In your example it is 43262.

 

Could you please add the expression of the failing action used in the configuration?

jkeckard007 Helper III
Helper III

Re: Excel to Sharepoint

Here is the format addDays(variables('Date Hire'),-2). In the end I just need to get the date hired column from my excel into the Sharepoint Date column.  I need it as a date so I can do graphs on this as well as counts by months etc.  This excel file comes from a different source.

jkeckard007 Helper III
Helper III

Re: Excel to Sharepoint

I was able to use the post at the bottom from Ireinhard7 to get this working

https://powerusers.microsoft.com/t5/Building-Flows/Convert-Excel-date-value/td-p/105686

 

View solution in original post

Community Support
Community Support

Re: Excel to Sharepoint

Hi @jkeckard007,

 

I have made a test on my side, you could refer to screenshot below to create the flow:

Capture.PNG

 

 

The expression in the compose2 as below:

formatDateTime(addDays(addDays('1900-01-01',int(outputs('Compose'))),-2),'yyyy-MM-dd')

The flow would run successfully as below:

Capture.PNG   

 

Best regards,

Alice

Administrator
Administrator

Re: Excel to Sharepoint

Hello, @jkeckard007!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!


Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager

-Gabriel
Microsoft Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (7,665)