News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows How to get data using ...

Power Automate - Building Flows

Answered

How to get data using a filter query from a another list.

(0) Share

Report

Report

Posted on by golfnutt8

55

I have a Products list that holds information about a certain product like "ProductName", "ProductDetail", "ProductCost"
I have another list called Orders and when I enter an item I want a power automate workflow to use get data from the Products list where the "ProductName" field equals the lookup field used in the Orders list.
I have tried a number of ways but without success.
I wouldn't be messing around with this if I could do a calculated column using a number or currency data type field.

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

PrasadAthalye on at

Like (1)

Report

Re: How to get data using a filter query from a another list.

@golfnutt8 - You would run a workflow on Orders and when new item is created trigger. Then in the GetItem action mention Filter query 'ID eq <Select ID field from lookup>'. This should get the item from Products list for you. See sample below... NomineeName is a lookup field from another list...

Like and Mark this as answer if it resolves your issue.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans