0

I am pretty new to SharePoint, Is there a way to sync or connect two lists that resided in different SharePoint Online sites?

0

You can sync two lists from different sites through Microsoft Flow.

Please following steps:

1.Create new list named "Sync1" in the SharePoint site

2.Create new list named "Sync2" in other SharePoint site and create same columns as the "Sync1" list

enter image description here

3.Create a Microsoft Flow

enter image description here

4.Save and Test this flow

======================== Update Answer ===========================

My design philosophy:

First, automatically trigger the Flow every 5 minutes

Then, get all items in the sync1 list(Get items) and get all items in the sync2 list(Get items 2).

Then, traverse to delete all items in the sync2 list, and re-create the same items in the sync1 list in the sync2 list

Finally, run the Flow again in 5 minutes.

========================= Updated Answer 2 ==========================

Please use the below flow:

enter image description here

Sync1 & Sync2:

enter image description here

When I delete an item in the Sync1 list, the corresponding item in the Sync2 list is also deleted.

For example, delete item: Test222.

enter image description here

12
  • Thanks for the solution. Please allow me to test further on the understanding. Whatif someone edited Sync2 list? Or, can I set Sync2 list as Read only?
    – James
    Jul 13 at 11:46
  • Also, while I am testing on the solution, for Apply to Each 2, are the " choice value" and "content" refer to Sync2 as well?
    – James
    Jul 14 at 9:15
  • Hi James. For "Apply to each 2", the "Title", "Choice value" and "Content" come from Sync1(Get item). Jul 14 at 10:56
  • It works!!! One last question, what is the principle of the steps? Especially Apply to each and Apply to each 2 in this instance?
    – James
    Jul 14 at 12:04
  • Hi James. I have updated answer under initial My Answer. Hope this can help you to solve issue. Have a nice day! Jul 15 at 3:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.