Simple Power Automate with Stocks API

To we are going to set up an HTTP request to fetch real-time stock data (on a Sunday and then populate some fake data), and dynamically process stock tickers like MSFT, AAPL, GOOGL, and AMZN. Key Topics Covered: • Setting up a scheduled flow in Power Automate • Configuring HTTP requests with Finnhub API • Dynamically looping through stock tickers • Writing results to Excel 💡 Tools Used: Power Automate M365 (one premium connector) Finnhub API (Free plan available) 📈 Automate your stock updates today and streamline your workflows with this powerful integration! Don't forget to like, comment, and subscribe for more Power Automate tips and tutorials. 👍 Chapters: 0:00 Introduction 2:15 Create Free API Key 3:00 Set up Excel 7:06 Call the API 5:00 Set up Recurrence 11:30 Using Compose on Outputs 15:45 Using Example Data in Excel