Announcements
I have an inventory flow that is initiated by my PVA Chatbot and returns values to the PVA Chatbot to check for inventory where there is currently no value in a specified column. The issue I'm having is that both ways I've tried to have the flow evaluate cell data has failed. I've tried to check condition of column "Contract_Num" is equal to "null" but condition evaluates to false for all 19 entries even though 2 of them should be returning true. I've also tried to check condition where column "Contract_Num" is equal to the expression "empty(items('Apply_to_each')?['ExcelField'])" but again all instances evaluate to false when 2 should be evaluating to true. Is there an explanation to this? Is there another way to achieve this that I haven't discovered? Please see screenshots for additional info.
Spreadsheet being referenced
Instead of using a condition try using a filter array on the output of the list rows where that column is equal to null, or you may have to check against and empty string. The length() of the filtered output is the number of rows with null values in that field. The resulting array will be the rows with empty cells.
Your solution is valid. I did end up achieving it by simply checking the condition against "contains" "string(0)" and this worked as well. Thank you for your swift response.
There is an advantage to using filter array, because then you don't have to compare the value on every row. You can get a subset of rows that meet your condition without doing extra actions.
Yes, that does seem to speed things up on the flow. I noticed when I append it to my string variable that gets returned to PVA it includes a lot of curly braces and square brackets that I don’t get when I do it using the other method. Any idea why it’s displaying these using filter array?
The output is still an array that needs to be processed to turn it into a formatted string for return. The point is that its a smaller array that needs to be processed than the one you are processing now. So it should still be a bit faster.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Mohsin Ali 360
Valantis 253 Super User 2026 Season 2
11manish 184 Super User 2026 Season 2
