Power Platform Community Forum Thread Details

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.

Screenshot 2024-05-09 090605.png

Categories:

General topics

@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