web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Handling Blank Date C...

Power Automate

Unanswered

Handling Blank Date Columns in Excel-to-SharePoint list Power Automate Flow

(0) Share

Report

Report

Posted on by Sahil M

53

Hello Team, Hope you are doing great.

I did a schedule flow where it add and update excel data to sharepoint list. I have 2 columns in the excel that are in date format.

On the sharepoint list, I have put the 3 columns in date format as well.

On the PowerAutomate, I have put a function on the date columns.. Please find the screenshot below:

The function for extraction date is: formatDateTime(addDays('1899-12-30', int(items('Apply_to_each')?['Extraction Date'])), 'yyyy-MM-dd').

The issue is if a row in the date columns is blank, the automation will get error. Is it possible to put null(), or something on the blank columns in microsoft list. Then, when they update the row in the excel, then on the automation, the row will be updated.

Can someone please help me with this.

Thank you.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!
Just check for nulls by changing the expression:

if( equals(items('Apply_to_each')?['Extraction Date'], null), null, formatDateTime(addDays('1899-12-30', int(items('Apply_to_each')?['Extraction Date'])), 'yyyy-MM-dd') )

Was this reply helpful? Yes No
Building with Why 351 Moderator on at

Like (0)

Report
Copy link

Link copied!

You are probably getting a null in this scenario, but if the below answer does not work I would substitute string('') instead of null in the equals statement. The formatDateTime function does not handle non-date text strings and the error for null and blank can look the same.

Was this reply helpful? Yes No

Join the conversation