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 / Extracting data from a...
Power Automate
Unanswered

Extracting data from a webpage as a list instead of datatable

(0) ShareShare
ReportReport
Posted on by

Hello.

 

Having a problem with extracting data as a list instead of datatable.

 

What I want to do with the data is to compere it against another list and get unique values.

 

I know that I can use a for each loop to add them to a list and than work with the lists, but I have hundereds of entries and just running a for loop on it slows the flow down by quite a lot.

 

So is there a trick to forcing out a list of text values from data on a webpage that has it formatted as a table? On the webpage it's a three column table from which I'm grabbing the middle column.

 

Also if there is a way to just quickly extract unique values from n data tables I would love to hear that solution as well.

I have the same question (0)
  • Riyaz_riz11 Profile Picture
    4,214 Super User 2026 Season 1 on at

    Hi @ArthurOD ,

    You can store that values in a temp excel file and use excel as a database here you can write query or filter anything you can able to play.

     

    Regards

    Ahammad Riyaz

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

     

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 June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 167

#3
Haque Profile Picture

Haque 154

Last 30 days Overall leaderboard