I have the following table "New" and "Invoice Test". "New" list is essentially a PO List.
So, the current process is, I input company, title, amount and status in the "New" list. Then, I populate the Invoice Test list where PO1 is a lookup column from "New" list. I would like the "New" list to automatically populate the IN # matching the data from Invoice Test list. If the items match one to one I could run ms flow to solve this issue but I am currently stuck on the first item on "New" list (Title = a). Title "a" amount is $2000 with two invoices in Invoice Test list, a11 and a19. I can't seem to find a way to autopopulate two things on the same column using ms flow or any other methods that I could think of.
If you have any ideas in solving this issue, please help. I am open to any suggestions.