Unanswered

How to add in an Expression if Dynamics Content as a Null value

(0) Share

Report

Posted on by Chris1968

1,146

Hi,

I have an app that may or may not have two dates.

In my Flow an email goes to various people / departments and to get the date in the correct format I've used an expression.

My flow as failed when there is not date in one of the fields.

Can I get round this via the Flow process or do I need to look at a formula in the app itself??

I do have a similar Expression for Amounts to format these so can this be taken in to consideration??

Regards

Chris

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report
Hi Chris,

Please test for null or empty value in the field using if function in the expression. You could try this:

if(empty(triggerOutputs()?['body/ReturnTravelDateTime']),'Not Available',formatDateTime(triggerOutputs()?['body/ReturnTravelDateTime'],'dd/MM/yyyy'))

here, if ReturnTravelDateTime is null or empty, the expression will return 'Not Available'. You may modify this in the expression as per your need.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Chris1968 1,146 on at

Like (0)

Report

Hi @ManishSolanki

Thank you for your solution. Worked perfectly 😊

Was this reply helpful? Yes No