Answered

If expression for date failing

Like (0) Share

Report

Posted on 5 Jan 2023 19:31:18 by CRMCS

I am running the following flow to create items in SharePoint list from Excel files and I am receiving an error on the If expression I am using for the Date Returned column. I added the expression because I received an error for having no dates in some items.

The other date columns are pulling in as expected, but they all contain a date so no If expression was needed. I do have the DateTime format set to ISO 8601.

Is there something else I need to add to the IF statement?

if(equals(item()?['Date Returned'],''),null,item()?['Date Returned'])

Error Message:

All responses (2)

Answers (1)

CRMCS 19 on 05 Jan 2023 at 20:24:50

Like (1)

Report

Re: If expression for date failing

That worked! Thank you!
Verified answer

Sundeep_Malik 6,482 on 05 Jan 2023 at 20:08:24

Like (0)

Report

Re: If expression for date failing

Hey @CRMCS

Use the following expression it might help:

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

Link for Handling Excel Dates in Power Automate:

https://www.shanebart.com/ms-flow-excel-dates/

I hope this helps 🙂