Others

How to Add an Excel Score to Microsoft Forms Emails with Power Automate

Algirdas Jasaitis Sep 27, 2026 868 views

Question details

The user wants to automate sending an email that contains a specific score retrieved from an Excel workbook whenever a Microsoft Forms response is submitted.

How to Add an Excel Score to Forms Emails With Power Automate

Product: Microsoft Power Automate, Excel, Forms
Device & OS: not provided
Scenario: Automating email workflows based on form submissions and matching data in a spreadsheet.
Observed behavior: The automation flow needs to accurately match the submitted form response to the correct Excel table row in order to retrieve and send the corresponding score.

Before you start

Ensure your Excel workbook is saved in a cloud location like OneDrive or SharePoint, and that the data is formatted as a Table (Insert > Table) with a unique identifier column to match the form responses.

Solution 1Recommended

Create a Power Automate Flow to Retrieve and Email Excel Scores

Set up a flow that triggers upon form submission, finds the corresponding Excel row using a unique identifier, and sends an automated email containing the score.

To make this flow work smoothly, your Microsoft Form needs to capture a unique piece of information (such as an email address or a custom Response ID) that identically matches a column in your Excel table.

Trigger the flow

Log in to Power Automate and select 'Create' to start an automated cloud flow. Choose 'When a new response is submitted' under Microsoft Forms as your trigger.

Get response details

Add a new step and select the 'Get response details' action for Microsoft Forms. Choose your specific form from the dropdown and insert the 'Response ID' from the dynamic content list.

Retrieve the Excel row

Add the 'Get a row' action under Excel Online (Business). Select the cloud location, document library, file, and table containing your scores. In the Key Column field, select the unique identifier column from Excel, and in the Key Value field, map it to the corresponding dynamic content from the Form response.

Send the email

Add the 'Send an email (V2)' action from Office 365 Outlook. Insert the respondent's email address in the 'To' field, write your message body, and insert the 'Score' dynamic content retrieved from the Excel step.

Create a Power Automate Flow to Retrieve and Email Excel Scores

Advanced Matching: If you are matching multiple criteria or need complex OData filter queries, check the Microsoft Power Platform Community for advanced troubleshooting.

Free Microsoft Office alternative

Looking for a Free, Lightweight Office Suite?

While Power Automate workflows are tied to the Microsoft ecosystem, WPS Office provides a free, lightweight, and highly compatible alternative for all your everyday document, spreadsheet, and data collection needs. Enjoy a familiar interface and seamless migration without the hefty subscription fees.

1. Download and install: Get WPS Office Free from the official website and install it on your device in minutes.
2. Create your data collection forms: Open WPS Office and click on 'Forms' from the dashboard to easily create surveys and data collection templates.
3. Manage data in Spreadsheets: Export your collected form data directly into a fully compatible WPS Spreadsheet for easy score calculation and data management.

100% compatible with Microsoft Excel (.xlsx) and other Office formats.Built-in smart data collection tools via WPS Form.Lightweight installation with blazing fast performance.Familiar, tabbed user interface making transition effortless.

microsoft office alternative - wps office

Frequently Asked Questions

Why is Power Automate not finding my Excel table?

Power Automate requires the data inside your Excel workbook to be formatted specifically as a Table (using Insert > Table). It must also be saved in a cloud location like OneDrive or SharePoint, not on your local hard drive.

Can I use an email address to match the form response to the Excel row?

Yes. If your Microsoft Form collects email addresses and your Excel table has a corresponding email column, you can use it as the unique Key Column in the 'Get a row' action to match the records.

How do I format the email sent by Power Automate?

In the 'Send an email (V2)' action, you can use the rich text editor to format your text, insert hyperlinks, and seamlessly mix static text with dynamic content like the retrieved Excel score.

Office Quick Solutions