@PowerAddict
I disagree with @v-xida-msft that you cannot accomplish this with PowerApps or Automate. In general there are 2 ways to consume data from a website: by using an API or by web scraping.
APIs are preferable because you can build a custom connector to access the data in PowerApps and Flow. My preferred sports API is https://www.mysportsfeeds.com/. They offer a free tier for non-commercial usage. Here's what you can do with the free tier.
Non-Commercial
This includes developers, students, bloggers and researchers. For new subscribers, you'll automatically be assigned as a COMMERCIAL user unless you Contact Us to request NON-COMMERCIAL access. Let us know how you consider it to be non-commercial, and how our API will be used.
If we agree to assign you NON-COMMERCIAL status, by default you'll have free limited postgame access. What that means:
access to ALL available data feeds for all leagues.
postgame access to the current season of each league.
access to v1.x feeds only.
access to only the most recent completed regular season for each league.
limited to 100 requests/day, and 1,500 requests/month.
The other method called web scraping is not a preferred technique for PowerApps. Web scraping involves writing a program (in another language of your choosing) to parse the HTML of a website which extracts the desired data. I have written Python scripts to get sports data in the past but found it unreliable because when a new webpage is published might contain new HTML which breaks my script. Therefore, I only use this method when an API is not available.
If you manage to create a fantasy sports app be sure to share a demo on the forum or community blog. I would love to see the results of your work.
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
