Power Platform Community Forum Thread Details

Excel to SharePoint list data issue with Null date values and date values with ISO format error

HELLO TECHIES

This is really very bad experience for me working with MS flow data processing from Excel to SharePoint specially dates column.

I have across 20 date columns in single list and I am trying to just copy data from excel sheet to my SharePoint list tried many possible ways

1. tried IF(empty(),formatDateTime(),'') expression with many possible ways but expression fails for Null values.

2. tried actions condition for check null values even faced null values error and for formatDateTime() fails for 'dd/MM/yyyy' format its only need ISO format.

3.I had applied ISO format it self into excel action but still for few columns getting number formatted date values.

to resolve this issue don't know what i have to do now. experts and techies community kindly reply.

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

if(empty(items('Apply_to_each')?[outputs('Compose_4')]),null, addDays('1899-12-30',int(items('Apply_to_each')?[outputs('Compose_4')]),'yyyy-MM-dd'))

Error highlighted

'if(empty(item()[outputs('Compose_HQ_Update1')]),null, addDays('1899-12-30',int(item()[outputs('Compose_HQ_Update1')]),'yyyy-MM-dd'))' cannot be evaluated because property '' doesn't exist, available properties

if I go with Compose i am getting this type of value

value exists : '47852'

if null : '""' or sometime '""""' kind of and its not acceptable

i have tried expression null but its not working error shows '' as above already explain.

Quick Links

Leaderboard > Power Automate