Add & Update a Secondary SharePoint list using Power Automate Flow

welcome back to channel everyone in this video i'm going to talk about how you can add an update item from one sharepoint list to another sharepoint list using powerautomate this video is specifically created when you are trying to actually update one master list from a different source list or you can say different child list and in that case how you can actually update item based on a specific internal id of that particular list item in our previous video i have achieved this using the id column we have into our sharepoint list but in this case we're going to use the internal identifier for that specific list item so let's just talk about that how we can do that this is my add an update source list and this is add an update destination list whenever i add new item here item should be created here and if i update any of the existing item an item should be updated here as well i'll go into my power automate try to create an instant flow name my flow as in update list item flow sharepoint when a item is created or modified will be a trigger point select the site address add an update source list next step will be will be first creating a create item action against site address here list name will be destination list once you have that as you can see title and source id which is our destinations column so this source id i have created a column as in single line of text so title will be our title and source id in this case will not be an id it will be an internal identifier of this particular list item so once we save this one we'll go to our source try to create new item say test four created will go to power automate wait for our flow to run flow ran successfully we'll go to our destination list as you can see the item has been created here as you can see the source id it is a combination of our source list name plus the id column id as well as some uh unique characters so it is an unique one and this is useful when you're trying to actually update a one master list from a different source list because in that case the default id column which we have will be duplicated but this will be a unique one i'll go to my power automate again we'll write an action for update item now so for that one get items it will bring it items not item select the list again and get item from which list from our destination list to actually compare whether the existing item that we're gonna update is already exist there or not so in our previous video i have discussed this one as well but here we are going to add one more step which is the filter query to actually get only that particular item which we're gonna update so how we're going to do that as you can see we have a column source id so in filter i'll write source id here equal colon source id equal to this source list item internal identifier which is this save and now next step is add a control here condition in the choose value go to expression write length and what we are checking using length is the get items value so why we are using that because this get item will return only one item because we are filtering we have applied a filter there once the filter return an item and if the length of that item is equal to zero that means we have to create an item if it is one that means we have to update and items right create item we have already created we'll just drag and drop it here and for update item we're going to write a command update item list name will be our destination list and here you can see the id column is there so which id we have to provide here and it's basically this get items id which is of this get items filter result the item we have we have to provide that id because we have to update that particular item and once you provide that id it's automatically put this into apply to h which is ok and now you can set the title so the title will be not the get items title it will be create item titles and same for the source id will be identifier of create item click save go to source list and try to update the one the latest we have created test for update it go to flow wait this flow to run a flow field it says bad request into our okay i think i did some mistakes here and to get items the filter should be inside the code the identifier data mistakes let's just save this one run the field one again now i can see it it's successful and it went to the fall state so it will update an item as you can see into my destination list it has updated the item the test 4 updated which we have mentioned so likewise if i create a items here like test 5 test six test seven i have created three item and we'll see into our destination list then florence for all these three items as you can see the destination list has these three new item also one things to remember uh as you can see i have created this test one two three before i have created the flow so these item are not here and in case i make any updates here in this particular test one updated it will create a new item for us in this particular list because it was previously not here so when you update it will create this as a new item and later on if you update this one it will update this one as well so that's the way you can actually uh add and update your secondary list using power automate i hope you like this video if you do like don't forget to subscribe learn tech thank you

Channel: Lernen Tech

Views: 15,334

Rating: 4.96875 out of 5

Keywords: microsoft flow update sharepoint list item, sharepoint update list item field value, sharepoint flow update item in another list, update sharepoint list item using flow, power automate update sharepoint item, power automate update sharepoint list, power automate get items filter query, flow sharepoint update item id, update secondary sharepoint list using flow, update sharepoint list using flow, sharepoint flow update column value, power automate update sharepoint list item

Id: kEkZXBMf6eo

Length: 9min 49sec (589 seconds)

Published: Fri Sep 04 2020