Answered

'Null' doesn't work correctly with multi-step condition and multi select column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

Here, I add one condition which check for if there is any null value in "ZIP/Postal Code" or "Street" field. If yes then update in excel.

Note: ZIP/Postal code is a multi select column. And Contain null value.

I also try with empty function but as it return true or false it won't work. also try space value. Flow always continue with no, even though the field contains null value[""]. Is there any solution to get condition result yes or skip null function with any other function.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

PrasadAthalye on at

Like (1)

Report
Copy link

Link copied!

Create variables and use Empty function.. Then in this condition compare variables to true and then proceed. This should solve the issue.

Please Like and mark this as answer if it resolves the issue.

Was this reply helpful? Yes No
yashkamdar 1,044 on at

Like (2)

Report
Copy link

Link copied!
Hello Team,

Here is a solution that should work for you definitely, I have used it tons of times.

You need to first create 2 COMPOSE actions and fill those 2 actions with the values of your Choice type fields.

Then use the Magic of Expressions as below-

empty(outputs('Compose')) is equal to true AND empty(outputs('Compose_2')) is equal to true

This is shown below-

This will work a hundred percent for your requirement.

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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@yashkamdar Could you help me to solve one more thing? @PrasadAthalye Could you help me for the same?

After trigger the condition yes, I updated the value in the excel. Now I need to update only those field which have null value.
In this case I need to update the value of street as the street only contain null value.

So what is a good solution in this case? I use if in expression like this:
if(equals(items('Apply_to_each_2')?['AddressZipCode'],null),'?','')

Is it true? May be it wouldn't work correctly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@yashkamdar Solution wouldn't work for me.

Here You can see the output of my compose action.

Condition is set to empty(outputs('Compose')) is equal to true then it will go further. Now as compose action has value it would be false.

Still it will give true. Could you please try again?

Was this reply helpful? Yes No
yashkamdar 1,044 on at

Like (0)

Report
Copy link

Link copied!
Hello Team,

Tried it just now and this is working just fine for me.

See below-

Condition is

empty(outputs('Compose')) is equal to True

Worked for me, maybe the data type of your value is different. Try copying my expression again and run the flow, it has to work.

That is the correct expression and I have been using it for long, see the screenshots above with your value as well i was able to get false.

How are you getting that value -75%45, let me know, awaiting response..;.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@yashkamdar You can try with Parallel Branch and Multi select column? If it working with that then let me know.

I appreciate your solution is quite easy but as I already share with you it's not work with my flow. You can see in shared images as well.

Was this reply helpful? Yes No