Power Platform Community Forum Thread Details

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 'YearEnd', which pulls the value from excel.

Compose 'SPYearEnd' which is the expression:

if(empty(item()?['Year End']),null,addDays('1899-12-30',int(item()?['Year End']),'yyyy-MM-dd'))

This works perfectly for the year end column, but when I apply exactly the same steps to Import Deadline, Tax Due and Payment Due the fields are blank in SharePoint.

Does anyone have any pointers? I can't understand why it works for one date and not another when they're formatted in the same way and I'm applying exactly the same steps.

Thanks

Categories:

Using flows