The issue is how you're checking for blank. In Power Automate filter arrays, null checks need specific expressions depending on the data source.
If your column contains an empty string rather than a true null, this expression won't return matches:
@equals(item()?['YourColumn'], null)
Try these instead depending on your scenario:
For truly null values:
@equals(item()?['YourColumn'], null)
For empty strings:
@equals(item()?['YourColumn'], '')
For both null AND empty string:
@or(equals(item()?['YourColumn'], null), equals(item()?['YourColumn'], ''))
For SharePoint specifically, blank columns often come back as null in some cases and empty string in others depending on the column type.
Combined with your 'Increase' filter in one expression:
@and(equals(item()?['StatusColumn'], 'Increase'), or(equals(item()?['BlankColumn'], null), equals(item()?['BlankColumn'], '')))
Check the raw output of your List Rows / Get items action to see what the blank column actually returns null or empty string and use the matching expression.
Best regards,
Valantis
✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.
❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).
🏷️ For follow-ups @Valantis.
📝 https://valantisond365.com/
