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.
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! 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.
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.
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?
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
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 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 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?
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
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
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.
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.
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.
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”
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
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
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 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 .
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.
@@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.
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'.'"
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.
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.
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! I am trying to synchronize two sharepoint lists, and this video just saved my life!!!
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!
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 this video is quite informative . can u please make a video on delete operation also ?
Found it after multiple search, Thanks.
This worked for a button flow to update an excel spreadsheet into a sharepoint list. Thanks
You're welcome!
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.
This was exactly what I was looking for!
Thank you so much Teacher.. you are the best ever :)
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?
Awesome video. it helped me solve my issue.
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?
Great video!
If I delete item from the list 1, the item in the list to Will be deleted too?
Thank You very useful...
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
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 for help sir
Fantastic, this is what I want to do. Thanks for sharing.
Have fun!
Nice video! Thanks for this!!
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
Thanks for the tutorial!!!! But do you know how to fix Failed to fetch error? I follow every step but this error shown.
OMG THANK YOU SO MUCH I LOVE U
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/
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
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
Thank you for this 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?
Thank you, very helpful
Glad it was helpful!
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
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.
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.
IT WORKS!!!! ⭐️⭐️⭐️⭐️⭐️
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
Can I use the the same method from list to document library?
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
Thank you.
You're welcome!
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..
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/
Can you parameterize the List Name of the Update item step?
Can somebody help: can I delete an item from the secondary list when deleting it from the source list?
Can you do this if the Parent list needs to update/create several items in the child list?
ok
what about when you have multiple filters
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 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, 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
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.
good
If i have dynamic data with People Column it fails!
Thanks Q
Any time
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
It doesn't work :( Can someone help me please?
Can i use the same method form list to document library?
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.