You can update the guide because Microsoft has changed so much that I am currently unable to go through this process. e.g. length (Outputs('Get_items')?['body/value']) - is not a valid command and cannot be validated

Wow Great!. I wonder if you have a tutorial that for deletion on an item from the Master List and also will sync to the Second List if there's any deleted item from Master List.

How all tutorials should be done. A very clear tutorial. Thank you!

This is a great lesson. I learned a lot from this. Thank you for explaining all the fundamentals while you go along.

I've had problems with syncing two lists in sharepoint for about 2 months now and not a single video or written explanation have helped me. YOUR VIDEO solved all my problems and I have now synced my 10 lists to a main databaselist! :D :D So thank you so so much for this logical explanation och great video!!

thank you so very much. This is exactly what i have been searching for in order to complete a work task.

This is a very useful sharing and it support my use case. Thank you so much.

Thanks, Enea! Made my life so much easier! Very helpful!!:) My only tip is please add a caption to enlarge the text for the expressions.

This VDO is really good. Thank you Enea to share this knowledge. Cheer!!!

Why can't I get this to work - I've followed it to the letter. I am getting "apply to each" for yes and no - which I notice didn't happen with your demo.

Thank you so much, Enea! This was exactly what I needed! Genius.

Praful Gayakwad:- Hello, Enea Thank you for the tutorial; it clarified my doubts and errors. Thanks a lot. Can you guide me on preventing duplicate data retrieval from two lists? The first list contains certain columns, and I want to compare data based on columns like name and email in the second list to avoid duplicates.

What about autosyncing different libraries (one-way) each in a seperate sharepoint site ?

Perfect timing. I trying to do exactly this. Thank you.

Great video, thanks. Why do you leave Car Model with a space in the column title but BuiltYear you don't?

Is there any way to synch a SharePoint 2016 OnPrem list with a SPO list in the same way as above ?

What it is want to change something in secondary list and sync changes in master list and lets say i have multiple secondary list and one master list and which has all the data of all the other list and which ever secondary list i modify will synch changes in master list or the other way around?

you are the best.. thank you so much Teacher.

Perfect! Thank you! Is it possible just add and update item (sync) list 1 and list 2 (as your video) without delete the item in the list 2 when I delete item in the list 2, but has one specific color or another information in the list informing that the specific item in this list was deleted? My question is that I need to mantain the database (list 1) cleared and the second list (database) full to use in complete KPI.

Thank you for the amazing video. I have a Lookup column in my master list that allows multiple selections. However, when I use your flow, I notice that duplicate items are created in my second list when two or more selections have been made on the lookup column. For instance, if I make two selections in the lookup column, I get two list items in my second list. Similarly, making three selections results in three items in the second list. Do you have a work around for this?

Will this method work if I am trying to have mutiple lists feeding updates into a single main list?

Great video with very clear instructions. Thanks.

I have a specific problem. I have on one Sharepoint site, a list of employees that received warnings, a list of employees that are on performance improvement plans and a list of employees that do not meet productivity metrics. I want to create a master list of all employees on the same site where I populate all the employee names, and then a flow will look through the other 3 lists and populate whether the employee has either received a warning yes/no, is on a improvement plan yes/no and has met productivity yes/no. Is there a way to do this? We would usually do INDEXMATCH and VLOOKUP on Excel but now everything is on Sharepoint lists

I had been trying to do this for weeks! Thanks for sharing :-)

Fantastic video, so helpful! Thank you for sharing it. I'm getting an error while trying to copy what you've built here, under Update item when I try to use your outputs expression for the ID I get an error stating "Correct to include a valid reference to 'Get_items' for the input parameter(s) of action 'Update_item'. Here is the text I entered for my expression: outputs('Get_items')?['body/value'][0]['ID'] Any idea what I'm doing wrong?

Nice video! If it's a relational table, How do you handle it? Let's say 2 SharePoint lists, one with ID (Master) and the other with Uid(Slave).

Hello Enea, my flow says it's successful, but the my second list is not updating to match the master.

Hi Enea, So I am a little confused for my use case, I have a Master List which tracks the application of a possibe new employee It has a calculated column which generates A unique Application ID for each application. Now For Different Level of Interviews I have created A Form (Evaluation form to be filled by interviewer, different for Each Level), responses of which are saved in a secondary SP Lists. In those Form I have a field for Application ID, so when there is a new response, the secodary list creates a new item with one of the fields being application ID. Now I want to copy items from my secondary List to Primary Master List with the Responses submitted by a Interviewer with common part being that Unique Application ID. So whenever i try to create an update item, it has two required fields one is ID and second one is Title. Now ID as per your video should be filtered by ODATA Query, but i don't want to update Title in my Master list as it already is updated with candidate name and I just want my flow to look for Unique application ID and copy the response received in my Master List columns. Can You help me out as what should be the course of action.

