Retrieve an Excel Row or Cell Value in Power Automate
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.
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.
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.
In Power Automate, create an automated cloud flow and select Microsoft Forms: When a new response is submitted. Choose the form under Form Id.
Add Microsoft Forms: Get response details. Select the same Form Id and insert Response Id from the trigger.
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.
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.
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.

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.

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.




