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

[golfnutt8]

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.

[PrasadAthalye · Accepted solution]

@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.