Add & Update Excel Table Row from SharePoint List | Power Automate Tutorial

welcome back to channel everyone in this video we're gonna talk about how you can add and update your sharepoint list data to excel sheet using power automate this is my excel table which i have created into my sharepoint online document library with the name of import where we have excel sheet as in excel data and i have formatted this as a table before doing that which is mandatory one and then we have our sharepoint list with the name of source where we have a couple of rows added already so what i want when i add a new item to my sharepoint list or update any of the existing item it will either create a new entry or update the existing entry to my excel sheet in case i update my first item so let's suppose i change user name from employee to employee one and save this one then a flow will run in background and it will check if this item already exist into my excel sheet or not if not then it will create a new item and if it is already exist then it will update that one likewise i'm going to update one more item which is employed to i'll say employee double two and i think one more which is employee three and i'll exit from my grid view as you can see there is one item has been created into my excel sheet because this item was not previously here important thing to note is that how it is doing based on this id column as you can see there is two more column added i have updated three item and it has created three new entries here so let's just talk about how we can do this as well first of all i'll clean this up i'll say delete table rows now my actual is blank i will create automated cloud flow and the trigger point will be when an item is created or modified into sharepoint and the flow name will be add an update excel table all right i have to select my site address so my site name is dev site which is this one and the list name is source list right this one i've already selected this one so when there is item created or modified into this particular list my flow will trigger next point i'll say excel online for business and the list representing table so i'm getting all these rules presented into this particular table so how we're going to find this one is this is also under my dive site and document library as i told you there is a import document library all right and file name is with the excel data dot xls and table name is table 1 which i have created creating table is mandatory so before doing that create or format your column as in table next step will be our filter array and uh from value will be from our list represent table value what we're going to do here is we're going to select the unique identifier into my excel table and then compare this with the unique identifier of my sharepoint list item id which is the default id of every sharepoint list item so what this filter will do it will filter one value from this excel table where this excel id is equal to my sharepoint list item id that's it so in this case this id will not work for you because this id column is a number and this formula particularly except and a string so in that case what we have to do when you hover this id you can see trigger outputs closed bracket question mark body slash id right so we have to convert that into my string and i can pass that value i've already copied that the second one all right i'll put this into my description as well click ok so it will filter only one value at a time and if it doesn't produce any of the value then we'll put our next conditions here so what we're going to do is control condition when you click on this choose you will have a filter area item or filter array body so we have to pick filter at your body when you click on this one you will see body filter array right i have written this into my text already body filter array so what we have to do is empty paste that body filter array click ok is either true or false you can put any value so i'll say true that means if this filter array returns a value and then it will check whether it is empty or not so if it is empty that means we have to create a new item that means the item already doesn't exist into my excel so i have to create a new item and if it is not true then i have to update and yes i'll choose x and online business and add a row into table location will be my dev site because it is my under my sharepoint site document library we know that it is import file name we know as well excel data.xls and the table name we know as table1 so it will automatically create the list of column that i have here as you can see and i have to map them one by one so i have to map them with sharepoint item so id will be sharepoint item id username will be sharepoint username status will be sharepoint status experience will be sharepoint experience and then joining date will be my sharepoint joining date all right this is it and if no then i have to update item so excel online for business update row perform the same step location will be again our dev site document library will be import file will be excel data dot xls table will be table one and now there is two more columns when we are doing the updates the key column and the key value column so it is smart enough what is asking where you are updating please identify a unique column so in our case it is id1 so we're going to choose key column will be our excel id and the value i want to put into that particular one is my sharepoint item id and then you can update your rest of the column as it is save your flow and we are good to go i'll go into my shipment list and into my excel sheet excel sheet is blank as of now so if i make any changes to any of the item as of now it should create an item so i'm making changes to my first item which is this one and i'm saying this employable one and let's save this our flow started running so we'll wait here you can see there is a new item has been created here so i'm going to update rest of my items so that it can create them first all right then this one and then say this employee 4 then add employee 5 and now i'm going to exit grid view now you can see all the five item has been created here so the next step what i'm going to do is i'm going to update some of these item and then we'll see whether our excel get updated or not so what i'll do is i'll update some of these item so this double one i'm gonna make this as in one experience will be 20 now and make this open change the date as well so i'm going to make this save update one more item so i'm updating 16 and 18 employed double three experience 20 save this one as well so i have updated two item and i'm adding one more item which is like title is nothing username is employ 6 department sharepoint state is open experience 30 joining data anything's and then save and i've added new item with id 1924 we'll go to our flow and we'll see that there has been 43 seconds ago 43 seconds ago so that means update has been started one and double three has been updated 16 and 18 one status has been changed the data has been changed experience has been changed and now we can see there is one more item has been added with d1924 so these five were already presented and this new has been added as well 1924 is there so this is the way you can actually update your sharepoint list item to excel table using power automate i hope you like this video if you do don't forget to subscribe our channel thank you so much for watching have a good day

Channel: Lernen Tech

Views: 85,712

Keywords: power automate sharepoint list to excel, update a row excel microsoft flow, power automate update excel cell, power automate update excel row, power automate update excel table, power automate update excel, power automate update excel file, power automate excel add row, power automate add row to excel, add and update sharepoint list data to excel, update excel from sharepoint list automatically, export sharepoint list to excel, update excel from sharepoint list using flow

Id: xwvLGbyhssI

Length: 12min 37sec (757 seconds)

Published: Mon Jan 11 2021