Unanswered

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.

Categories:

Using flows

I have the same question (0)

All responses (10)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
jandresp11 14 on at

Like (0)

Report

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...

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @jandresp11

Are you trying the null values as text or using the expression? Try the expression.

Was this reply helpful? Yes No
jandresp11 14 on at

Like (0)

Report

I believe I am already using the expression.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @jandresp11

Thanks for the screenshot. Let me get back to you soon.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @jandresp11

I made a video out of this

https://youtu.be/7I4b2vgG8y8

I believe there is a bug with the new designer.

Thanks

Was this reply helpful? Yes No
jandresp11 14 on at

Like (2)

Report

Switching to the classic designer worked!
Thank you!

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @jandresp11

Yes its a bug. Glad that all working well for you. Thanks for your reply.

Was this reply helpful? Yes No
PobleteD on at

Like (0)

Report

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.

Was this reply helpful? Yes No