I tried another way I found on RUclips and got weird behaviors, like the multiplication of items. This one worked like a charm. Congrats on the excellent work! Thanks a lot!
Alireza, Thank you so much. I just followed your steps and was able to completed a project at my work. I really like you taking your time to speak slowly, while explaining the process and the steps involved.
Really Helpful, you have a great way of explaining things, this is the best video on the topic,thanks again,especially helpful to those with zero IT knowledge .
This is amazing, really. Your videos covered exactly what I needed and in such a way that with zero experience I was able to accomplish everything I wanted in a matter of a few hours
Hi Alireza, thanks for making this video. I like how you clearly lay out the instructions. I have a question if you still check this. I'm doing this directly off a SharePoint list app so it does not have a site hub associated with it. Do I still need the content ID for this to work properly?
Great video, thank you for sharing. Do you have any tips on what to do if the fields on the second sharepoint list are not the same fields as in the first one. Because on my 2nd SP list I’m trying to just capture the name of the person who made the changes and previous value.
Great content, you explained everything very well and was easy to follow along with! As a beginner struggling to do this with other tutorials this one was able to help me get what I needed. Thank you!!!
Excellent video. Thank you. I have seen another video that does the same method but he didn't explain it as clearly as you did so now I understand better.
@alireza - thanks for the wonderful video. Just a question. If for example we have multiple conditions for example we only want to copy the items from list 1 to list 2 if they are tagged Yes, otherwise we can leave that item. How to do that. I added an ‘or’ query but with this flow is working but if item is not tagged yes they are also getting copied to new list. And if I use and query then if there are any older items which I modify nothing happens to them. Can you help
Hello Alireza, great video. Currently, I am working on a similar scenario, I am planning to use Hub Content-Type, however, I have a few master lists that are lookup columns. I discover that site lookup columns can't be used on Hub Content Types, so I am replicating content from Master List to all the other sites that are also using this master list as a reference. Currently, I am deleting the master record with a trigger flow ... user has to select items and run flow to delete records. QUESTION ? Is there any way by using the same flow to delete the record list 2 when this is deleted on list 1 ? As always I appreciate all the content that you put here and Udemy :) yes I have purchased a few of your courses .. great material
awesome video !!! thanks a lot, it actually helped me a lot for my new job as a working student for a big company selling brake systems for railways ;-)
Hi, Thank you for video. this is amazing. flow is not working when I have column with People/person group with allow multiple peoples in source list. is there any reason for that?
Great stuff - I'm automate that extracts of attachment from the list and copies it into the library but I also want the meta data from the list that to be in Library column
Hi ALireza, can we add the 2 columns in an excel sheet by putting the formula in action compose of addition of 2 columns through power automate and update an excel sheet in sharepoint.
Thank u! This worked EXCEPT for my group columns it only updated/created one value? Any ideas? Looks like I’m only getting the last person in the column?
this was so helpful! do you have any tutorials for copying Image fields from one list to the other? Or even multi-line text fields that have rich text enabled?
No. Image field is just a hyperlink to image location, so technically it is a text. On the other hand Rich text is just HTML, so treat it like text field.
Hello Alireza This is great. Thanks for sharing. Better than the solution using filter array. Though, I am having issues on my lists. I'm trying to do the same thing, multiple source lists and one combined/target list. The issue is that both trigger and get items fields does not show in the dynamic content window lists. Are there any limitation on the type of field/column that would not allow me to copy its content in a different list?
Hi Alireza, your video was very helpful for me to complete one of the task at my work. However I still have one question in this context. Wanted to know how to modify this flow to incorporate if a item is DELETED in the source list. I am stuck on this.
Hi, thanks lot for the information shared! My question is, what changes in these steps would be required, if i only need to copy whenever there is an update in source list, otherwise not doing anything.
Incredible video, I am a newbie in PA. And at my current job they have assigned me tasks that have to do with this. However, I was wondering if there is a way to manage the following scenario: I have some fields in my forms that can select more than item e.g. Type: Water and Fire. When this specific new entry is copied to the other list, it creates 2 items. One for fire and one for water. Is there any way to bypass this to create only a single item? Thanks in advance.
This is really useful. I don't know if it is possible, but would it be possible to just trigger the flow to happen once a day or once a week and it then update all the items which have been modified since the last flow run?
Alireza. thanks a lot for this tutorial. Have a follow up question - if your List 2 (destination list) is updated by a user with new items, is there a way to add the same 'SourceID' to the new items added? I am assuming some type of flow is needed. I would appreciate your help!
Thanks - yours was the only video that worked after scouring the web for 2 days! Trying create a flow to delete an item in a child list, which I imagine has the same issue around the ID compatibility. The Identifier value is not attainable in Dynamic Content. Do you have any videos on this topic? I guess you could use name but this may not be unique. Would seem like a simple flow to master but in practice it's not so...
Hi I know its very late, but I have been following the above course and found the solution. You need to find out what your SourceIDs/Identifier typically look like. In my case List%25fPlanner%2b2022%252f###_.000 the ### is equal to the ID number. So if you use the Filter Query where {ID} is dynamic content, you can run the rest of the flow.
This video was AMAZING! Thank you so much! I was able to get this working perfectly. My only question now is... I deleted a row and it did not delete it in table 2. So now to add a delete step. Do you have a video for that? :)
Thanks Alireza. great video. can we keep 2 lists sync using the same method?if user makes any changes in List2, it takes the update to List1 and vise versa? please advise?
Thanks for sharing important information i was trying to do same from many weeks, your video made it easy. i have one question over here If item from list 1 is deleted same item from list 2 is not deleted, can you please help me with that.
That was very informative and well explained, thank you! What is the way to look for modified items in List 2 and update List 1 accordingly? Trying to figure it out, but somehow this is beyond my capabilities.
Thank you and I am still wondering why this video attracts so much of attention. Since I started my career in Power Automate and logic apps, I never faces an automation scenario that requires this kind of work. Anyway, I am glad you found it helpful :)
Thanks so much for this tutorial. Helped me a ton. What about if something is deleted from List 1? For me, it isn’t deleting from List 2 too after completing these steps.
great tutorial, finally someone is able to explain me flow. However, I can't get the length Expression to run.when I want to add "List of Items" between the brackets of length(), I only get body and value from Get items, and the expression looks entirely different from the video - length(outputs('Get_items')?['body']) - and results in a fail.
This was a live demo, so nothing has been edited or hidden from you. At the same time, keep in mind that Microsoft constantly changes and updates Power Platform actions. If you are doing everything according to the demo and still get error, there is a good chance that things have changed on Microsoft side. Regardless I try it myself later and update you on that.
This was VERY helpful! Thank you so much! 🙂 Is there a way to have Site 1 update if you make a change to an item on Site 2? I tried creating a flow on my own using the information you provided in this video, but then I ended up with an item being added to each list. This left me with several duplicate items because the flow would keep running in a loop.
Thank you. It was helpful. Can you also share your inputs if we can update existing list item with some information coming from list A and some piece of information coming from list B? Or is there any way we can use Forms, PowerApps and InfoPath to achieve this? Any comment would be much appreciated. Thank you
Hi there, I know this was made 4 years ago, but how would I put add the SourceID for a list of existing items on the destination list? Thanks for the video!
Hi Alireza, won't you PLEASE do a take 3 of this video and take the same flow from this video and just add the steps to also copy an "IMAGE" type field from list 1 to list 2 during run?
Alireza, Do you by any chance have a video that will take responses from a second MS Form and populate list A or B? I will prefer updating list B directly. This is a deployment project for the first part. Now that the deployment is completed, we are collecting feedback to update list A or B, whichever way is simpler, please. Thanks in advance. Nee
Hello! If i want the element which has been updated in list 1 to be shifted into list 2 (means the element which has been updated is no more in list 1 but in list 2). How can I do that?
Hi, how can I make this work, when I need to change items multiple times? It is working perfectly when I make change in main list once, but when I change item second time on my main list it makes new item on second list (instead of updating item). It has something with "sourceID" or "identifier" - could you help?
I have 1000 items in both SharePoint list and i want to copy Client_Name from list1 to list2 if ProjectID matches to ProjectID from both the list , can we create manual flow for once time update all the item, please help
Hi thank you so much for the tutorial! It really helps. I did exactly as shown in the video, but only the create item that works and whenever I update the item, power automate can't detect it. Could you or anyone here help me regarding this?
Great videos. Is there a way to pull comments over from one list item to another list item? I am able to get the item copied over, but the comments dont come over.
Thank you so much. However, what if I have to migrate my existing data from List1 (old) to the new List? Say, if I have 300 records in my old list. Can this be achieved using this logic?
No, and why do you want to use Power Automate to copy existing files? Watch this video before you build another flow. ruclips.net/video/ktX1H0bMfw8/видео.html
Hi Ali, Request to make a video to copy items within the same list for "multi people picker' selections. I tried with Array and i could not get to it. Please add a video specifically for multi people picker and copy that item within the same list.
I followed instructions exactly, but i get an error in Get Items stating that Column 'SourceID' does not exist. I thought all lists had a source ID. thoughts on how to correct?
Let me go and do this, I was struggling to update my 2nd list when a new response is submitted from another list, I’m running 3 flows to update 1 list, so I needed each to update the same list on each step…will come back for more and report
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
I tried another way I found on RUclips and got weird behaviors, like the multiplication of items. This one worked like a charm. Congrats on the excellent work! Thanks a lot!
Alireza,
Thank you so much.
I just followed your steps and was able to completed a project at my work.
I really like you taking your time to speak slowly, while explaining the process and the steps involved.
Bunch of thanks for You for the way of sorting things out. My prayers came true as well and the flow runs so nicely. Thanks again and keep up well.
Huge fan; you make learning enjoyable. Keep up the great work!
Really Helpful, you have a great way of explaining things, this is the best video on the topic,thanks again,especially helpful to those with zero IT knowledge .
Thanks - very clear and easy to follow 👍
Can you expand on this to include LIST attachments ?
Hi Alireza,
Really it's fantastic and you explained in very clear way so that anybody can understand easily. Thanks for this video.
Hi @Alireza
In Get items, i don't see List of Items (14:26) in my flow, Please can you help?
You're amazing! Thank you for making this video! It will really impress my Corporation!
This is amazing, really. Your videos covered exactly what I needed and in such a way that with zero experience I was able to accomplish everything I wanted in a matter of a few hours
Hi Alireza, thanks for making this video. I like how you clearly lay out the instructions. I have a question if you still check this. I'm doing this directly off a SharePoint list app so it does not have a site hub associated with it. Do I still need the content ID for this to work properly?
Part 1 & Part 2 are really nice and amazing for learning from seeing this video. Thanks, Millions indeed.
Great tutorial! If one of the columns in List 1 has "allow multiple selections" enabled, how would you approach that from a flow perspective?
I love you man ❤ most useful video I have seen thus far
Hi thanks for this video, do you know what I have to do if there if there are multiple options in the list.
You are a very good teacher. Thank you!
Great video, thank you for sharing. Do you have any tips on what to do if the fields on the second sharepoint list are not the same fields as in the first one. Because on my 2nd SP list I’m trying to just capture the name of the person who made the changes and previous value.
Use a proper tool like Sharegate. I really don't like using flow for this kind of work.
Great content, you explained everything very well and was easy to follow along with! As a beginner struggling to do this with other tutorials this one was able to help me get what I needed. Thank you!!!
Thank you for the detailed information given at very nice pace and clarity.
Excellent. Helped me a lot. Now a Subscriber.
Excellent video. Thank you. I have seen another video that does the same method but he didn't explain it as clearly as you did so now I understand better.
Glad it helped
Great Content, Thank you for detailed explanation!
Very useful for me since I am going to learn it from this video and creating the same idea for Backup. Many Thanks.
Explained and demonstrated very well.
Very helpful! It works on my end. Thanks for sharing👊
@alireza - thanks for the wonderful video. Just a question. If for example we have multiple conditions for example we only want to copy the items from list 1 to list 2 if they are tagged Yes, otherwise we can leave that item. How to do that. I added an ‘or’ query but with this flow is working but if item is not tagged yes they are also getting copied to new list. And if I use and query then if there are any older items which I modify nothing happens to them. Can you help
Very helpfull content Thnkas for this Video
Awesome explanation! Thank you!
Hello Alireza, great video. Currently, I am working on a similar scenario, I am planning to use Hub Content-Type, however, I have a few master lists that are lookup columns. I discover that site lookup columns can't be used on Hub Content Types, so I am replicating content from Master List to all the other sites that are also using this master list as a reference. Currently, I am deleting the master record with a trigger flow ... user has to select items and run flow to delete records.
QUESTION ? Is there any way by using the same flow to delete the record list 2 when this is deleted on list 1 ?
As always I appreciate all the content that you put here and Udemy :) yes I have purchased a few of your courses .. great material
Thank you so much for this.... Really needed this for my Project
Hey Ali, thank you for the great video. I have a question. Using the above flow process can we also move attachments? If so, how can we do that?
awesome video !!! thanks a lot, it actually helped me a lot for my new job as a working student for a big company selling brake systems for railways ;-)
Very helpful video. Thank you very much.
Hi, Thank you for video. this is amazing. flow is not working when I have column with People/person group with allow multiple peoples in source list. is there any reason for that?
Great stuff - I'm automate that extracts of attachment from the list and copies it into the library but I also want the meta data from the list that to be in Library column
Hi ALireza, can we add the 2 columns in an excel sheet by putting the formula in action compose of addition of 2 columns through power automate and update an excel sheet in sharepoint.
Thank u! This worked EXCEPT for my group columns it only updated/created one value? Any ideas? Looks like I’m only getting the last person in the column?
this was so helpful! do you have any tutorials for copying Image fields from one list to the other? Or even multi-line text fields that have rich text enabled?
No. Image field is just a hyperlink to image location, so technically it is a text.
On the other hand Rich text is just HTML, so treat it like text field.
Fascinating!
Very clear explanation ... thanks a lot.
Great video! Thanks
Hi there, thanks for the helpful video, although I cant seem to get attachments to copy across aswell is there something I'm doing wrong?
you eased my task. many thanks
You are a star! Thank you!
Thanks for your lessons. I have a question how we can copy mulitvalue people picker data from one list to a second list using powerautomate
Thank you for this! I'm new to flow and going sometime into dummy details really helps me.
You're great! So many thanks for your time and shared this solution!
Thank you, sir! You're my hero! it's like you have a solution for every problem I encounter! lol
Perfect content! Thank you!
Hello Alireza This is great. Thanks for sharing. Better than the solution using filter array. Though, I am having issues on my lists. I'm trying to do the same thing, multiple source lists and one combined/target list. The issue is that both trigger and get items fields does not show in the dynamic content window lists. Are there any limitation on the type of field/column that would not allow me to copy its content in a different list?
good job..Please keep it up !!!!
Thank you much appreciated can you create a power automate copying documents from library to another with metadata please
Hi Alireza, your video was very helpful for me to complete one of the task at my work. However I still have one question in this context. Wanted to know how to modify this flow to incorporate if a item is DELETED in the source list. I am stuck on this.
Hi, thanks lot for the information shared! My question is, what changes in these steps would be required, if i only need to copy whenever there is an update in source list, otherwise not doing anything.
Incredible video, I am a newbie in PA. And at my current job they have assigned me tasks that have to do with this. However, I was wondering if there is a way to manage the following scenario: I have some fields in my forms that can select more than item e.g. Type: Water and Fire. When this specific new entry is copied to the other list, it creates 2 items. One for fire and one for water. Is there any way to bypass this to create only a single item? Thanks in advance.
This is really useful. I don't know if it is possible, but would it be possible to just trigger the flow to happen once a day or once a week and it then update all the items which have been modified since the last flow run?
Keep going, Ali!
Great tutorial! Is there a way to copy an EXISTING ITEM in SharePoint list as well?
Alireza. thanks a lot for this tutorial. Have a follow up question - if your List 2 (destination list) is updated by a user with new items, is there a way to add the same 'SourceID' to the new items added? I am assuming some type of flow is needed. I would appreciate your help!
Were you able to figure this out? I am trying to do the same thing and cannot seem to make it work.
Thank you very much Mr Ali.. Appreciated.. Finally I found the solution here.. :-)
very good! keep it up
Thanks a lot!
Thanks - yours was the only video that worked after scouring the web for 2 days! Trying create a flow to delete an item in a child list, which I imagine has the same issue around the ID compatibility. The Identifier value is not attainable in Dynamic Content. Do you have any videos on this topic? I guess you could use name but this may not be unique. Would seem like a simple flow to master but in practice it's not so...
Hi I know its very late, but I have been following the above course and found the solution. You need to find out what your SourceIDs/Identifier typically look like. In my case List%25fPlanner%2b2022%252f###_.000 the ### is equal to the ID number. So if you use the Filter Query where {ID} is dynamic content, you can run the rest of the flow.
Thank you! Very well explained.
This video was AMAZING! Thank you so much! I was able to get this working perfectly. My only question now is... I deleted a row and it did not delete it in table 2. So now to add a delete step. Do you have a video for that? :)
Thanks Alireza. great video. can we keep 2 lists sync using the same method?if user makes any changes in List2, it takes the update to List1 and vise versa? please advise?
Were you able to figure this out? I am trying to do the same thing and cannot seem to make it work.
hi thank you very much for this video it helps me alot, how about when deleting items at site list 1 and automatic delete in site list 2?
Thanks for sharing important information i was trying to do same from many weeks, your video made it easy.
i have one question over here If item from list 1 is deleted same item from list 2 is not deleted, can you please help me with that.
Hi, can you create multiple flows from different lists to add up into one single list
Thank you for this video! Very useful! :)
hi sir do you have video for copying the image column from (list 1) to another (list 2)
That was very informative and well explained, thank you! What is the way to look for modified items in List 2 and update List 1 accordingly? Trying to figure it out, but somehow this is beyond my capabilities.
Thanks for your videos! Very helpful indeed.
Thank you and I am still wondering why this video attracts so much of attention. Since I started my career in Power Automate and logic apps, I never faces an automation scenario that requires this kind of work.
Anyway, I am glad you found it helpful :)
Thanks so much for this tutorial. Helped me a ton. What about if something is deleted from List 1? For me, it isn’t deleting from List 2 too after completing these steps.
great tutorial, finally someone is able to explain me flow. However, I can't get the length Expression to run.when I want to add "List of Items" between the brackets of length(), I only get body and value from Get items, and the expression looks entirely different from the video - length(outputs('Get_items')?['body']) - and results in a fail.
This was a live demo, so nothing has been edited or hidden from you. At the same time, keep in mind that Microsoft constantly changes and updates Power Platform actions.
If you are doing everything according to the demo and still get error, there is a good chance that things have changed on Microsoft side.
Regardless I try it myself later and update you on that.
@@AlirezaAliabadi much appreciated Alireza.
DId you manage to get round this issue?? I'm having the same problem
@joeschmoe22 did you find a solution?
This was VERY helpful! Thank you so much! 🙂
Is there a way to have Site 1 update if you make a change to an item on Site 2? I tried creating a flow on my own using the information you provided in this video, but then I ended up with an item being added to each list. This left me with several duplicate items because the flow would keep running in a loop.
Thank you. It was helpful.
Can you also share your inputs if we can update existing list item with some information coming from list A and some piece of information coming from list B? Or is there any way we can use Forms, PowerApps and InfoPath to achieve this? Any comment would be much appreciated. Thank you
Hi there, I know this was made 4 years ago, but how would I put add the SourceID for a list of existing items on the destination list?
Thanks for the video!
Hi Alireza, won't you PLEASE do a take 3 of this video and take the same flow from this video and just add the steps to also copy an "IMAGE" type field from list 1 to list 2 during run?
Hi Alireza, Could please help me to create a flow for an excel file in a SharePoint document to create an item in a sharepoint list.
Thank you!!
Thank you and helps me a lot.
Alireza,
Do you by any chance have a video that will take responses from a second MS Form and populate list A or B?
I will prefer updating list B directly.
This is a deployment project for the first part.
Now that the deployment is completed, we are collecting feedback to update list A or B, whichever way is simpler, please.
Thanks in advance.
Nee
Hello! If i want the element which has been updated in list 1 to be shifted into list 2 (means the element which has been updated is no more in list 1 but in list 2). How can I do that?
Great video!
If I delete item from the list 1, the item in the list to Will be deleted too?
No, for that you need to add another flow
hi sir do you udemy course for sharepoint
Can this be done in SharePoint 2013?
You're amazing, thanks!
Hi, how can I make this work, when I need to change items multiple times? It is working perfectly when I make change in main list once, but when I change item second time on my main list it makes new item on second list (instead of updating item). It has something with "sourceID" or "identifier" - could you help?
thank you!
Thank you, Really Helped me 🙏
You're welcome!
Awesome video. How can I update list 1 if users make changes on list 2. Am I missing a step?
Great video! How could someone incorporate copying an attachment from List 1 to List 2 as well?? I have been unsuccessful.
I have 1000 items in both SharePoint list and i want to copy Client_Name from list1 to list2 if ProjectID matches to ProjectID from both the list , can we create manual flow for once time update all the item, please help
Hi thank you so much for the tutorial! It really helps. I did exactly as shown in the video, but only the create item that works and whenever I update the item, power automate can't detect it.
Could you or anyone here help me regarding this?
Great videos. Is there a way to pull comments over from one list item to another list item? I am able to get the item copied over, but the comments dont come over.
Thank you so much. However, what if I have to migrate my existing data from List1 (old) to the new List? Say, if I have 300 records in my old list. Can this be achieved using this logic?
No, and why do you want to use Power Automate to copy existing files? Watch this video before you build another flow.
ruclips.net/video/ktX1H0bMfw8/видео.html
I didn't get it with the identifier? what value does this take? or what value must be written - by default the field is empty.
Hi, i wanted to copy all items from one list to another. how to achieve that?
Hi Ali,
Request to make a video to copy items within the same list for "multi people picker' selections. I tried with Array and i could not get to it. Please add a video specifically for multi people picker and copy that item within the same list.
I followed instructions exactly, but i get an error in Get Items stating that Column 'SourceID' does not exist. I thought all lists had a source ID. thoughts on how to correct?
Brilliant! Thanks for sharing :) I've been losing my hair for days around this issue!
You are so welcome!
Let me go and do this, I was struggling to update my 2nd list when a new response is submitted from another list, I’m running 3 flows to update 1 list, so I needed each to update the same list on each step…will come back for more and report