I'm building a flow to set up new customers, which essentially is triggered by a form, takes the data and populates a excel file on sharepoint and then goes through various departments for approval with some loops to correct data etc. Each form response has a unique ID which is the line identifier on the excel document.
The problem I have is that any new customer can have 1 to 6 different shipped to addresses (which I have captured via the form), and I want to be able to get a department part way through the flow to be able to assign a manufacturing plants to each address (there are 4 options for manufacturing plant).
Any ideas on how I can do this within the flow, any help would be much appreciated as i'm currently stumped?
