Skip to main content
Community site session details

Community site session details

Session Id : HCPTliTELhXHdPYGBOCuXx
Power Automate - Power Automate Desktop
Unanswered

Help to Extract data from web

Like (0) ShareShare
ReportReport
Posted on 14 Feb 2024 19:02:54 by 38

I have this simple flow

 

Lars5_1-1707937155460.png

 

 

I get this txt fra web in 1 row and 1 colum, how can i use data individually. and put them in variabler.

 

 

Lars5_2-1707937279765.png

 

 

  • Deenuji_Loganathan_ Profile Picture
    6,204 Super User 2025 Season 2 on 15 Feb 2024 at 13:52:12
    Re: Help to Extract data from web

    @Lars5  - I am very glad to see your solution.

     

    I considered suggesting the same option, but I'm uncertain about how your web application will react if certain values are not present in those UI elements.
    Please ensure thorough testing by fetching the correct values in different iterations.

     

    Thanks,

    Deenu

  • Lars5 Profile Picture
    38 on 15 Feb 2024 at 13:48:53
    Re: Help to Extract data from web

    Hi Deenu

     

    I find a solution

    Lars5_0-1708005228481.png

     

  • Lars5 Profile Picture
    38 on 15 Feb 2024 at 09:01:30
    Re: Help to Extract data from web

    Hi Deenu
    thanks for your help.

     

    The problem is that several of the fields are like dropdown elements and no value appears when I point to simple Ui elements.

     

    But if I take it all together, they come together fine and it doesn't look so messy. as each field comes on a new line. But it all comes together in one field in the table

     

    I hope it makes sense

  • Deenuji_Loganathan_ Profile Picture
    6,204 Super User 2025 Season 2 on 15 Feb 2024 at 08:50:25
    Re: Help to Extract data from web

    @Lars5 - No problem. Thanks for your details.

     

    If the item isn't in the table, we must individually extract each UI element, saving its value in a variable for further manipulation.

    Please refer to the images below to see how I extracted my phone number from the Salesforce application and stored it in a variable named 'phonenumber' in the PAD flow.

    Deenuji_0-1707986751194.png

    Deenuji_1-1707986787765.png

     

    If all the values aren't present in the table, you can't extract all those fields in single go. Doing so would result in messy, unformatted data.

     

    Thanks,

    Deenu

  • Lars5 Profile Picture
    38 on 15 Feb 2024 at 07:31:04
    Re: Help to Extract data from web

    Hi Deenu

    I apologize for my lack of explanation. I am a little limited in my English

     

    Unfortunately, data from the web does not come as a table. I think.

     

    I have attached a screenshot of the web when I try and pull data.
    And what comes when I press value. If I choose table I don't know what else to do

    Skærmbillede 2024-02-15 08.22.15.pngSkærmbillede 2024-02-15 08.30.07.png

  • Deenuji_Loganathan_ Profile Picture
    6,204 Super User 2025 Season 2 on 14 Feb 2024 at 19:52:44
    Re: Help to Extract data from web

    @Lars5

    If I grasp your situation accurately, you aim to retrieve data from a web application, yet the extracted data appears unformatted.

     

    Should the data be in a table within your web application, you can extract it as a variable (datatable). Then, utilizing a loop, you can effortlessly assign it to variables. Kindly consult the attached screenshot for a step-by-step guide.

    Deenuji_0-1707940308205.png

    Deenuji_1-1707940317016.png

     

    Deenuji_2-1707940322375.png

    Deenuji_3-1707940327874.png

    Deenuji_4-1707940333225.png

     

    For guidance on extracting data from a web page, please see the following Microsoft link: 
    https://learn.microsoft.com/en-us/power-automate/desktop-flows/automation-web#web-data-extraction

    Thanks,

    Deeenu

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete