How to convert this to line item?

Hi guys,

I am using Xero Pack to import Xero Invoice data into the table, above is the output. I am trying to convert that into table with single line item like below.

Column 1 Column 2 Column 3 Column 4
Item Code Quantity Unit Amount
abc 10 $ 10
1 Like

Hi, there! Thanks for reaching out, Luis here happy to help! :smile: The pack maker is going to be the best source of support with this issue, as we cannot make changes to a third party pack directly. You can do this by reaching out to them at their support contact listed in the About tab for this Pack.

~Luis

Dear @Luis_Curiel , thank you for your reply.

Hello @Hendrik_Jap ,
The output you are showing - is that a table that is generated by the import pack? If yes and the structure of this table is reliable, you process this table and generate new rows (AddRow()) in your destination tables with a ForEach() formula, processing all the items.

If you share a (dummy) doc, I am sure one of us can help you in the right direction.

Greetings, Joost

2 Likes