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 UA-cam 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!
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 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! 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?
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?
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!
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 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!
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.
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 ?
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.
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 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?
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
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?
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.
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 ?
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?
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.
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
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 ?
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
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
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.
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!
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 UA-cam 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 Heather glad it helped you and that's the purpose to talk straight about topic.
3 years ago and still worthy, really thanks.
The man, the myth, the legend. Thank you for posting this video you are amazing!
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!
Great video, the only solution that works until July 2024, thank you !!!!
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.
You're very welcome!
Thank you for sharing this, it has helped resolve a duplication issue.
Thanks a lot for your explanations. This is all I've needed to solve my particular problem.
Glad it helped!
thank you so much , your video was exactly what i was looking for
Thank you for making these videos!
Helped me so much. Your videos are really simple and clear! Keep up with the good work.
Very helpful video. Thank you very much.
very easy to follow and helped me solve a manual process
Glad it helped
Thank you for video! Thats awesome!
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! 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?
I'm in the same boat. Did you figure it out? High level?
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?
Sure will do early Nov
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!
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 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!
Friend helped me a lot.
I have a question, how does it automatically delete the item?
I was just wondering the same thing!
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.
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
Hi! Do you have any guidance on how to delete an item from a secondary list when it is deleted from the primary list?
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 ?
Yes! check out my other videos
@@LernenTech Thanks for replying back, can you point , provide link ? I've been looking but couldn't locate
Thanks!! Your video help so much!! How would I delete the secondary list item if the primary item is deleted?
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.
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?
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.
It should not!
@@LernenTech I had the same issue
Hi Surangma, I too am having the same issue. Could you please let me know how you fixed it??
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?
Worked great, all of the other add and update lists instructions were out of date or didn't work correctly.
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?
add a delete action in your flow.
@@LernenTech so would it look exactly like this flow with a delete function added? Or is the step by step different?
Hello, can the same thing be done when the source is a document library?
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
For further queries do WhatsApp message on --> +91 9557196693
Nice. Thanks
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?
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.
Is it possible to get items without creating a new field/column for source id
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 ?
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?
Not possible
@@LernenTech is this possible with a second flow ?
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.
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.
Oh and look closely at the list you are choosing. That was another one of my blunders.
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
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 ?
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
hmm got a new topic.
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
helpful
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
Could you suggest any other solution
How about update primary list similar to vlookup function in excel
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.
Can I use my own identify key ? if so, how can I do it ?
Yes
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!
Hold my beer….