hi guys sorry to bother you all, I'm trying to go through each Order ID and the run through the SKU lines for each Order ID with a different part of the flow before moving onto the next Order ID. I've tried if statements based on the Order ID is the same but can't get my head around this one at all. I guess you tell me it is a simple fix
thank you again trice602,
the code is so long ill try and explain what I'm trying to do,
flow logs into website and then,
"for each" row then adds the customer details on first row using Order ID and then gets to SKU and adds the SKU code, quantity and price.
Im trying to get the flow to loop through the SKU's if same Order ID without breaking out to complete invoice.
I don't know how to get the flow to process the customer details using the Order ID and then loop through all SKU for that Ordeer ID before submitting the invoice and start the next?
Hi @WILKSN ,
The image of excel you provided is not a table of data - it is a range. Can you please share your flow? Without seeing more, kinda guessing here.
thanks so much for coming back to me. have the data in a data table within power automate I just can't get the flow to work through each SKU before moving on to complete the order ID
Hi @WILKSN ,
Here's where to start. On the surface, your data is not in a "table" and is going to be first thing you need to fix. With your cursor in cell A2, press control-t and create a table. This is typically going to be labeled as Table1.
Then in your flow, use the action List rows present in a table and point to the file and select Table1 as the dataset. That's going to give the ability to loop through each row. In your subsequent actions, when you select the dynamic content from your List rows present in a table action, it will automatically wrap itself in a for each/apply to each.