How to Add Item to SharePoint list using Power Automate | Add Item to SharePoint List from Excel using Power Automate

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:

add item to sharepoint list using power automate
  • 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.
power automate add item to list

Expand the trigger and text input by selecting Add an input option for the Employee ID, Employee Name, and Employee Status as shown below:

power automate add item to sharepoint list
  • 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:
power automate add item to sharepoint online list

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:

power automate add new item to sharepoint list

Our flow ran successfully, and an item will be created in the list.

add items to a sharepoint list from power automate

Refresh the SharePoint list and see the new item has been added to the list using Power Automate.

power automate add item to sharepoint list

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.

See also  Power Bi Bar Chart - How to Create

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.
power automate add item to sharepoint list from excel

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.

power automate create item in sharepoint list from excel

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 NamesRespective Datatypes
Product Code No Default Title Column
Product NameSingle Line Of Text
Customer NameSingle Line Of Text
Customer LocationSingle Line Of Text
Unit PriceAccounting
QuantityNumber
Order DateDate
Order PrioritySingle Line Of Text
Market PriceAccounting
Sales Data List
Bulk add items to SharePoint list using the power automate flow

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.
read csv file and add item to sharepoint list in power automate

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.
power automate from excel to sharepoint list

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.
bulk add items to sharepoint list power automate

Step-7:

See also  5 Simple and Powerful Power BI dashboard examples

Now we will add Apply to each action to apply each output value of the “List rows present in a table”.

add bulk items to SharePoint list using power automate flow

Add a new step and select the ‘set variable‘ action to set the values of each dates column presented in the Order Date Column.

power automate create item in sharepoint list from excel
  • 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.
bulk add items to sharepoint list power automate
  • 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.

power automate bulk create sharepoint list items

Step-8:

Save and Test the flow manually.

read csv file and add item to sharepoint list in power automate

Once your Flow ran successfully, we can see that bulk items have been added to the SharePoint list from the Excel file.

power automate from excel to sharepoint list

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.

See also  How to check if an array contains value using Power Automate?

You may also like the following Power Automate tutorials:

>