Help to Extract data from web

(0) Share

Report

Posted on by Lars5

I have this simple flow

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

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Deenuji_Loganathan_ 6,250 Moderator on at

Like (1)

Report
Copy link

Link copied!

@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.

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

Was this reply helpful? Yes No
Lars5 38 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (1)

Report
Copy link

Link copied!

@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.

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

Was this reply helpful? Yes No
Lars5 38 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Lars5 38 on at

Like (1)

Report
Copy link

Link copied!

Hi Deenu

I find a solution

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (1)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No