web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Automatically adding f...
Power Automate
Unanswered

Automatically adding for each

(0) ShareShare
ReportReport
Posted on by 35

Hi Team,

working on flow from power bi. 

I want to select 3 fields from power bi data. so after compose added select components,

however, it is adding FOR EACH automatically.

i am not understanding why its adding it.

 

Narendra90_0-1670935142735.png

 

Categories:
  • Sundeep_Malik Profile Picture
    6,501 on at

    Hey @Narendra90 

     

    The Power BI Data must be an array thats why its creating an apply to each. I have two three things in my mind to suggest to you. First one is, initialize an array variable outside this apply to each. Inside the apply to each use append to array and pass the body of select in it. And then use this array variable outside the apply to each. 

     

    I hope this helps. 🙂

  • Narendra90 Profile Picture
    35 on at

    Hi Sundeep Malik,

    Thanks you very much. However it only selecting first 1000 records.

    I have around 5000 rows. i need to filter only "Active" from project status column. 

    would you please guide me on this.

  • Sundeep_Malik Profile Picture
    6,501 on at

    @Narendra90 

     

    I have no idea why its only showing 1000 records.

    Can you do one thing, without that append to array, is the apply to each still running 1000 times or its running for more records?

    Probably its a limitation of Power Automate to read 1000 lines from Power BI. Read in some other posts. No idea tbh. 

  • Sundeep_Malik Profile Picture
    6,501 on at

    @Narendra90 

     

    Found this alternate solution instead, where the person has suggested to make a table from all the data. Not sure it will work or not, but you should give it a go. 

     

    https://community.powerbi.com/t5/Desktop/Power-Automate-export-1000-rows-only/td-p/1811090

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 307 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 127

Last 30 days Overall leaderboard