Skip to main content
Community site session details

Community site session details

Session Id : YcNwAdmJzUlm4b4oq0B4Nj
Power Automate - Building Flows
Answered

Iterate over variable array

Like (0) ShareShare
ReportReport
Posted on 5 Oct 2022 17:51:50 by

Hi, I am very new to power automate, would appreciate if someone can help me with a pretty simple problem. I have an array of customers as follows:

 

[
 "customer 1",
 "customer 2",
 "customer 3"
 .
 .
 .
]

 

I want to call "Power BI Report Export To File" step by passing it values from my array one at a time till all the end. In short, I want to iterate over my array and for each entry call another step which is passed on one value from my array.

 

For example: In iteration one, I want to pass "customer 1", in iteration two, "customer 2", and so on.

  • Community Power Platform Member Profile Picture
    on 06 Oct 2022 at 05:36:17
    Re: Iterate over variable array

    @ScottShearer thank you so much. Works like a charm. 

  • Verified answer
    ScottShearer Profile Picture
    25,236 Most Valuable Professional on 05 Oct 2022 at 19:40:39
    Re: Iterate over variable array

    @Anonymous 

    See my example below and substitute your Power BI action for my Compose action.

    image.png

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Loading complete