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 / How to query a large a...
Power Automate
Answered

How to query a large amount of data on a website via PAD. And generate excel sheet?

(0) ShareShare
ReportReport
Posted on by 17

Hi,I have an excel sheet, which has 400 columns of data, how can I use the PAD to query these data in a website search at once to know whether those are no matches found?  and in the second column marked "no matches."

Mengi_0-1647873531765.png

Mengi_1-1647873553429.png

 

I have the same question (0)
  • VJR Profile Picture
    7,635 on at

    Hi @Mengi , did you mean 400 rows instead of columns? 

    Does the website manually support sending more than one ticket data to it and generating the results? In the search box you have shown does it allow to enter more than one ticket IDs separated by comma or semi colon? First you can figure out how it can be done manually and then mimic the same via PAD. 

  • Mengi Profile Picture
    17 on at

    Hi thank you very much for your reply, the search box on this site does not support multiple numbers separated by commas,If I need to query hundreds of data manually, is there any way to make the PAD query these large amounts of data one by one and then note in the second column that there are no results?I have attached a picture of the result I want, please advise.

    Mengi_0-1647919962677.png

     

  • VJR Profile Picture
    7,635 on at

    One by one yes you can do it via PAD if the website does not support all at once.

     

    This is a rough overview of what you could do.

    Assuming your Excel has two columns - Ticket Id | Results

     

    - Launch Excel worksheet

    - Read from Excel. This will give a datable with two columns

    - For each loop on the Datatable

    - Pick up the Ticket Id from the Datatable

    - Go to the url

    - Write the Ticket Id in the text box and hit submit or Search. 

    - Read the value of "No results found" and write it to Results column of Datatable.

       Do the same if results are found depending on how you identify when the page shows any results.

    - End For Each loop

    - Write the Datatable to Excel worksheet 

    - Save and Close Excel

     

  • Mengi Profile Picture
    17 on at

    Hi the problem I am currently having is that I am using loops but the text that fills the search field is the value of each row in my excel and not a single

  • VJR Profile Picture
    7,635 on at

    Can you share screenshots of what you are trying to convey.

  • Mengi Profile Picture
    17 on at

    Mengi_0-1647926766647.png

    Hi this is a screenshot of my current flow, when I want to query a single value, it always comes up with all the values,Just like this

    Mengi_1-1647926862299.png

     

     

  • VJR Profile Picture
    7,635 on at

    In line #7, instead of ExcelData pass %CurrentItem['YourColumnName']%

  • Mengi Profile Picture
    17 on at

    Thanks very much,😀😀 I'm just pausing here for a couple of days, and one last question, how do I set it up so that it fills in the second column of my search result text i (like in my screenshot at the top)

  • VJR Profile Picture
    7,635 on at

    maintain a counter and while you are inside the loop you can write directly to that column using the counter variable.

     

    VJR_0-1647928659358.png

     

  • Mengi Profile Picture
    17 on at

    Thanks again,  but how do I add the variable "counter"?

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 248 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 160 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 142 Super User 2026 Season 2

Last 30 days Overall leaderboard