Filter Query - when blanks are involved

[joel914823]

I have a matrix of "owners" of employee suggestions.  Dependent on the site,lob(line of business), the category and subcategory - different people will receive the assigned employee suggestion.  The  column subcategory is a new column but not all categories will have a subcategory so that field will be blank when it creates the record into sharepoint.  I notice that when items that have no subcategory assigned, the flow will not send an email.  If I test a type that has a site, LOB, category and subcategory, the assignee does get the email.  Any thoughts?   It seems the blank throws it off.   I also tried to do an OR statement with the same as below but removing the subcategory but that caused duplicate emails.

[creativeopinion · Accepted solution]

@joel914823 It would help to see your full flow. However, in the meantime—have you tried 

.... and (SubCategory eq '[SubCategory]' or SubCategory eq null): 

I would also recommend adding a Compose action after the Get Items action to return the count of items returned. This way you can verify the number of items being returned by the Get Items action. I cover this technique and more in this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram