Data Import & Export

Retrieve an Excel Row or Cell Value in Power Automate

John WilsonJohn Wilson Nov 14, 2026 868 views

Question details

Retrieve a matching price from an Excel table after a user submits a form.

Product
Microsoft Power Automate, Excel Online (Business), and Microsoft Forms
Device & OS
not provided
Scenario
A form response identifies a product, and a flow needs to look up its price in an Excel workbook and include it in an email.
Observed behavior
The flow should find the matching table row and pass its price column to the email action.
Before you start

Store the workbook in OneDrive for Business or SharePoint, and format the pricing data as an Excel table with headers such as ProductCode and Price. Make sure the form supplies a product code that matches a value in the table.

Solution 1Recommended

Filter the Excel table and use the matching price

Use this method when a form response contains a key that identifies the pricing row.

The Excel Online connector does not provide an action to retrieve an arbitrary cell directly. Instead, find a row in a table and reference the column you need.

1
Create the form trigger

In Power Automate, create an automated cloud flow and select Microsoft Forms: When a new response is submitted. Choose the form under Form Id.

2
Get the submitted answer

Add Microsoft Forms: Get response details. Select the same Form Id and insert Response Id from the trigger.

3
Find the matching row

Add Excel Online (Business): List rows present in a table. Select the workbook location, document library, file, and table. In Filter Query, enter ProductCode eq 'ABC123' to test a text code, then replace ABC123 with the product-code answer from Get response details while keeping the single quotes.

4
Check for a result

Add a Condition after the Excel action. Use the expression length(body('List_rows_present_in_a_table')?['value']) and check whether it is greater than 0. In the no-match branch, add an action to report that the product was not found.

5
Insert the price in an email

In the matching branch, add an email action such as Send an email (V2). In the message body, use the Expression tab to insert first(body('List_rows_present_in_a_table')?['value'])?['Price']. Adjust the action reference if your Excel action has a different internal name.

Filter the Excel table and use the matching price
Use a unique lookup key: The expression returns the price from the first matching row. Use unique product codes if the flow must select exactly one record, and test filter values that contain apostrophes because they require escaping.
Free Microsoft Office alternative

Manage Excel pricing tables with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for editing pricing workbooks and compatible Microsoft Office files. It can help you move between office suites, although it does not fix or replace the Power Automate Excel connector.

Edit pricing rows and columns in WPS Spreadsheets.Open and save Microsoft Excel XLSX files for compatibility.Work in a familiar spreadsheet interface that makes migration easier.Use a free, lightweight office suite for everyday document tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Can Power Automate read a cell such as B2 directly?

The Excel Online connector does not provide a direct action for an arbitrary cell. Put the data in an Excel table, use List rows present in a table to find the record, and reference the desired column.

Why can't I select my Excel table in the flow?

Open the workbook in Excel, select the data range, and use Insert > Table with a header row. Save it in OneDrive for Business or SharePoint, then select the file again in List rows present in a table.

What happens if no product code matches?

List rows present in a table returns an empty value array. Add a Condition that checks whether its length is greater than 0 before using first() to read the Price column.

What if several rows have the same product code?

The first() expression uses the first returned row. Give each product a unique lookup code, or process the returned rows individually if multiple matches are expected.