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 / Dynamic website table ...
Power Automate
Unanswered

Dynamic website table for daily flows

(0) ShareShare
ReportReport
Posted on by 2

I am having a really difficult time understanding how to dynamically pull this data from a web page. I will run the flow daily for each day of data.

 

There will always only be data for today (either 1 row or 0 rows if there is no data). The columns are dynamic and change whether or not there is data for that day. For example, here is an example of the data with ALL the columns:

FULL SIZING (all columns)FULL SIZING (all columns)

NO COLUMNS:

NO SIZING (no columns)NO SIZING (no columns)

PARTIAL DATA (some columns):

PARTIAL SIZING (not all columns)PARTIAL SIZING (not all columns)

 

I am struggling with dynamically assigning the values to the correct column headers. I have tried using the full XML Path but it does not properly track the values with the proper headers. 

 

What is the easiest way to pull the values and assign them to the headers (such as in a variable)? Each day, it could be either the full, partial, or no data, so it needs to be dynamic enough to capture that. For context, this is in a web page where I can inspect element. But I am not sure which actions to use and how to dynamically select the correct values for the sizing.

I have the same question (0)
  • Deenuji_Loganathan_ Profile Picture
    6,255 Moderator on at

    @lewist 

     

    Have you attempted to utilize the "Extract data from webpage" feature to isolate and capture only the columns of your table? Once you've identified the columns present in the table, you can then determine your subsequent actions for populating text accordingly.

     

     

    Some references for Extract data from webpages:

    https://learn.microsoft.com/en-us/power-automate/desktop-flows/automation-web#web-data-extraction

    https://www.youtube.com/watch?v=QllyIdxm4H0

    https://www.youtube.com/watch?v=UuQhzR4SlP4 

     


    Thanks,
    Deenuji Loganathan
    🤖 Automation Evangelist
    Deenuji - Follow me on LinkedIn

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

     
  • lewist Profile Picture
    2 on at

    The columns change and it is difficult to extract exactly how many columns there will be. I need to somehow figure out how many columns there are, exactly what those columns are, and how to assign the values to their corresponding titles. This dynamic aspect makes it challenging to properly figure out which headers are present for the day. When I use the HTML xPath to pull the exact spot, it changes if the columns change. So it incorrectly assigns a value to the wrong column header. There is no option to "extract full HTML table" because it is not an HTML table.

  • Deenuji_Loganathan_ Profile Picture
    6,255 Moderator on at

    @lewist 

    Is there any environment available on your end that I can access to check all the elements and provide appropriate assistance? Or, could you suggest a similar website or application where we can find similar functionality to check?

    Thanks,
    Deenuji Loganathan
    🤖 Automation Evangelist
    Deenuji - Follow me on LinkedIn

    -------------------------------------------------------------------------------------------------------------
    If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🌟

     

     

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 Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 463

#1
Valantis Profile Picture

Valantis 463

#3
11manish Profile Picture

11manish 264

Last 30 days Overall leaderboard