Skip to main content
Answer

Bug: Filter by text doesn't work for line items

  • April 26, 2024
  • 5 replies
  • 89 views

The current filter functionality does not behave as expected when used with line items. There appears to be a discrepancy between the UI display and the actual data processing logic.

 

  • Scenario: When using a filter such as (Text) contains "," on a field with line items displayed as "123123,292929". So it’s “Only continue if "123123,292929" contains “,”.
  • Expected Behavior: The filter should trigger because the combined field value shown in the UI contains a comma.
  • Actual Behavior: The filter does not trigger. It seems that the system is checking each line item individually (i.e., "123123" and "292929" separately), neither of which contains a comma, rather than the combined string.

 

Or same if you use:

 

So it should only continue if “Candidate Duplicates” doesn’t exactly match “Candidate ID”.

 

Candidate Duplicates is here a line-item(s).

 

Example:

  • Candidate Duplicates shows in the UI as “61289731, 64942779, 65480446, 66053111, 68455381, 70584611”.
  • Candidate Id is “70584611”

 

In the Zap Run History it looks then like this:

 

So it should’ve continued, but it didn’t.

 

Probably because it checked each value individually and the last value exactly matches the candidate id, but not all values together.

 

Please fix or make clear in the UI. Or am I missing something?

Best answer by Troy Tessalone

Hi @Kroeger 

Try adding this Zap action step: Formatter > Utilities > Line Items to Text

This flattens the array of line items into a text string.

Then map the output variable from the Formatter step to the Filter step.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • April 26, 2024

Hi @Kroeger 

Try adding this Zap action step: Formatter > Utilities > Line Items to Text

This flattens the array of line items into a text string.

Then map the output variable from the Formatter step to the Filter step.


  • Author
  • April 26, 2024

Yeah did that (and worked), but would be nice if it works out of the box in future.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • April 26, 2024

@Kroeger 

Feedback and feature requests can be submitted via a ticket to Zapier Support for those to be properly logged: https://zapier.com/app/get-help


  • Author
  • April 26, 2024

@Kroeger

Feedback and feature requests can be submitted via a ticket to Zapier Support for those to be properly logged: https://zapier.com/app/get-help

Yeah ticket is already open but answer is just “It’s expected, use formatter to fix”. Wrote first with the live chat and they told me 5 different things which all made 0 sense. Wasted 1h of my live.


  • Author
  • April 26, 2024

So maybe some Product Manager looks at zapier community and writes down problems to fix