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 / Power automate - extra...
Power Automate
Unanswered

Power automate - extract data from a website and post a teams message

(0) ShareShare
ReportReport
Posted on by

Hello,

 

Can power automate, preferably the app built into teams, extract data from a website, and if a value exceeds 60, then make a group post in a specific chat? I have only played around with power automation and understand the concept. This is going to solve a business problem at work. We all have to sign into a website and watch for if a specific value is greater than 60. However, having everyone watch a board seems a little redundant. I want this task to be automated and a team message posted automatically if the value exceeds 60. Therefore, no one has to waste time looking up the website.

 

There are only two ways I can think about going this situation.

 

Microsoft teams: (power automate app)

1. If possible, within Microsoft teams, extract data from a website (after automatically signing in)

2. Post a Microsoft teams message if that data exceeds 60.

 

Power automate app on a separate machine:

1. Launch the website

2. if data is greater than 60, extract data

3. hover the mouse over the teams

4. Click to start a new conversation.

5. Paste data in the team chat

 

 

 

Update: I did some testing, and I think I found exactly what I was looking for. However, I could use some help with the code. In this example, I took the website coindesk.com/price/bitcoin and tried extracting the bitcoin value. If that value is above 60, it should post a team chat.

However, I must be doing something wrong because it still fails.

 

1.png2.png3.png

Categories:
I have the same question (0)
  • v-liwei-msft Profile Picture
    Microsoft Employee on at

    Hi @Bryan2000 

     

    Could you please tell me:

    Does your flow report this error?

    vliweimsft_0-1679278648262.png

    I think you can use dynamic content directly returned by Parse Json.


    If you want to use an expression, write the formula into the expression box instead of the text box.

    vliweimsft_2-1679279066222.png

     

     

    Best Regards,

    Levi

     

  • Chriddle Profile Picture
    8,685 Super User 2026 Season 1 on at

    I'm wondering where you got the schema in the Parse JSON from - the body of this page is HTML.

     

    If you want to grab information from a page in a webflow, first check if there's a better source for the information you want.

    E.g. www.coindesk.com uses an API that returns JSON:

    https://www.coindesk.com/pf/api/v3/content/fetch/chart-api?query={%22end_date%22:%222023-03-20T10:52%22,%22iso%22:%22BTC%22,%22ohlc%22:false,%22start_date%22:%222023-03-20T10:51%22}&d=259&_website=coindesk

     

    If there is no other way, you can check if the HTML can be converted into XML and use xpath.

    I hardly see any sites where this is easy to do.

     

    The next way is to get the information you want by searching the HTML with string functions.

    But whether that works depends on how the HTML of the page is constructed and is often unreliable and messy.

     

    However, parsing a web page is much easier in PA Desktop.

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 573

#2
Valantis Profile Picture

Valantis 407

#3
11manish Profile Picture

11manish 387

Last 30 days Overall leaderboard