Update Secondary SharePoint list using Power Automate when new item is created or existing modified
HTML-код
- Опубликовано: 22 май 2024
- In this video you will learn using Power Automate or MS Flow how you can update secondary list data when there is any item created or modified in the primary list. i have used filter array to fetch the compared data. watch full video to understand how you can achieve this too.
To generate unique Id for SharePoint list item check the below Url:
• How to create auto gen...
![Don Toliver - Attitude (feat. Charlie Wilson & Cash Cobain) [Official Music Video]](http://i.ytimg.com/vi/A90X6-jIe1g/mqdefault.jpg)
Thank you so much! Clear, simple, and well-paced video. Just the lesson I needed. The condition with append or create new was just what I needed.
Your flows are exactly what I am looking for, and so well explained! Thank you for your videos!
SUPERB lesson - has exactly solved a problem I had with duplicate/triplicate entries firing when original List amended. Great how the filter and condition steps all work together - has so many applications. THANK YOU for a very clear and helpful video. Very easy to follow and create my own Flow.
Thank you! I was stuck on trying to figure out how to update a document that I was populating from a sharepoint list. I used the way you set up your flow to update a sharepoint list from another sharepoint list to update my document library file properties from a sharepoint list.
It helps me a lot. most of the videos explained to update the record with source id. But this video shows how to update existing item with our unique column. Thank you very much!
Thank you so much Teacher.. you are the best ever :)
Thank you so much! I am trying to synchronize two sharepoint lists, and this video just saved my life!!!
This was exactly what I was looking for!
Found it after multiple search, Thanks.
Nice video! Thanks for this!!
Awesome video. it helped me solve my issue.
Thank you for this video
Thank you this video is quite informative . can u please make a video on delete operation also ?
This worked for a button flow to update an excel spreadsheet into a sharepoint list. Thanks
You're welcome!
Thank You very useful...
Fantastic, this is what I want to do. Thanks for sharing.
Have fun!
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 I want to check if there is a possibility of updating just one column in secondary list when we change the entry in the primary list? I am looking for a solution where a group of participants when submit a completion status in one column for Primary list the same gets updated in the secondary list column.
Thank you, very helpful
Glad it was helpful!
Thank you, I've succeeded in these processes thanks to your guidance. I have one more question: I want to use a Power App trigger as the trigger for my flow. However, the issue here is that I can't use the List from the step 'When an Item created or modified'. When I add an extra 'Get items' step, the 'Filter array' operation doesn't work the same way and it becomes more complex. Do you have any ideas on how to solve this problem?
OMG THANK YOU SO MUCH I LOVE U
Filter Array is not needed when we do get Items on destination list, Apply the filter so that Get Items function only gets existing record or no record. put a condition to check the length of body value =0. If yes then its a new Items otherwise update the existing item in destination list. If you do Apply to each then there is a chance of all items get updated in destination list, which is very risky. Thanks for the video.
Hi, I loved this video, however, whenever I edit an item, it just duplicates the updated version? Is there a way to fixed this?
Can I use the the same method from list to document library?
Great video!
If I delete item from the list 1, the item in the list to Will be deleted too?
Amazing thanks!. I have a flow that has been running like this but all of a sudden the body of the filter array isn't showing any outputs. Any ideas?
Thank you
Can i use the same method form list to document library?
IT WORKS!!!! ⭐️⭐️⭐️⭐️⭐️
But with this flow process how can I add the option to remove the row from the first one? It will be like transferring uodated item from old list to new list.
Hey this is Awesome and has helped me a bunch. I had a question about using the array and why you would not use an Odata filter to filter your (to be )updated Items list instead of the Array? when you use the get Items without the filter then it pulls all the record instead of the ones with matching ID's. Would that make more sense for large lists?
For further questions and queries mail us to lernentech@gmail.com or drop a message to our Facebook page - facebook.com/Lernentech/ or do a Whatsapp message on - +91 9557196693
Thank you.
You're welcome!
Nice flow!
I have a question. I have two lists. One list is a inventory list of products with the amount of stock. I also have a list where I can register the usage of the products in stock. Now I will make a flow where the amount of product will be reduced when I register the use of a product in stock. And when a register a purchase it has to add up my stock again. Is there someone who could help me?
Sorry for my english.
Regards
Robin
Can you make one video update 2nd list that already have email and attachments there which usually update unable to update additional email and attachments added from master list. Thank you
Can somebody help: can I delete an item from the secondary list when deleting it from the source list?
good
Thanks for the tutorial!!!! But do you know how to fix Failed to fetch error? I follow every step but this error shown.
Can you parameterize the List Name of the Update item step?
Thank you for the video. I followed the steps and for the most part, it works as expected. One issue. When the flow runs to create a new data row, two data rows are created, one with a UniqueID and one without (blank). Any idea why?
not so sure.
For further questions and queries mail us to lernentech@gmail.com or drop a message to our Facebook page - facebook.com/Lernentech/
I followed every step and when I update a record from my parent list (which already exists in child list) it creates a new record in child list. Really appreciate any help.
Thank you so much, very useful. Question: if an item from the source list is deleted, how can I automate the deletion of said item on the destination list? Thank you!
I have latest video on channel about delete item trigger
Great video,,, need help if i want to compare multiple columns in filter array ? or how to compare multiple columns ?
for additional query message us on lernen tech facebook page
How can we trigger the update/create item based on change in status? For eg. If it’s an issue tracker and we want to copy data from some columns to another list if Status (one column in source data) is changed to “Closed”
you can change the trigger point and apply for that item only. will create video on that soon.
Lernen Tech thank. Shall await your video on this. I want to copy items to a new list when I change one of the fields (status) in an existing list so that the next person can take the task forward from there
I have to filter the specific column let's say status which has data type choice and option are active and close ....from source so that i will get items according to the filter based on close option so i have added the condition status eq 'close' in the filter query in get item... But my flow is failing on the get item stage... Can anyone help me resolving this
Hi , Thank you for the video..i have one prob ..we are trying to create transaction Log in the list 2 ..that is whenever an item is created or modified in the list i wanted to create a new entry in the list 2 with the modified date ...but when use copy data from list 1 to list 2 it is copying all the entries but i need to create an entry an new entry in the list 2 when list is updated may same entry modifed more times i wanted to maintain the logs ....Ca you help with this... !
For any additional query and concern message us on our fb page - facebook.com/Lernentech/ or drop a message at lernentech@gmail.com
Can you do this if the Parent list needs to update/create several items in the child list?
ok
Hi, thank you for the video. Is there a way to store data in different fields inside sharepoint list based on likert scale in MS Forms?
Eg: if i choose "Purchased" for Desktop in the likert scale, I want it to store into PurchaseDesktop field in Sharepoint,
if i choose "Rent" it will store into RentDesktop field.
yes
Nice video Prakash. Can you also please share with me the automatic ID generated link.
Varun bhai thora mehnat kar lo :p
@@LernenTech hahahaha sure..
Thanks Q
Any time
Hi, thank you for the video. i am getting this type of additional information for multiple selection fields [{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":0,"Value":"ABCD"}]
Can you please suggest something to resolve this issue .
For any question and query message us on -facebook.com/Lernentech/
Was this issue resolved? I am getting the same problem. Thanks in advance!
Hi.. Thanks for the video. I have an issue I am updating secondary list with the same flow but my flow running more actions than expected.. it runs after every 30 seconds and doesn’t stop.. Appreciate if you could help.. Thanks
connect over our fb page for additional query
Lernen Tech could you please share the link of your FB page
@@nomi.shahzad facebook.com/Lernentech/
what about when you have multiple filters
I want to sync and update two share point calendar list using power automate. How can that be achieved?
will create video soon on that.
Thanks! I have been stuck on it and unable to successfully implement it. Will be waiting for the video. ✌🏼
@@LernenTech Hi, thank you for the explanation above, it's totally helpful. May I know if the video regarding sync and update sharepoint that you mentioned is ready? Because I could not find which one you meant at your current video.
It doesn't work :( Can someone help me please?
I have tried this and keep running into this new error "The API 'sharepointonline' returned an invalid response for workflow operation 'Get_items' of type 'OpenApiConnection'. Error details: 'The API operation 'GetItems' is missing required property 'body/value/0/Title'.'"
There are no required fields except for title which is filled in...
AHHH to anyone else this occurs - update the connection on the get items.
Bro there is new video on channel, if still getting issue drop whatsapps
Can I use the method from list to document library?
what do you want to do?
I wanted to move the metadata from share point list to a document library using flow but I solved that problem . Thank you so much for your videos . I wouldn’t not have got this far on my projects if it wasn’t for your videos.
I wanted to move the metadata from share point list to a document library using flow but I solved that problem . Thank you so much for your videos . I wouldn’t not have got this far on my projects if it wasn’t for your videos.