I have a situation where I want an items of lets say List A to get copied to another List and that would be List B when any of the List A's item field were modified. in addition if the same item were modified again, I want the same entry on List B gets updated with the whatever modification was made on the same item. So in a sense is like Copy an item when its modified from list A to List B and update List B if an existing item was modified
Thank you
Solved! Go to Solution.
Hi @MTG ,
Do you mean to synchronize the items in the two lists?
The item in list A is created/deleted/modified, and the corresponding item in List B is also created/deleted/modified.
If this is the case, we need to set a reference field to identify the corresponding items. I suggest adding an ItemID(Number type) field in list B to record the ID of the item in List A.
Please refer to the screenshot below to configure Flow:
Note: The Dynamic content in Create item is all from When an item is created or modified.
The ID configured in Update item is from Get items, the ItemID field is not need to configured, and the rest of the field configuration Dynamic content is all from When an item is created or modified.
Hope it helps.
Best Regards,
This is a relativly simple Flow to design. Basically, When an item is created or modified in SharePoint List A, Update item or Create item depending on if the Name of List A is equal to the Name of List B.
How you best compare the values in the condition depends on the data within your two lists. I've used Name only as an example here. The Use expressions in conditions to check multiple values documentation, and the A Visual Explanation of Flow Logical Expressions blog post should hel you accompish this.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @MTG ,
Do you mean to synchronize the items in the two lists?
The item in list A is created/deleted/modified, and the corresponding item in List B is also created/deleted/modified.
If this is the case, we need to set a reference field to identify the corresponding items. I suggest adding an ItemID(Number type) field in list B to record the ID of the item in List A.
Please refer to the screenshot below to configure Flow:
Note: The Dynamic content in Create item is all from When an item is created or modified.
The ID configured in Update item is from Get items, the ItemID field is not need to configured, and the rest of the field configuration Dynamic content is all from When an item is created or modified.
Hope it helps.
Best Regards,
I'm really sorry for the late reply. I was away from the office. I know its simple and logicaly easy to build but the condition never turned true it always says false and creates another entry. Maybe this is relevant the List A is calendar list and list B is a custom list both have same fields, yet I cant get any List A's entry get updated in List B if it exists.
All I want is List B gets updated if an entry exists in both lists. I can't get it updated it always creates another entry.
Hi @MTG ,
Could you share the full screenshots of the Flow configuration?
Best Regards,
Here is below the screenshots of the flow
On condition Dynamic content title both are when an item is created or modified. On Update Item field Id is from get an item. Other fields are all when item is created or modified.
Thank you in advance.
The expression you provided was the last bit that I need for the flow to work. I've tried @Brad_Groux suggestion with a condition and fields that both Lists have in common such in my case Title but it fails becuase If I set get items to grab Meetings list, the condition will always return false and If I set get items to grab AllEvents list the condition will always returns true. @v-bacao-msft your solution works for me if I need to copy/create an existing entry in List A to List B and If entry is exist in List A and B and I have modified the same entry in List A the entry will get updated in List B
Thank you @v-bacao-msft
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
84 | |
60 | |
54 | |
44 | |
40 |
User | Count |
---|---|
85 | |
81 | |
76 | |
62 | |
42 |