Others

How to Display Microsoft Forms Responses Using QR Codes and Power Automate

Phi Hung Vo Oct 12, 2026 868 views

Question details

Retrieve and display the latest Microsoft Forms audit submission for a specific entity by scanning a unique QR code.

How to Display Microsoft Forms Responses by QR Code Using Power Automate

Product: Microsoft Forms and Power Automate
Device & OS: not provided
Scenario: A user needs to automate audit responses so that scanning an item's (like a truck) QR code retrieves and displays its latest submitted form data from a database.
Observed behavior: The workflow requires querying a data source to filter the latest response. In Power Automate, the dynamic content for body.value is missing in the Compose action and requires manual entry.

Before you start

Ensure you have active access to Microsoft Forms, Power Automate, and a SharePoint site to create the necessary lists and workflow connections.

Solution 1Recommended

Set Up Power Automate with SharePoint to Filter and Display Responses

Use a SharePoint list to capture Microsoft Forms responses, then utilize an HTTP request in Power Automate to filter and retrieve the latest submission linked to your QR code.

To properly filter and display form submissions on demand, you need a structured data source like SharePoint. Power Automate acts as the bridge that queries this data when triggered by a user visiting the QR code link.

Store Responses in SharePoint

Create a SharePoint list to act as the database for your Microsoft Forms submissions. Ensure it contains a specific column for the identifier (e.g., Truck ID).

Configure the Power Automate Flow

Create a flow that uses an action to send an HTTP request to SharePoint. Configure the request to query the list and filter records strictly by the specific truck identifier to find the latest submission.

Manually Enter the Compose Expression

Add a 'Compose' action to process the data. If 'body.value' does not appear in your dynamic content list, switch to the Expression tab and manually type: outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['value']

Generate and Link Unique QR Codes

Create a web-accessible page or application link that can accept the truck identifier as a parameter. Generate a unique QR code for each truck that points to this URL so scanning it triggers the flow to fetch the results.

Set Up Power Automate with SharePoint to Filter and Display Responses

Expression Auto-Conversion: In certain Power Automate environments, after you manually enter the expression into the Compose action, the system may automatically convert its display to read as 'body.value'.

Free Microsoft Office alternative

Manage Audit Data and Spreadsheets Easily with WPS Office

While Microsoft Power Automate is necessary for setting up complex automated workflows and HTTP requests, analyzing your exported audit records and handling everyday documentation is effortless with WPS Office. WPS Office provides a free, highly compatible, and lightweight environment for all your spreadsheet and data processing needs.

1. Download and Install WPS Office: Visit the official WPS website to download the free suite and install it on your PC or mobile device.
2. Open Exported Form Data: Export your raw Microsoft Forms data to an Excel file and open it directly in WPS Spreadsheet without losing formatting.
3. Analyze and Report: Use WPS Spreadsheet's comprehensive formulas and charting tools to summarize your audit data locally.

Fully compatible with Microsoft Excel (.xlsx), Word, and PowerPoint formatsFree and lightweight alternative to Microsoft Office suitesFamiliar user interface allowing for seamless workflow migrationBuilt-in spreadsheet features, including pivot tables and batch data processing

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I select `body.value` from the dynamic content in my Compose action?

Because the data comes from an API call output, Power Automate might not automatically parse and expose the underlying properties in the dynamic content menu. You must manually type the expression `outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['value']` in the Expression field.

Can I use an Excel spreadsheet instead of a SharePoint list to store the Microsoft Forms responses?

Yes, you can save form responses to an Excel file hosted on OneDrive or SharePoint. However, a SharePoint list is generally recommended and more robust when using Power Automate to make complex HTTP requests and filter records by specific identifiers.

How do I make the Power Automate retrieved result web-accessible via a QR code?

You need a front-end interface, such as a Power App or a custom web page, designed to display the data. You then generate a QR code containing a URL with a query string for the specific identifier (like a Truck ID). Scanning the code opens the page, automatically passing the identifier to trigger the data retrieval flow.

Office Quick Solutions