Skip to main content
Best answer

Getting rid of no data/item line from Xero

  • January 29, 2021
  • 3 replies
  • 212 views

Hi Zapier Community,

 

I would like to ask if it is possible to get rid of the no data details without removing it line-item section?
The data on the Utilities came from a Webhook connected to a ContactForm 7.


Here are the utility details I used for it.
 


As of now, here is what it looks like on my Xero


Can anyone help please? Thanks! ​​

Best answer by AndrewJDavison

@chanhalzkie 

You can use Looping by Zapier to go through each item in the list, filtering the individual loop where the value is blank and only creating a row where it isn’t.

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

3 replies

AndrewJDavison
Forum|alt.badge.img+11
  • Zapier Solution Partner
  • Answer
  • January 29, 2021

@chanhalzkie 

You can use Looping by Zapier to go through each item in the list, filtering the individual loop where the value is blank and only creating a row where it isn’t.


  • Author
  • Beginner
  • January 29, 2021

@chanhalzkie

You can use Looping by Zapier to go through each item in the list, filtering the individual loop where the value is blank and only creating a row where it isn’t.

Works perfectly. Thank you!


nicksimard
Forum|alt.badge.img+11
  • Zapier Staff
  • January 29, 2021

Thanks for confirming that @chanhalzkie! Glad that worked out for you :)