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!

Categories:

Using flows

Snip1.JPG

Snip.JPG

Snip2.JPG

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Expiscornovus 33,189 Most Valuable Professional on at

Like (1)

Report
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'))

Was this reply helpful? Yes No
HGarrod 25 on at

Like (1)

Report

This has worked perfectly! Thank you for your assistance 🙂

Was this reply helpful? Yes No