Unanswered

For each not working for me

(1) Share

Report

Posted on by WILKSN

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

trice602 16,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
WILKSN 8 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
trice602 16,135 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
WILKSN 8 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No