Add & Update a Secondary SharePoint list using Power Automate Flow

[@BadToTheBork]

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 KZbin 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.

[@LernenTech]

Thank you Heather glad it helped you and that's the purpose to talk straight about topic.

[@jenofanesbrownb.6999]

3 years ago and still worthy, really thanks.

[@jamieh9253]

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

[@jasonluckey2214]

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!

[@violetimp3501]

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.

[@LernenTech]

You're very welcome!

[@DustyWagon]

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

[@agathonikos]

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

[@sidneycomandulli9460]

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

[@LernenTech]

Glad it helped!

[@tough570]

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

[@allenmcmillin2790]

very easy to follow and helped me solve a manual process

[@LernenTech]

Glad it helped

[@bobby_venky117]

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

[@storiesreadaloudforkids2224]

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

[@stevemcc7208]

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?

[@elishmuel1976]

I'm in the same boat. Did you figure it out? High level?

[@victorgranado]

Thank you for making these videos!

[@eduardocapaneli1141]

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

[@jmclean981]

I was just wondering the same thing!

[@mainguyen3097]

Very helpful video. Thank you very much.

[@juandiegojp]

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?

[@lestercoratchia7194]

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?

[@LernenTech]

Sure will do early Nov

[@StephanieSeattle]

Hi! Do you have any guidance on how to delete an item from a secondary list when it is deleted from the primary list?

[@mron4161]

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?

[@Tom-iv9zv]

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.

[@jenda1351]

Thank you for video! Thats awesome!

[@MMJAZZ1977]

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 .

[@susanclark1778]

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!

[@BBtheONLY1]

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

[@surangmasharma8159]

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.

[@LernenTech]

It should not!

[@mamagarmiza]

@@LernenTech I had the same issue

[@vikasumapathy5056]

Hi Surangma, I too am having the same issue. Could you please let me know how you fixed it??

[@neeesz]

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 ?

[@LernenTech]

Yes! check out my other videos

[@neeesz]

@@LernenTech Thanks for replying back, can you point , provide link ? I've been looking but couldn't locate

[@kanikamadan491]

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.

[@steveshoulders]

This is great, although I don't understand why LENGTH is used in the condition. The SourceID is unique - I get that - but I would think its length can be the same compared to the length other items. Can someone explain why the use of LENGTH will never result in the comparison of items which are not the same ?

[@ericleeson5457]

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?

[@LernenTech]

add a delete action in your flow.

[@ericleeson5457]

@@LernenTech so would it look exactly like this flow with a delete function added? Or is the step by step different?

[@itmailabs]

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.

[@ashfaqfishing1988]

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

[@mohamednasr5444]

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

[@LernenTech]

For further queries do WhatsApp message on --> [phone]

[@rprocker555]

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

[@patrickvankerckhoven4050]

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

[@hayleyreid6699]

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!

[@Jakaro007]

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

[@balysvitkauskas8272]

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 ?

[@allenreid8267]

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?

[@aprilmills5925]

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.

[@andrianarowe4946]

I was having the same issue until I looked closely at the list items I was choosing from ie. Get items or When an item is created or modified. Once I matched all of those up it worked perfectly.

[@andrianarowe4946]

Oh and look closely at the list you are choosing. That was another one of my blunders.

[@nenusaitham_Janasena_Kosam]

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

[@Buurbachi1]

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

[@mikemike68]

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

[@LernenTech]

hmm got a new topic.

[@yuliarevalo398]

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

[@Todd-W]

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?

[@LernenTech]

Not possible

[@valeriedupire9590]

@@LernenTech is this possible with a second flow ?

[@nenusaitham_Janasena_Kosam]

Could you suggest any other solution

[@chinnamchiang1872]

How about update primary list similar to vlookup function in excel

[@akkaradechsrithongchai7766]

Nice. Thanks

[@ersinyalcin7671]

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.

[@dougaw12]

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

[@LernenTech]

Yes

[@avneetKumar]

helpful

[@ahrongz]

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!

[@TonyE-k7w]

Hold my beer….