web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Compose doesn't work i...

Power Automate

Unanswered

Compose doesn't work if date column it blank

(0) Share

Report

Report

Posted on by LukeSykes

I'm using get items to interrogate a list, in which the items have 6 date of birth columns.

Problem is, it works fine if there's a date of birth in DOB column 1, but if DOB Column 2 is empty it fails

formatDateTime(outputs('DOB1'),'dd/MM/yyyy')

formatDateTime(outputs('DOB2'),'dd/MM/yyyy')

Any help would be grately appreciated

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Hi, you can add a condition if the value is empty
Should look like this :
if(empty(outputs('DOB2'),'', formatDateTime(outputs('DOB2'),'dd/MM/yyyy'))
----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

This looks great however it's telling me it's an invalid expression....

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report

I think i forgot a parentheses
if(empty(outputs('DOB2')),'', formatDateTime(outputs('DOB2'),'dd/MM/yyyy'))

Was this reply helpful? Yes No
LukeSykes on at

Like (0)

Report

Thanks for your help on this - however i'm still encountering problems

The idea is, if the day and month of Today matches the day and month of the Date of birth column, send an email.
(I know the Convert DOB1 is not today - i'm wanting it to pick out a test list item)

Expressions in the condition:
Outputs('Convert_DOB1') is equal to outputs('TodayConverted')

and so on

Was this reply helpful? Yes No

Join the conversation