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.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

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 ?

Was this reply helpful? Yes No
kodnil2020 26 on at

Like (0)

Report

Hi @Mira_Ghaly

1. How to match product name from 2 lists?
2. What to mention in ID field to update the exact match?

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@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

Was this reply helpful? Yes No
kodnil2020 26 on at

Like (0)

Report

Can you please share some sample for filter query?

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@kodnil2020
Filter Query on Get Items as below:

Was this reply helpful? Yes No
kodnil2020 26 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No