While developing a client requirement, I struggled to create items manually in a SharePoint list because I wanted large data sets. After researching, I found that we can create a single or multiple items in a SharePoint list using Power Automate.
In this article, I will tell you how to create SharePoint list items using Power Automate in three ways. Such as:
- Create a SharePoint list item using Power Automate by giving user input values [With manual flow]
- Create multiple SharePoint list items from Excel using Power Automate
- Create SharePoint list item using Power Automate based on conditions
Create a SharePoint list item using Power Automate [By Providing User Input Values]
Using Power Automate with user inputs, let’s understand how to create a SharePoint list item.
I have a SharePoint list named [Project Information] with a couple of columns, as shown in the screenshot below:
| Column | Data type |
|---|---|
| Project Title | Single line of Text [Default Title] |
| Category | Choice |
| Budget Cost | Currency |
| Assigned To | Person or Group column |
| Start Date | Date and Time |
| End Date | Date and Time |
| Active | Yes/No |
Follow the steps below:
1. Open the Power Automate Home page and choose Instant cloud flow with trigger Manually trigger a flow.
- Click on +Add an Input to include the parameters matching the columns in the SharePoint list [Project Information].
The table below will show you the parameters that should be added to the trigger:
| Input Name | Input Type |
| Project Title | Text |
| Active? | Yes/No |
| Budget Cost | Number |
| Start Date | Date and Time |
| End Date | Date and Time |
| Category | Text |
| Assigned To | Text |
![and the Product Quantity is less than 100 -> Create an item in the SharePoint list [Products Re-stock List].](https://www.enjoysharepoint.com/wp-content/uploads/2025/03/How-to-create-SharePoint-item-using-Power-Automate-1-1024x241.jpg "How to create SharePoint item using Power Automate 1")
2. To add a SharePoint list item, take the Create Item action from the SharePoint connector.
Set the Site Address and List Name.
Configure the required parameters:
| Parameters | Value |
| Project Title Budget Cost Start Date End Date Active? Category Assigned To | Select values from the dynamic content of a trigger. |
Now, click on Save and Test the flow.
3. In the Run flow window, provide values for all the input parameters. Then, click on the Run flow button.
In the image below, I have provided values for all the parameters.
Important:
When running the flow, the flow will only use SharePoint and Office 365 users. For example: In the Assigned To column it will add the persons diaplay name coming from Office365. The flow generates error, when we take external users.
4. When the flow runs successfully, an item will get added to the SharePoint list [Project Information].
Refer to the image below:
This way, we can add a SharePoint list item by giving user input values in the Power Automate flow.
Create Multiple SharePoint List Items From Excel Using Power Automate
I will show you how to create various SharePoint list items from Excel using Power Automate.
In this example, I will use the SharePoint list [Employee Details], which has the columns and their data types represented below.
| Column Name | Data Type |
|---|---|
| Employee ID | Single line of text [Title] |
| Employee Name | Single line of text |
| Joining Date | Date and Time |
| Department | Choice |
| Permanent Address | Multiple lines of text |
| PF Included? | Yes/No |
I have an Excel sheet with the listed data [Employee Details]:
Follow the steps below:
1. In the Power Automate, add an Instant cloud flow -> Choose Manually trigger a flow.
2. Add the List rows present in a table action. Provide the parameters like Location, Document Library, File, and Table.
- DateTime Format: Select ISO8601 from the drop-down.
3. In the next step, add a Create item action. Configure the Site Address and List Name.
Click on Show all to display the Advanced parameters.
| Column Name | Value |
|---|---|
| Title Employee Name Joining Date Permanent Address | Choose the value of dynamic content from Excel |
| PF Included? | if(equals(item()?[‘PF Included’],’Yes’),true,false) |
| Department Value | item()?[‘Department ‘] |
For each loop will be added automatically, I have renamed it to For each – Create Item.
4. Now, click on the Save button. Test the flow. Now, the flow triggers and starts running.
5. When the flow runs successfully, go back to the SharePoint list and refresh it.
Then, the SharePoint list items will appear, as shown in the image below:
This is how to create multiple items in the SharePoint list using Power Automate.
Create SharePoint List Items Using Power Automate Based On Conditions
I have two SharePoint lists called [Products List] and [Products Re-stock List].
When a product in my [Products List] is marked as “Unavailable” and has fewer than 100 items left, the system will automatically create a new item in my [Products Re-stock List].
SharePoint List – 1: [Products]
| Column Name | Data Type |
| Product ID | Single line of text |
| Product Name | Single line of text |
| Product Brand | Choice |
| Product Price | Number |
| Product Availability | Choice |
| Product Quantity | Number |
SharePoint List – 2: [Products Re-Stock List]
| Column Name | Data Type |
| Product Code | Single line of text |
| Product Name | Single line of text |
| Product Availability | Choice |
| Product Quantity | Number |
Products Re-Stock List Image:
Follow the steps below:
1. On the Power Automate Home page, select Automated cloud flow and choose the When an item is created or modified trigger.
Inside the trigger, set the properties like Site Address and List Name.
2. Then, add a Condition control to compare the values provided in the SharePoint list.
| Choose Value | Operator | Choose Value |
| Product Availability Value | is equal to | Unavailable |
| Product Quantity | is less than | 100 |
3. Under the True branch, add a Create item action. Set the required properties:
- Site Address: Choose the SharePoint site from the drop-down.
- List Name: Select the list from the drop-down options.
Click on the Show all button to display the Advanced parameters.
| Column Name | Data Type |
| Product ID Product Name Product Availability Product Quantity | Select values from dynamic content of a trigger |
Once the flow is ready, save and test it manually.
4. Go back to the SharePoint list and add a new item, as shown in the screenshot below.
5. If the condition is satisfied, it will create an item in the SharePoint list [Products Re-Stock List].
Refer to the image placed below:
This is how to create a SharePoint list item based on condition using Power Automate.
Conclusion
I hope this tutorial helped you understand how to create an item in a SharePoint list by giving user input values and how to create multiple SharePoint list items from Excel.
Also, I have covered creating an item in another SharePoint list based on condition using Power Automate.
You may also visit the following tutorials:
- Create an Excel File from SharePoint list Items using Power Automate
- Validate Dates in SharePoint to Choose WeekEnds
- Create an Array From SharePoint List Items Using Power Automate
- Create an Excel File When an Item is Created in SharePoint List Using Power Automate
- Get File Content Using Path in Power Automate
- Update SharePoint List Items Based On Condition Using Power Automate
After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 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 (12 times). I have also worked in companies like HP, TCS, KPIT, etc.
