Microsoft Power Automate - Null Values & Dates

Question

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 below and screenshots below, I have left in the 'Dynamic Value' for 'Last Chased' for ref.

Thanks!

Answer 1

Hi Sukie

Thank you for your reply, I am however a little confused as I have managed to successfully format the date, in the other 2 lines using the posted formula, it is merely the 'Chase Date' which is failing.

I will raise with the Automate community, thanks.

Answer 2

Dear HGarrod,

Good day, thanks for querying in this forum. We’re happy to help you.

From your description, it seems that you are using Power Automate and you cannot format a date value in one line via formula with Power Automate.

If my understanding is right, we’d love to help you, since our category focus on general troubleshooting and built-in features in SharePoint online, the question you mentioned is related to use Power Automate, we’d suggest you go to Microsoft Power Automate Community - Power Platform Community to post a new thread, which is specific channel to handle such situation. The engineers in related team will focus on your specific scenario and provide specific suggestions.

If the scenario above is not consistent with yours, you can also post back and point that.

Thanks for your cooperation.

Sincerely，

Sukie | Microsoft Community Moderator