Simplify JSON Data Import to SharePoint list with Power Automate

hi everyone welcome back to another video in today's video I am going to demonstrate how we can send Json data to a SharePoint list I already recorded a video how we can send Json data to an Excel file based on uh viewers input they also wanted to see a video how we can move you know Json data to our SharePoint list so let's start it to understand the use case I have a employee list and based on the status of work status I want to move to another list inactive employees in my organization so I I want to move those employees to this list so how we can achieve this let me demonstrate click on create first we are going to retrieve data from this list I am using send an HTTP request to SharePoint provide the site address yes we are going to use this yay yep lists it but I don't know and uh display name of your list so let me copy it from here and items okay now let's quickly test it or floor and successfully and if I navigate to the output this is the Json data let me format it using visual studio this is the Json data we have formatted data so that we can understand it now we want to move this data to our SharePoint list now the next step is to filter out all the inactive employees search for filter array in from part it is looking for the array of object if I select this body this body is just providing the raw Json object the go back to my Json array object this is the entire Json array object what exactly filter array action is looking for is the results which is the array of objects so we need to pass this to do this we cannot use the body navigate to expression and write this expression click on OK now we have the correct required object from this object what I want I want to filter based on e based on the work status okay the work status is equal to inactive let me test it quickly so these are the employees with inactive status now now the next step is to iterate item one by one to do that click on apply to each and the input for apply to each will be previous output search for create action we use create item action to create a new item in a SharePoint list provide the required details like site address and the list name so for title title is the mandatory field of we don't have anything so just pass blank in employee name we need to pass the name of employee similarly for the Department go back here from item apartment so we have provided the information now let me test it our floor and successfully let me navigate to the inactive list so here are the employees with status inactive so this is how you can select data from a Json object and move that Json data to a SharePoint list also demonstrate how you can move data between two different lists thank you for watching please like And subscribe the channel if the video was useful feel free to comment below or Reach Out directly by using the mail ID for any business case or if you want a custom solution

Channel: Corporate Programming

Views: 5,709

Keywords: Save Data to SharePoint List from an External System API using Power Automate, Power Automate - How To Iterate JSON Data, Parse JSON objects in power automate and save data in Excel, How to save data to JSON file, How to read a .json file and insert the data into a SharePoint list?, Flow: Insert JSON into a Sharepoint, SharePoint branding, Power Automate connectors, Power Automate flow templates, Power Apps custom connector, SharePoint lists, RPA automation, SharePoint workflow

Id: d8DtIM0RmAE

Length: 7min 13sec (433 seconds)

Published: Thu Dec 22 2022