Flow Error Handling

[Gofunk1]

Hello

I'm in the middle of building a flow, and whilst the flow is doing what I want it to, it keeps flagging an error.

I have a condition that confirms a value is present in the SharePoint item, it passed a string to the condition if it is present the flow continues, however, if the field is empty, it passed a null value and errors out. How can I cleanly terminate this?

[efialttes]

@Gofunk1 
Can you share a screenshot with the details of your Condition action block rule design?
THanx! 

[Gofunk1]

I think you mean this?

[efialttes · Accepted solution]

@Gofunk1 
I've implemented a simple TEst Flow that reads an item from a TEst List with an optional column called 'Date'
In order to avoid the error you are experiencing, I am using coalesce() expression to replace null by an empty string, and keep original column value if present

coalesce(outputs('Get_item_from_master_tracker')?['body/Date'],'')

Hope this helps

[Gofunk1]

thanks, can you share a screenshot on this, please? I'm still quite new to this and not sure how to implement your suggestion?

[efialttes]

Hi!
I've edited my last response, you will find a screenshot there
Hope this helps

[Gofunk1]

@efialttes Thanks for the response, but how does this validate the start date column? I've tried replacing both start date entries but everything now passes as a false output regardless of if there is a date or not. I could be using the wrong value in the string function?