cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jkeckard007
Level: Powered On

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
Level: Powered On

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
Level: Powered On

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
Level: Powered On

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
Level: Powered On

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 Team
Community Support Team

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,244)