About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials Zapier University 101

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Popular Apps Q&A Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

Interest Areas User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier University Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

How to filter out this output from formatter step?

  • 10 March 2023
  • 6 replies
  • 37 views
Jojin
Userlevel 1
Badge

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?

1 Attachment

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Jojin 

Good question.

The image did not attach.

 

⚡ Troy Tessalone - AutomationAce.com | Certified Zapier Expert (Premier Tier) | #1 Zapier Community Contributor
Jojin
Userlevel 1
Badge
this is the output which needs formatting

 

Troy Tessalone
Userlevel 7
Badge +14

@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

⚡ Troy Tessalone - AutomationAce.com | Certified Zapier Expert (Premier Tier) | #1 Zapier Community Contributor
Charie
Userlevel 1
Badge +1

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
Userlevel 1
Badge

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

Charie
Userlevel 1
Badge +1

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! 😊

Reply


Terms & Conditions