Update List1 based on on combination of values in List2

(0) Share

Report

Posted on by mdrabek

Hello,

I have 2 lists - List1 and List2.

In List1 I have columns - "Picklist" and "Delivery time"

In List2 I have columns "Picklist" and "Status". In List2, there are several records for the same Picklist with different Status, for example:

Picklist Status Date

X2101 10 13.1.2023 1:43

X2101 20 13.1.2023 1:58

X2101 40 13.1.2023 3:01

etc...

What I need to achieve: If in List2 Status = 40, get the date and time of creation of that item, search the Picklist in List1 and write the date and time to column "Delivery Time".

So if we will use the example above: If there exists record with Picklist = X2101 and Status = 40 in List2, search Picklist X2101 in List1 and write information "13.1.2023 3:01" into column "Delivery time"

Is this achievable in some easy way?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-chengfen-msft on at

Like (0)

Report

Hi @mdrabek ,
I made a template for your reference
Here is list 1
Here is list2
Here is flow:
Fired when a record is created
Determine whether the status column of the record is 40
Use the filter query to compare whether the Picklists of list2 and list1 are consistent, and filter out the items of list1 that meet the conditions.

Determine whether the filtering result is greater than 1
If yes, update the Delivery time of the item
Here is result:
add a record,status =40

Best Regards
Cheng Feng

Was this reply helpful? Yes No
mdrabek 4 on at

Like (0)

Report

Thanks a lot - that is what I was looking for!

Was this reply helpful? Yes No