Unanswered

List rows filter issue

(0) Share

Report

Posted on by CalebG

I'm currently trying to filter one of my tables by date and containing data in salesorderid. However, when I run the flow, I get an error that a null value can't be appended to an array, even though there shouldn't be a null value since that is part of the filter rows. Does anyone know what could be going wrong in this situation? Screenshot (60).png

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @CalebG ,

on the first look without any context it doesn't look to me that you're filtering using the 'Order (Value)' in the filter. It seems you're filtering by different columns.

Was this reply helpful? Yes No
CalebG 14 on at

Like (0)

Report
Copy link

Link copied!

Hi @tom_riha ,
the naming system is slightly confusing, but salesorderid is the actual column header and 'Order (Value)' is what the variable within salesorderid is named.

Was this reply helpful? Yes No
tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Then I'd check the outputs of the 'List rows' action. Go to flow run history, open the 'List rows' action and check the output JSON. If there's any row that has empty Order value, or that's missing the Order value property completely then your filter doesn't work.

In that case I'd check the conditions one by one - keep only 1st condition, run the flow, check the results; keep only 2nd condition, run the flow, check the results; etc. That way you can see which of the conditions doesn't work as expected.

Was this reply helpful? Yes No