Xero Bills to Monday.com creating a new line item for each line in a single Bill

Question

Hi all,

I have created a Zap that successfully takes any approved Bill within Xero (with filter applied for specific account code) and created a new line item within Monday.com. The purpose of this is for expense recharge tracking for my finance team.

The issue i am having is when the bill includes multiple line items, it is taking all the line items and throwing them together into 1 line item with Monday (description is made up with all line item descriptions thrown together etc.). I want the Zap to create a new line item for each and every line item included in the Bill and pul on the individual fields of each line item in the bill.

I have run through the Line item articles and training but am really struggling to get my head around how to produce multiple line items on Monday.

Any help would be very gratefully received.

Formatter setup. I want to draw this information from each line item to then produce multiple line items in monday)

I do not understand how to use my formatter to trigger actions to create multiple line items

Troy Tessalone · Answer

Hi @FredHackingGood question.If you are trying to create a new Monday Item for each Invoice Line Item, then try using the Looping app: https://zapier.com/apps/looping/help

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded