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
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
Solved! Go to Solution.
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?
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.
I have made a test on my side, you could refer to screenshot below to create the flow:
The expression in the compose2 as below:
The flow would run successfully as below:
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!
Flow Community Manager
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!