Utilities in Formatter by Zapier - Lookup Table isn't working

Hi @McHenry, welcome to the Community! 😁

Ah, it’s not actually returning a row number that’s the number for the blank line item it’s returned. Looking at the line item data it’s receiving (GST and GST Free) neither of those line item values contain the word gstData which is why it’s not finding a match: 

And as no fallback value has been set it’s returning two empty line items. A lookup table will search the input to find a match for the keys (added on the left hand side) and return the value (that’s on the right hand side). For example if you wanted to output the value “InvoiceNinja” when a line item contains the word “GST” and output “A different value” when there’s a value of “GST Free” you’d set it up like so:

That would give you two line item values as shown below if the values GST and GST Free are passed into the lookup table:


That said, I see you’ve tagged Zapier Tables as one of the apps relating to this issue. But I’m not seeing any Zapier Tables actions in the screenshots of your Zap set up. So is it that you’re wanting to use the Formatter (Utilities > Lookup Table) action to search a Zapier table?

If so, you’ll want to try using a Find Record (Zapier Tables) action instead:


That action will allow the Zap to lookup a single row in the Zapier table and return all the information it contains.

Hope that helps to get you pointed in the right direction. If I’ve misunderstood or you run into any trouble on that do let us know! 🙂