Update Secondary SharePoint list using Power Automate when new item is created or existing modified

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

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'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?

This was exactly what I was looking for!

Thanks for the tutorial!!!! But do you know how to fix Failed to fetch error? I follow every step but this error shown.

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?

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!

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

Great video!

If I delete item from the list 1, the item in the list to Will be deleted too?

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!

Thank You very useful...

Thank you so much! I am trying to synchronize two sharepoint lists, and this video just saved my life!!!

what about when you have multiple filters

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.

Can you parameterize the List Name of the Update item step?

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.

Found it after multiple search, Thanks.

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 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!

Awesome video. it helped me solve my issue.

OMG THANK YOU SO MUCH I LOVE U

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.

Thank you

Thank you this video is quite informative . can u please make a video on delete operation also ?

Can somebody help: can I delete an item from the secondary list when deleting it from the source list?

good

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'.'"

IT WORKS!!!! ⭐️⭐️⭐️⭐️⭐️

Thanks Q

Fantastic, this is what I want to do. Thanks for sharing.

Nice video Prakash. Can you also please share with me the automatic ID generated link.

Hi Lernen Tech

Thank you for an extremely informative and time-saving series of videos. i am looking to use MS Forms, Power automate, Sharepoint and Office 365 (Excel) to create a searchable repository of PDF based reports which can be stored at a SharePoint location. Column Headings [metadata] in the form and hence the corresponding headings in SP are along the lines of :
Name, Certificate Number, Customer, Customer Purchase Order Number, Job Number, Valve Tag Number, Valve Type, Manufacturer, Model, Test Result

We have historically relied on Word based "Test Certificate Forms" which I am trying to re-design as a new business process.
could you please provide any pointers- i am happy to E-mail you or contact you on WhatsApp etc. [[email protected]]

thanks and regards
Uchit

Hi, I loved this video, however, whenever I edit an item, it just duplicates the updated version? Is there a way to fixed this?

Thank you for this video

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?

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?

This worked for a button flow to update an excel spreadsheet into a sharepoint list. Thanks

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

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

Thank you, very helpful

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”

Great video,,, need help if i want to compare multiple columns in filter array ? or how to compare multiple columns ?

Thank you.

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.

Can you do this if the Parent list needs to update/create several items in the child list?

Can I use the method from list to document library?

Can i use the same method form list to document library?