Update List using lookup field

(0) Share

Report

Posted on by kodnil2020

Hello,

Need help on creating scheduled flow:

Products List

Product Code

Product Name

Product Expiry

Orders List

Product Name(Lookup)

Product Code

Order Date

Quantity

Each Product Name has unique Product code.

I need to update Product Code in Orders list at regular intervals. I tried to get help from this post but no luck so far. This is what i have tried so far and I am stuck at highlighted step below:

Define Interval
Get Items - Products List
Apply to each
Condition - To match item that needs to be updated
Update Item if condition matches

Thanks in advance.

All responses (7)

Answers (0)

Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: Update List using lookup field

@kodnil2020
on the Filter Query Left side add the Column name in the orders table
Product_x0020_Name eq 'add the value from the Dynamics Content'
kodnil2020 26 on at

Like (0)

Report

Re: Update List using lookup field

@Mira_Ghaly ,
I am getting below error on filter query:
message": "The expression \"Product1 eq items('Apply_to_each')?['Product_Name']?['Value']\" is not valid.

Below is the screen shot of the flow:
Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: Update List using lookup field

@kodnil2020
Filter Query on Get Items as below:
kodnil2020 26 on at

Like (0)

Report

Re: Update List using lookup field

Can you please share some sample for filter query?
Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: Update List using lookup field

@kodnil2020
After retrieving your product list and in the first loop, make another Get Items action on the orders and add Filter Query: order product name column eq product name from the first loop this way you get all orders related to products.
Then 2nd loop to update the product code to the product code from your product list first loop.

If this helps you please mark as an accepted solution
kodnil2020 26 on at

Like (0)

Report

Re: Update List using lookup field

Hi @Mira_Ghaly

1. How to match product name from 2 lists?
2. What to mention in ID field to update the exact match?
Mira Ghaly 11,409 Super User 2025 Season 1 on at

Like (0)

Report

Re: Update List using lookup field

Hi @kodnil2020
So the step that you can't achieve is to update the product Code in the Order Record?
Can you paste a screenshot of this step please ?