Skip to main content

Notifications

Power Automate - Power Automate Desktop
Unanswered

Help to Extract data from web

(0) ShareShare
ReportReport
Posted on 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
    Deenuji_Loganathan_ 6,087 on at
    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
    Lars5 38 on at
    Re: Help to Extract data from web

    Hi Deenu

     

    I find a solution

    Lars5_0-1708005228481.png

     

  • Lars5 Profile Picture
    Lars5 38 on at
    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
    Deenuji_Loganathan_ 6,087 on at
    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
    Lars5 38 on at
    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
    Deenuji_Loganathan_ 6,087 on at
    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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard