Filter Query issue with comparing form returning blank and list returning null

(1) Share

Report

Posted on by RW-23101855-0

I have a filter query: Software eq 'FormResponse'

When I fill out the form and leave FormResponse blank, the filter query won't return any rows from the list because FormResponse returns '' while all blank cells in the Software choice column return null.

Is there a way to write the filter query to treat '' and null as the same?

(This is part of a longer filter query where one software will have a value while others are left blank on the form: Software eq 'FormResponse' and Software2 eq 'FormResponse2' and Software3 eq 'FormResponse3'...etc.)

Categories:

Building flows

All responses (3)

Answers (0)

Sort by

Suggested answer

trice602 16,655 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Please try:

(Software eq 'FormResponse' or Software eq null)

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn
trice602 16,655 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey there!

I am following up on this post filter query issue with comparing form returning blank and list returning null in this category building flows from 12/13/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 1 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯
trice602 16,655 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