Answered

Date field throwing error if I try to pass a null expression - Power Automate

(1) Share

Report

Posted on by jandresp11

According to previous forums, (https://powerusers.microsoft.com/t5/Building-Flows/Date-field-throwing-error-if-blank-Power-Automate/td-p/1251407) I should be able to pass a null expression to a Date field to keep it empty. However, I get this error message every time. I don't know what I could be doing wrong, I also tried expressions like this:

if(equals(outputs('Get_response_details')?['body/ra66dc3ce64ec4c63af091d4ced99b95c'],''),null,outputs('Get_response_details')?['body/ra66dc3ce64ec4c63af091d4ced99b95c'])

but I get the same error message.

All responses (10)

Answers (1)

PobleteD 8 on at

Like (0)

Report

Re: Date field throwing error if I try to pass a null expression - Power Automate

Can confirm new designer has a bug when putting a formula to pass null value to date field. Switching to original designer and making sure to update the field (just formula - click update) solved the issue. Seems that PA has some sort of compilation happening behind the scenes when putting expressions, no idea. New Designer brought me some headache until I found this thread! Couldn't find a bug report option but if someone has a link happy to fill it in.
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Date field throwing error if I try to pass a null expression - Power Automate

Hi @jandresp11

Yes its a bug. Glad that all working well for you. Thanks for your reply.
jandresp11 14 on at

Like (2)

Report

Re: Date field throwing error if I try to pass a null expression - Power Automate

Switching to the classic designer worked!
Thank you!
Verified answer

abm abm 32,464 Most Valuable Professional on at

Like (1)

Report

Re: Date field throwing error if I try to pass a null expression - Power Automate

Hi @jandresp11

I made a video out of this

https://youtu.be/7I4b2vgG8y8

I believe there is a bug with the new designer.

Thanks
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Date field throwing error if I try to pass a null expression - Power Automate

Hi @jandresp11

I did tested this and worked for me

Try the below.

if(empty(outputs('Get_response_details')?['body/ra66dc3ce64ec4c63af091d4ced99b95c']),null,outputs('Get_response_details')?['body/ra66dc3ce64ec4c63af091d4ced99b95c'])
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Date field throwing error if I try to pass a null expression - Power Automate

Hi @jandresp11

Thanks for the screenshot. Let me get back to you soon.
jandresp11 14 on at

Like (0)

Report

Re: Date field throwing error if I try to pass a null expression - Power Automate

I believe I am already using the expression.
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Date field throwing error if I try to pass a null expression - Power Automate

Hi @jandresp11

Are you trying the null values as text or using the expression? Try the expression.
jandresp11 14 on at

Like (0)

Report

Re: Date field throwing error if I try to pass a null expression - Power Automate

I get the same error.
I also get the error when I just try to pass null expression directly, so I don't think it is the problem with the if statement. It is just not accepting null as an acceptable input...
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Date field throwing error if I try to pass a null expression - Power Automate

Hi @jandresp11

Error says you are getting "" (two double quotes) from the response. So try the below.

if(equals(outputs('Get_response_details')?['body/ra66dc3ce64ec4c63af091d4ced99b95c'],'""'),null,outputs('Get_response_details')?['body/ra66dc3ce64ec4c63af091d4ced99b95c'])