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
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications