Skip to main content

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?

Hi @Jojin 

Good question.

The image did not attach.

 


this is the output which needs formatting

 


@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


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


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


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