This Power Automate tutorial will teach us how to add item to SharePoint list using Power Automate. I will also show you, how to add items to a SharePoint list from Excel using Power Automate.
Add Items to SharePoint List using Power Automate
Let us see how to add an item to a SharePoint Online list using Power Automate or Microsoft Flow.
Make sure you create a SharePoint Online list having the below columns:
- EmpID
- EmpName
- Employee Status
Here I have created a SharePoint Online list known as EmployeeList and it looks like below:
- Now log in to Power Automate and go to + Create → Instant cloud flow and which triggers flow manually.
- Enter the flow name and click on create option.
Expand the trigger and text input by selecting Add an input option for the Employee ID, Employee Name, and Employee Status as shown below:
- Insert a new step and select the Create item action to create an item in a SharePoint list.
- Add dynamic content values for the Title, EmpName, and EmployeeStatus as below:
Save the flow and test it by selecting the Manually -> Test option. Enter the Employee ID, Employee Name and Employee Status details and click on the Run flow:
Our flow ran successfully, and an item will be created in the list.
Refresh the SharePoint list and see the new item has been added to the list using Power Automate.
This is how to add a new item to a SharePoint Online list using Power Automate. I have shown you how to add a new item to a SharePoint list using Power Automate.
Bulk add items to a SharePoint list using Power Automate
Here we will see how to add bulk items to a SharePoint Online list using Power Automate. Here, I will read csv file and add items to the sharepoint list in power automate.
In this example. we will add bulk items from the Excel Sheet to the SharePoint list using Flow.
To achieve this, Follow the below steps:
Step-1:
- Make Sure you have Excel table data with the file extension of .xlsx and the data values in the table format. So here I am going to use the below-displayed Sales data Excel sheet.
Step-2:
Before creating the flow, first, upload the Excel file to a SharePoint Online Document Library. Here I have uploaded the Excel file to the Documents document library of the SharePoint Online site.
Step-3:
- We will create a SharePoint list, with the same column name and data type that are similar to the Excel sheet.
SharePoint List Column Names | Respective Datatypes |
Product Code No | Default Title Column |
Product Name | Single Line Of Text |
Customer Name | Single Line Of Text |
Customer Location | Single Line Of Text |
Unit Price | Accounting |
Quantity | Number |
Order Date | Date |
Order Priority | Single Line Of Text |
Market Price | Accounting |
Step-4:
- Once the list has been created, Open Power Automate to create a flow.
- Log in to Power Automate and click Create -> choose Instant Cloud Flow that triggers flow manually.
Step-5:
- To list all the rows present in the Excel table, Select the action ‘List rows present in a table‘ -“Excel Online” from action triggers.
- Configure the required fields like Location, Document Library, file, and table as shown below:
- Location – Select the SharePoint site address
- Document Library – Choose document library
- file – In the file section, select the excel file
- table – choose the excel table value.
Step-6:
- We will initialize the variable and use it later in our flow for the Order Date Column Value.
- To initialize a variable, click on the next step then choose the ‘Initialize variable‘ action. Then provide the variable name and choose the type as String.
Step-7:
Now we will add Apply to each action to apply each output value of the “List rows present in a table”.
Add a new step and select the ‘set variable‘ action to set the values of each dates column presented in the Order Date Column.
- Now we will add three compose actions to take the input of the number column from the “List rows present in the table”, so later we will use the output in mapping.
- Unit Price
- Quantity
- Market Price
- Pass the dynamic content values as the inputs for the added compose actions.
- Now add a ‘Create item‘ action to map the data from the Excel sheet to the SharePoint Online list.
- Configure SharePoint Site Address and List Name. For the order date column, add the below expression.
addDays('1899-12-30',int(variables('VarOrderDate')),'yyyy-MM-dd')
And for the number column like Unit Price, Quantity, and Market Price, pass the output of the compose action.
Step-8:
Save and Test the flow manually.
Once your Flow ran successfully, we can see that bulk items have been added to the SharePoint list from the Excel file.
This is how to add bulk items to an existing SharePoint list using Power Automate.
Conclusion
We can easily create a Microsoft flow using Power Automate that will add items to the SharePoint Online list. Also, I have explained in detail, how to read an Excel file and add items to the SharePoint list in Power Automate.
With those steps, we can easily add bulk items to a SharePoint Online list using Power Automate.
You may also like the following Power Automate tutorials:
- Delete all rows from a SharePoint Online list using Power Automate
- Remove Duplicate items from SharePoint List using Power Automate
- Power Automate Apply to Each Current Item
- Parse JSON Object to Array in Power Automate
After working for more than 15 years in Microsoft technologies like SharePoint, Office 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (9 times). I have also worked in companies like HP, TCS, KPIT, etc.