📅 Date: 25th March 2025
📍 Location: SWG3 Glasgow (100 Eastvale Pl, Stobcross Rd, Glasgow City)
🕕 Time: 6:00 PM to 9:00 PM GMT

Session Overview

At the Scottish Power Platform User Group, I delivered a session titled:

✨ “Enabling low-code developers to create custom client reports with a helping hand from Azure”

In this session, I explored:

• Using Power Automate to generate custom reports securely.
• How to leverage an Azure Function as a reverse proxy to enhance security and scalability.
• An architectural pattern that integrates Dataverse, Power Automate, SharePoint, and Azure Functions to deliver dynamic, client-ready PDFs via secure links.

Presentation Slides

You can view my full presentation here:

➡️ View the Presentation Slides

GitHub Repository

The demo and solution shared in this session are available on GitHub:

➡️ AzureFunction-PowerAutomateProxy Repository

This repository includes:

• An Azure Function HTTP Proxy that authenticates requests and forwards them to your Power Automate Flow.
• Full support for GET, POST, and OPTIONS methods.
• Configurable environment variables to avoid hardcoded URLs or keys.
• Deploy-to-Azure templates for quick deployment into your own environment.

Key Features of the Solution

✅ Forwards all headers from the incoming request.
✅ Adds a custom Flow-Key header (from environment variables).
✅ Appends query parameters to the external URL dynamically.
✅ Provides a robust pattern for securely exposing Power Automate flows as web endpoints.

Try It Out

If you’re interested in setting up this pattern for your own client reporting requirements, follow these steps:

1. Access the GitHub repo.
2. Deploy using the Deploy to Azure button provided in the README.
3. Import the Power Platform solutions to your environment.
4. Configure your environment variables with your Logic App or Flow URL and secret key.
5. Test your new secure reverse proxy-enabled flow!

Why This Matters

Many organisations need to provide custom PDF or HTML reports to clients securely without exposing their backend systems. Combining Power Automate for report generation with Azure Functions for authentication and reverse proxying provides a scalable, secure, and low-code approach to achieve this.

Event Registration Link

Here is the event registration link:

➡️ Event Registration – Scottish Power Platform User Group

This event was proudly presented by the Scottish Power Platform User Group featuring sessions from community superstars Ian Tweedie and Duncan Boyne.