Loop trough each report in Power BI

[Ada1998]

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.

[Agnius]

Can you provide some screenshots of your flow?

[Ada1998]

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.

[Agnius · Accepted solution]

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-...

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.