Though there is an option to create an item using the existing flow action, there are times that you need to create an item dynamically. Hence, this topic will tell you the best way to create an item using the ‘Send an HTTP Request to SharePoint’ action. In this example, we will be creating an item in a custom list.
To start, add the ‘Send an HTTP Request to SharePoint’ action in your flow.
Only three inputs are required in the action – Site Address, Method, and Uri. However, since we are creating an item, you will also need to provide the Headers and Body. Check below the simple descriptions and sample inputs for each field.
In the Site Address field, write the site address of the list where you want to create the item.
Because we want to create an item, we will be using POST method. POST request is a request method used to create / update data. It provides secure server communication.
Uri represents Uniform Resource Identifier. Here, we will provide the rest endpoint that we will be using to create an item. The Uri that we will be using is
/_api/web/lists/GetByTitle(‘<List Display Name>’)/Items
The Headers field is not required. However, it is very convenient when accessing and reading the response data. To create an item, we only need one header key – Content-Type.
In the Body of the request, we will be using a JSON.
How to build the JSON?
- Provide the internal name of the metadata and its value.
- Provide the metadata type of the item.
Refer to the example below:
"Title": "<title value here>",
"Description": "<description value here>"
For the metadata type value, take note that the value should be
SP.Data.<list internal name>ListItem. In this syntax you should take note that you need the
list internal name concatenated with ListItem. For example, I have a custom list which has the internal name Test, so the metadata type value should be
Now you are all set. For questions and clarifications, please write it as a comment below. Have a nice day!
AAD UserId Add-SPOTheme Apply Theme Content Type contentTypeHub CopyExcelRecordToList Create List Item Create list item using rest Current User Permission Custom Theme DenyAddAndCustomizePages ExcelPowerAutomate Expand External Users Flows isExternalGuestUser Library Views List Templates List Views Metadata Microsoft Flow O365 PageContext People People Metadata Permission PnP Power Automate PowerAutomate PowerShell React Rest API Rest Endpoint Save as Template Send an HTTP Request to SharePoint SharePoint SharePoint Color Theme SharePointList SharePoint Modern SharePoint Online SharePoint OOTB SharePoint PageContext SPFX SPO UserIsExternal