Create items handling null

[Thansson]

Hi

I have a flow, this was working until yesterday.

Take data from an excel table, and create rows in a sharepoint list.

Some date fields has null values, normally solved by:

if(less(length(items('Apply_to_each_2')?['LastInventoryDate']),1),null,items('Apply_to_each_2')?['LastInventoryDate'])

This is not working anymore ?

I have tried if empty, length and equal   no luck ?

coalesce(items('Apply_to_each_2')?['LastInventoryDate'],'')  

Only return null

Regards

Tony

[Tjan]

@Thansson Which error do you get? Since you only mention that 'it doesn't work anymore'. This will greatly help us to solve your problem!

[Thansson]

Hi @Tjan 

I have not changed any thing, both excel field and sharepoint field is a date field, I use ISO 8601 in get rows.

Regards

Tony

[v-mengmli-msft]

Hi @Thansson ,

Just like @Tjan mentioned, we need more details about your question, such as error of flow.

You can also try this firstly.

if(equals(items('Apply_to_each_2')?['LastInventoryDate'],null),null,items('Apply_to_each_2')?['LastInventoryDate'])

Best regards,

Rimmon

[Thansson]

Hi @v-mengmli-msft 

Your code is running without failure, but all fields are empty, also these containing a date:

Failure when using:

if(less(length(items('Apply_to_each_2')?['LastInventoryDate']),1),null,items('Apply_to_each_2')?['LastInventoryDate'])

[Tjan]

@Thansson  Ah! Please check the output 'List Rows present in table'. There might be other column values that are null (other than the ones you've taken into account already). 

[v-mengmli-msft]

Hi @Thansson ,

The error shows length can't be used on value which is null. So, you can replace it with equals.

I think the empty maybe caused by the incorrect date format.

Could you please show one LastInventoryDate of outputs of List rows in a table?

Best regards,

Rimmon

[Thansson]

Hi here input and output, when using :

if(equals(items('Apply_to_each_2')?['LastInventoryDate'],null),null,items('Apply_to_each_2')?['LastInventoryDate'])

Input:

Output:

Output is missing the field number 6 (LastInventoryDate)

[Thansson]

@v-mengmli-msft 

From excel:

From Sharepoint:

[v-mengmli-msft]

Hi @Thansson ,

Please show the LastInventoryDate of outputs of List rows in a table.

Outputs of SP will hide column with blank value.

Please try this and test again.

if(equals(items('Apply_to_each_2')?['LastInventoryDate'],''),null,items('Apply_to_each_2')?['LastInventoryDate'])

Best regards,

Rimmon

[Thansson]

Hi

Get item from sharepoint field 6 LastInventoryDate:

List from Excel output date:

[Thansson]

Hi @v-mengmli-msft 

if(equals(items('Apply_to_each_2')?['LastInventoryDate'],''),null,items('Apply_to_each_2')?['LastInventoryDate'])

if(equals(items('Apply_to_each_2')?['LastInventoryDate'],''),null,items('Apply_to_each_2')?['LastInventoryDate'])

Still provide empty field, no failure

[v-mengmli-msft · Accepted solution]

Hi @Thansson ,

There are spaces in 'Last inventory date', please modify the column name in expression.

if(equals(items('Apply_to_each_2')?['Last inventory date'],''),null,items('Apply_to_each_2')?['Last inventory date'])

Best regards,

Rimmon

[Thansson]

Hi @v-mengmli-msft 

Yes you are right, they have changed the column name in SAP, I didn't see that.

Sorry, and thank you

Tony