Unanswered

Form Date (not required)

(0) Share

Report

Posted on by sroet2938

I am working with an employee form where the employee selects yes or no on a certfication and enters in the date of that certfication IF they have selected yes.

The issue is with power automate. Because that date is not required, I keep getting an error when running the flow.

I have tried formatdatetime and all that good stuff. How can I get this to input the date when one is entered or leave it blank if one is not entered?

Thanks all-I am on hour 4 of trying to figure this out!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

Hey @sroet2938

So the Date can be Empty right? If I understand correctly when the date is empty is my understanding correct?

In that case, you can use an expression like below:

You can try the expression is as below(change the dynamic values with your values)...

if(empty(outputs('Get_response_details')?['body/rbf4dd1ae786548b882a92abca7xxxxxxx']), '0',outputs('Get_response_details')?['body/rbf4dd1ae786548b882a92abca7xxxxxxx])

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @sroet2938

You have to check whether the date field is empty or not. if it is empty, assign with '' else format the datetime see below expression for demo:

if(empty(outputs('Get_response_details')?['body/r959c7f6c850d423aa6e881034be8f9c2']),'',formatDateTime(outputs('Get_response_details')?['body/r959c7f6c850d423aa6e881034be8f9c2'],'yyyy-MM-dd'))

[in your case , replace the highlighted expression part with your datetime field dynamic content ]

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
sroet2938 4 on at

Like (0)

Report

Thank you!

Was this reply helpful? Yes No