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 / Searching web data res...
Power Automate
Unanswered

Searching web data result based on excel sheet, need help

(0) ShareShare
ReportReport
Posted on by 95

Hi All,

 

This is my first time explored on Power Automate Desktop.

Previously i just ventured around with the cloud version, thus there's a lot of functions & module I'm not sure how to used.

 

Currently I want to do something, whereby I need PA to help me go through a list of username from an excel sheet,

and then login to a website.

Filter some of the option(as shown below)

Click search & click view transaction log. 

If there is a result, it should pop-out there is result, while if no result, it also need to show me no result message. 

 

foxngn84_0-1646301680270.png

 

 

In my work, do i still need to use For each, or i should just use Loop?

I only manage to got until this far as shown in the screenshot. 

 

auto.png

  • VJR Profile Picture
    7,635 on at

    @foxngn84  , you can use For each because anyways you want to loop through the records in Excel.

    Add an Ui element for the area where it shows the Result.

    After clicking View transaction log, check if the Result area is blank and accordingly show the popup message using Display box.

  • foxngn84 Profile Picture
    95 on at

    If i added all Ui element of all the steps, how do i let PA knows to search only based on the excel list?

    Another things is, I'm not sure is the website issue or PAD issue, as UI element freeze when I try to add in, it takes time for the red rectangle to appear, but once I ctrl+click, it disappear. 

     

  • VJR Profile Picture
    7,635 on at

    The Ui element is not for any of the Excel records. It is only for the Result area. So it is not dependent on any of the Excel records.

     

     

     

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 273 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 235

#3
David_MA Profile Picture

David_MA 172 Super User 2026 Season 2

Last 30 days Overall leaderboard