web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extract tabular data f...
Power Automate
Answered

Extract tabular data from website with UI Flow

(0) ShareShare
ReportReport
Posted on by 8

Hello,


I'm new on this tool, and I'm wondering, is it there a way to extract tabular data from the web with selenium ide and UI Flow?. I know that there are some examples which collect data from the internet and store in a JSON file. However, because I'm collecting data from people's responses, I got some JSON format errors that stop the flow. Especially when people use spaces and some special characters. There any way to extract data without using Json or skip this JSON format errors and add the extracted data into a row in an excel sheet?.

 

Thanks in advance for your help.

Categories:
I have the same question (0)
  • ChristianAbata Profile Picture
    8,951 Most Valuable Professional on at

    hi @efleitasalva  I'm shure this video could help you

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

  • Verified answer
    v-litu-msft Profile Picture
    on at

    Hi @efleitasalva,

     

    You can use the storeText command for this purpose. The syntax is as follows:

    command: storeText
    Target: locator
    value: variable_name
    

    Extract tabular data could use Xpath as the locator. In the above command, variable_name refers to the variable that will store the text which is fetched using the command.

    To select a single row of the table, you need to know how to write Xpath for the required row.

     

    However, this part "specially when people use spaces and some special characters. There any way to extract data without using Json or skip this JSON format errors and add the extracted data into a row in an excel sheet", I am afraid it is impossible, cause some special characters will invalid when writing them into Excel via Flow.

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard