
Hi there,
I have an excel spreadsheet with four date columns; Year End, Import Deadline, Tax Due and Payment Due. All are hard-typed figures rather than calculated fields and are formatted in the same way. I have an automation built to create a sharepoint item using these values.
I have done this for the year end using two compose steps.
Compose 'SPYearEnd' which is the expression:
You no longer need to do the addDays() expression. In the Excel action, click on advanced options and set the DateTime format to ISO 8601. Remove the AddDays expression and just reference Year End. Re-run your Flow and post results here.