Answered

How to fix a power automate flow that fails due to blank cells.

(0) Share

Report

Posted on by JM-30101957-0

This is my first time creating a power automate flow between and excel file and a sharepoint. The error I am getting happens on the columns with dates. I have three columns that contain dates. The date column only gets filled when a task is completed so it will eventually have a date in it but until it does I need the flow to keep it blank and then once I fill it in on the excel I would like it to show it on the sharepoint. If the column is blank it gives me an error.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

David_MA 14,821 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Wrap the values in coalesce expressions. You can read about it in this blog post: Power Automate Fundamentals # 6: Usage of Coalesce... - Power Platform Community.

Was this reply helpful? Yes No
JM-30101957-0 12 on at

Like (0)

Report
Copy link

Link copied!

I ended up using an expression in the date field that was showing an error. If(equals(items('Apply_to_each')?['TJO sent'],''),null,items('Apply_to_each')?['TJO sent'])

Was this reply helpful? Yes No
David_MA 14,821 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Glad you figured it out. You should learn how to use the coalesce expression, though. It is a lot more straightforward. Based on the expression you wrote, using coalesce it would have been: coalesce(items('Apply_to_each')?['TJO sent'], '')

Was this reply helpful? Yes No