Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

For each not working for me

(1) ShareShare
ReportReport
Posted on by 8

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

IMG_6408.jpeg

  • WILKSN Profile Picture
    WILKSN 8 on at
    Re: For each not working for me

    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?  

  • trice602 Profile Picture
    trice602 11,729 on at
    Re: For each not working for me

    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.

     

     

  • WILKSN Profile Picture
    WILKSN 8 on at
    Re: For each not working for me

    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 

  • trice602 Profile Picture
    trice602 11,729 on at
    Re: For each not working for me

    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.

     

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard