I want to create a Xero invoice with dynamic line items from Google Sheets, skipping products with quantity 0 or empty

Questions
,
1

I want to create a Xero invoice with dynamic line items from Google Sheets, skipping products with quantity 0 or empty

3

Hi @Juan_Francisco_Matte,

Welcome to the make community… :tada:

You can achieve this by using an Iterator and filter before the Xero “Create Invoice” module. Then map your Google Sheets rows as line items, and only pass bundles where the quantity field is not empty and greater than 0.
After filtering, use an Array Aggregator to rebuild the valid line items array for Xero invoice creation.

Hope this helps.

Best Regards,
@Mohamed_Jahar