How to update lookup field dynamically based on the Title value(Sharepoint lists)

(0) Share

Report

Posted on by heismodest

Hello Experts...

I have two lists and want to join with each other.

I have searched a lot of articles and youtube clips but, because of lack of knowledge on the power automate and language barrier, I'm having trouble implementing the solution.

May I ask you to review following issues and to provide any advice?

Case 1. If TitleA of ListA is modified or created
lookupB field of ListA to be update TitleB of ListB which has a same value as TitleA(e.g. 1001 = 1001)

Case 2. If TitleB of ListB is modified or created in
lookupB field of ListA to be update TitleB of ListB which has a same value as TitleA(e.g. 1001 = 1001)(same manner as above)

--------------------------------------------------------------------<@

For the Case 1, I made a Power Automate as follows but, it did not update lookupB field of ListA with TitleB which has same value as TitleA.

results:

I appreciate for your kind advise in advance...

Thank you and regards,

Jeong-Min.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-chengfen-msft on at

Like (1)

Report
Copy link

Link copied!

Hi @heismodest ,
Thank you for the detailed screenshots.
It is recommended to use 【When an item is created】,
If [When an item is created or modified] is used, [Update item] in the flow will also cause the Flow to be triggered. This will get stuck in an infinite trigger loop
Here is test for your reference:
Here is list A

Here is list B

Here is flow :
Please try to filter with Filter Query
Compare the Title of List B with the Title of List A through filter query,
and filter out if the conditions are met.
Use [Apply to each] to update the value of list B in list A with the filtered results

Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
heismodest 8 on at

Like (0)

Report
Copy link

Link copied!

Dear Cheng,

I really appreciate for your kind reply~!
How I couldn't know that using update trigger will cause infinite iterations?
Your explanation and detailed screen shots are very helpful for me.
I hope you to have a great weekend~!

Thanks and Regards,
Jeong-Min.

Was this reply helpful? Yes No