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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Loop trough each repor...
Power Automate
Unanswered

Loop trough each report in Power BI

(0) ShareShare
ReportReport
Posted on by 16

Hello. 

I'm making an automatisation in Power BI using power automate desktop. I have a need to get all the names of people with access to each report in the workspace. 

I have tried to read all the text and herf and save it to the variable and also into excel sheet and than read it... but my loop is constantly running only on the first report in the workspace. 

Is there any solution? 

I occasionally also get a problem that in second loop there is an error on the button click where you click to see the properties of report.

I have the same question (0)
  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    Can you provide some screenshots of your flow?

     

  • Ada1998 Profile Picture
    16 on at

    Of course, I hope you can see it.

    This are translations 

    Zaženi nov Chrome - open new chrome

    Klik povezave na spletni strani - click the link.on the website

    Pritisk na gumb - click the button 

    Izvlečenje podatkov - get data 

    I started with link to workspace

    Than I selected the filter and click only on reports 

    The  I got data: name of report as text and href from the report that I saved it to a variable.

     

    In loop I selected To go from 0 to variable.rowscount add 1

     

    In loop I first click more option button on the first report (3 dots next to the name) and then select last option direct access.

    When I come to list of access I selected all the names in the list I scraped them and saved them in a word file.

     

    After that I want loop to go back to the workspace link and filter only to reports and goes all over again.

     

    After all the reports should be read and saved the programme should save an excel. 

     

     

     

    Later I have also added the "go back" function so loop goes back to the page with reports, where it filters again the site only to reports.

     

  • Verified answer
    Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    Well, when you loop through the values you extracted, you also need to use some sort of a variable in the selector for the element that you are clicking on. Otherwise, the same selector that you captured for the first item will always be used. For more info on how to use variables in selectors, see this article: https://learn.microsoft.com/en-us/power-automate/desktop-flows/build-custom-selectors#use-variables-in-a-custom-selector

    Also, watch this video: https://www.youtube.com/watch?v=2PcyBa22Jj8

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard