Microsoft Power Automate - Null Values & Dates

(0) Share

Report

Posted on by HGarrod

Hello

I have a Power Automate Flow which runs happily, BUT, I am unable to format a date value in one line via formula - I just can't work it out!

The data it pulls from may contain no value, or date, until the item has been reviewed, I am trying to amend the date displayed when an email is sent, so that it returns a value that is formatted the same as those above.

Unfortunately, any formatDateTime that I have tried, will not ignore missing values and stops the Flow running fully, is there a way around this, I am using the formula below on 'Date Quoted' and 'Supply Date', both always contain a value:

formatDateTime(parseDateTime(items('Apply_to_each')?['DateQuoted']), 'dd/MM/yyyy', 'en-GB')

The 'Last Chased' value may not always be present, so I need a formula which will formatDateTime, but also ignore blanks, can anyone assist?

Example and screenshots attached, I have left in the 'Dynamic Value' for 'Last Chased' for ref.

Thanks!

Snip1.JPG

Snip.JPG

Snip2.JPG

All responses (2)

Answers (1)

HGarrod 25 on at

Like (1)

Report

Re: Microsoft Power Automate - Null Values & Dates

This has worked perfectly! Thank you for your assistance 🙂
Verified answer

Expiscornovus 31,641 Most Valuable Professional on at

Like (1)

Report
Re: Microsoft Power Automate - Null Values & Dates

Hi @HGarrod,

You could use the if and empty functions for this.

Try something like below:

if(empty(items('Apply_to_each')?['LastChased']), 'Last Chased Date field is empty', formatDateTime(items('Apply_to_each')?['LastChased'], 'dd/MM/yyyy', 'en-GB'))