Skip to main content
Question

How to filter out this output from formatter step?

  • March 10, 2023
  • 6 replies
  • 119 views

Jojin
Forum|alt.badge.img+1

Here the output shows separate fields (along with user, ts and type)for each text being sent in slack.
My question is out of the list, how to filter out based on user id.
for example if user = <user id>, format remove the matching result and output only the text sent other users in separate fields.
How can I do this filter using formatter by Zapier?

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

6 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 10, 2023

Hi @Jojin 

Good question.

The image did not attach.

 


Jojin
Forum|alt.badge.img+1
  • Author
  • Beginner
  • March 10, 2023
this is the output which needs formatting

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • March 10, 2023

@Jojin

If you want to handle each line item in the array separately, then you can use the Looping app: https://zapier.com/apps/looping/help

Follow that with a Filter step.

 

Otherwise, you’ll have to use a Code step: https://zapier.com/apps/code/help


Charie
Forum|alt.badge.img+4
  • Zapier Staff
  • March 15, 2023

Hi @Jojin 

I see that you’re already working with one of our Support Specialist and they suggested this,

Do you want the first line item to be always removed/ignored by the Zap? In that case you could use:

  • the Line Item to Text Formatter action to split the line items into individual fields
  • The Line Itemizer to combine all the individual fields into a line item again, but without the first item

If you want to be able to map the entire line item at once, try mapping each line item field from the previous step into your "Text to Line Item" step, and separating them with commas.
You can read more about using text and line item formatting here: 

However, Troy also suggested using Looping and Filter by Zapier.

Have you tried one of those suggestions? If so, may I know what worked for you?

Looking forward for your response! 😊


Jojin
Forum|alt.badge.img+1
  • Author
  • Beginner
  • March 16, 2023

@Charie Code by zapier helped to format the output. thanks for catching up!


Charie
Forum|alt.badge.img+4
  • Zapier Staff
  • March 16, 2023

Hi @Jojin 

Awesome!

Could you kindly share how Code by Zapier worked for you? That way other members of the Community can see it and apply it on their end as well.

Would greatly appreciate it! 😊