Add & Update a Secondary SharePoint list using Power Automate Flow 

Great video, the only solution that works until July 2024, thank you !!!!

3 years ago and still worthy, really thanks.

Thank you!!! This really helped me solve a work problem and I'm so grateful that you posted this video. Its perfect: some of these videos on RU-vid be like reading a recipe from some blogger. You gotta wait forever and ever to get to the real content. Not the case with your videos. I love that.

Thank you for this. I also appreciate you showing the mistake and how to fix it. I have been subject to that mistake several times as well. Power Automate is very tricky!

The man, the myth, the legend. Thank you for posting this video you are amazing!

Thank you so much! Your video was the easiest explanation I saw for this for someone just starting out in PowerApps. Going to check out your other videos now.

Thank you for sharing this, it has helped resolve a duplication issue.

very easy to follow and helped me solve a manual process

Thanks a lot for your explanations. This is all I've needed to solve my particular problem.

Friend helped me a lot. I have a question, how does it automatically delete the item?

Thank you for your videos which are super simple and awesome. It would be great if there is a video on how we can avoid automatic apply to each whenever editing a flow and selecting few items

Thank you for making these videos!

Very helpful video. Thank you very much.

Helped me so much. Your videos are really simple and clear! Keep up with the good work.

thank you so much , your video was exactly what i was looking for

Great tutorial very informative. I have a question when an entry is deleted in the Source list it is not deleted in the destination list ! Do we need a second flow for this ? any cue ? thanks so much for your share .

Thank you! This really helped me. I have a situation where we have a lookup list. It must be used in other collections, however. So I plan to make a flow as you show here. My question would be, what happens when I delete an item from the main list? How can I delete it from the duplicate list?

Thank you for video! Thats awesome!

Nice. Thanks

Hello, and thank you for your videos! Can you please expand on this flow by including attachments / replacing attachments from the primary list to the secondary list?

How do you handle the "Update Item" part when you have a Lookup Column with Multiple Choices in your first list? Only the last value is retained. Why?

Thank you very much. This worked perfectly for my project. I am updating multiple SP lists with various fields required for each, all based on same Identifier. I am wondering - as the trigger is the same for each list to update. Is it best to just add each SP list here in the Yes/No as a new action to update/create? I feel like I could copy this and update for each list with seperate flows for each, but wonder if they would conflict. Just not sure which is the most efficient way - and fastest for the flow to run and make the updates. This is super slick - thanks for the information!

Thanks!! Your video help so much!! How would I delete the secondary list item if the primary item is deleted?

Worked great, all of the other add and update lists instructions were out of date or didn't work correctly.

I know this is an old video but hoping I can find help to my problem. With the Source ID filter you have, that works great for me. But, I have a second column on my Source list for 'upload?' (Yes,no). I want it to only create/update items that also have a 'yes' in the 'upload?' Column. I add that to my filter queries with 'and upload? eq 'Yes'' but it's not working. Basically if something is created or updated on the Source data, BUT it says 'no' in the filter, do nothing.

Thank you, your videos are awesome, can you please help how I can update lists with two different lists . But the update should not be done based on "ID". Thanks

Really helpful , thank a lot :) if my source LIST has attachments , is it possible to include these on either side (i.e. Create New Item or Update Item) , right now it work perfectly but without attachments ?

Hello How can I correctly add to this cycle that when the user updates information in the Destination lists, it is also updated in the Source lists? It is necessary that in both sheets it is possible to change the information in the record.

great video, i was able to replicate quite well, but for some odd reason the Source ID changed and a new item was added to the destination list... would this be because of the versioning enabled?

Is it possible to get items without creating a new field/column for source id

Hi, Thanks for sharing this video. I have created similar flow but I have used trigger "when an item or file is modified". It creates duplicate entries of my records when they are modified in source list.

Hello Learning Tech I have also done it according to your instructions but when I update it makes me a new line every time. I don't know where I made the mistake.

Thank you very much for this! Super helpful! Do you have a similar tutorial for updating with a manual trigger? I haven't worked out how to adapt this for an instant trigger... Thank you in advance!

helpful

4:08 Your Source ID is 2 words, with a space inbetween, but you remove the space without any mention here. What does this mean?

Hey thanks for the video. Can you please advice me... In a situation where I wish to copy/move a row from one list to another list whenever I update the "progress" column of the list as completed which was mentioned "pending" otherwise. How to create a flow for that.

If we are using large columns to update or create.while mapping for each it's taking too much of time not able to mapping all the columns

Thanks a lot for the video the flow working fine but i have one problem that I have a choice column Yes/No, and in the update item, I change the from No and choose "enter the custom value" and chose the column name to be updated with the rest of the columns I get an error ? can u help with this please. thanks a lot

Thanks! it sort of worked, my flow seems to create a new item, rather than update the existing item.. what am i doing wrong? i think i followed your video down to the letter! also it skips calculated items

Thank you for this - not sure why but mine is duplicating a row for each change instead of updating the existing row in the 2nd list.

Hello and Thanks for your helpful videos! I need some help and hope you can help me. I've created an inventory list and a product order list. Both are exact duplicate lists. I'm trying to power automate a flow that will subtract from an item in the inventory list, when at the same time an item is modified in the product order list (For example: When someone adds 3 pens in the product order list, the 3 pens will automatically subtract in the inventory list). How would I power automate this?

Thank very much for this video, My question is , how do you update or add a comment to another list using a Unique ID so that Line Item is Updated with the comment, specifically a resolution column, as when the ticket is closed, that Resolution column in the other list is updated with the resolution. Hope i explained this well. Thanks

Hi, thanks for your video was useful to me. I have a problem with the flow. Don't get de filter because the column was rename, and it says the column doesn't exist but is active. can you help me please

Hello, can the same thing be done when the source is a document library?

Could you suggest any other solution

hi.. thank you for your videos, very helpful. One question please. How can I modify this to include the delete function so when an item is deleted from the primary list, it also deletes it from the secondary list?

Hi Sir, please help me , I do and redo the flow many times, but althought I have had pay extremelly attention on te video the flow doesn't run on update , I just have the create item working fine , do you have any idea what could i do to make it happen ?

Hi, will you be able to demonstrate how to track multiple changes within the same Sharepoint list and identify what are the changes? For example, indicate that "Fruit A" has been changed to "Fruit B". It will also be able to track multiple changes (at different columns) within the same list. Thank you in advance!

How about update primary list similar to vlookup function in excel

Can I use my own identify key ? if so, how can I do it ?

Hold my beer….