It is possible to have one master list and second list which have just some items/lines from master list ? I want to have master list with issues which come from inside and outside company and second list for example with only items from outside (would have column in Master list which say for example External or Internal and all what is External should go to second list)

Hey, great video but I have a question Why it is not working with Pictures? Is picture an attachment?

I have created 2 list in sharepoint online have same data but one to be have 5 columns and other have 3 columns here I want to sync both list data on edit add so can I use this mothod by hiding 2 extra columns in second list ?

Hi, thanks Enea ! it is possible to add picture in one list to another, with synchronization ?

Hi, I'm actually wondering how did you increment the number in ID column?

My second list is a repeating table. How do I sync one Master Record with all the ones in the second list. This only brings in the 1st one.

Thanks for the video. Can the sync also be done by creating 3 flows that will be triggered when an item is created, modified, and delete?

Thanks Enea for this video. It helped greatly, one question...what if I want two lists to sync into one master. I tried to make an identical flow for the second list however it grabs the ID of number ''1'' in the master from list 1? Do I have to set the condition to a number other than 0?

Great work, but I see a critical point: the author in the second list would be always the owner of the automation. What if I need to sync the author and also the creation date of the MasterList?

Great video mate!

Great video with clear explanation. What about if the 2nd List has only some of the columns of the 1st List has? Fow example my master list has 10 columns while the slave list has only 5 of them identically? The JSON sends all the output from master list when a new item is created or an existing is updated. Is this going to create an issue on the flow? Thanks.

Hello super good video. Helped me a lot. Thanks a lot for this. I am at a loss :( I want to update A SharePoint List as master data from Forms into other SharePoint List as latest responses. So far I have managed to do that. But in the updated list I can't open the attachment. In the Master Data List the Attachment field is read-only, maybe this has something to do with it? My problem is, I can't transport the attachments from the master data list to the other list. In the field "Attachment" is only true but the attachment can not be opened. What do I have to do?

I had a problem with the condition. If i edit a row in the MasterList, the lenght is always 0 (or empty, as an html table shows). I noticed that in the MasterList the ID is written with 12345, in the SecondList the SincID is written as 12.345. Could this be the problem?

Hi, great video. But i am having issues on video section 11:55 When I put in ID eq SyncedID in the get items section it comes back as 'colour 'SyncedID' does not exist. It does as I have setup as per video tutorial and I am sure the name is correct. ID is shown on master aswell.?? Can you help please??

Can we use the sync data for calculation?

👍, so how copy attachments?

This is a really good video !!!!!!!!!!!! This video helped me a lot I have one question for you. Synchronization when deleting data from the original list Can I automatically delete data from the list?

Many thanks for that !

Is it possible to share an Image column with this flow?

Hallo Ilias, ist es auch möglich, dass du ein Video machst z.B. das die erfassten Daten wöchentlich (KW) in Excel Datei gespeichert werden (Du hast ein Video schon gemacht habe ich gesehen) und die Datei immer wöchentlich abgespeichert wird KW1,KW2. etc. Was noch gut wäre ist, das die verschobene Daten in der SharePoint gelöscht werden. D.h. als hätte man angefangen Daten neu zu erfassen. Gruss ersin

Great Video! How about bi directional sync without causing a loop? Let's say List A and List B, any changes in List A needs to be reflected in List B and vice versa without causing a loop?

Thanks Enea, great video! How you would modify this workflow if you were trying to sync and roll up several lists (with identical columns but different items) into one master list? Seems it's not that far off - maybe adding a modifier for your syncedID field (ie add a prefix for each child list, A, B, C and then search for the ID # in that list - syncedID would be A1 for first item of list A, B12 for 12th item of list B, etc)... and then replicate your suggested flow here for each list. Would that work you think? Would love to get your take on it.

Hi Enea, thanks for the great video. However, I've tried this guidance for my flow but it ended up run failed. It turned me with: The expression "1 eq Synced ID" is not valid. Creating query failed. Could you please explain where did I go wrong and how to fix this? Thanks in advance!

Great video thank you! What if I want to sync 3 different SharePoint list into 1? I have tried repeating the action for the other SharePoint lists, but it would not work.

Great info! Just wondering if this would work as a 2 way sync as well? So if List 1 is updated it is pushed to List 2, and if List 2 is update it is pushed to List 1? Cheers!

how we do when we delete item?