{"id":75226,"date":"2023-09-21T13:36:55","date_gmt":"2023-09-21T17:36:55","guid":{"rendered":"https:\/\/www.spguides.com\/?p=75226"},"modified":"2023-10-08T02:40:43","modified_gmt":"2023-10-08T06:40:43","slug":"create-and-delete-an-item-from-a-sharepoint-list-using-power-automate-desktop","status":"publish","type":"post","link":"https:\/\/www.spguides.com\/create-and-delete-an-item-from-a-sharepoint-list-using-power-automate-desktop\/","title":{"rendered":"How to Create and Delete an Item from a SharePoint List using Power Automate Desktop?"},"content":{"rendered":"\n<p>This Power Automate Desktop tutorial will show us how to <strong>create an item in a SharePoint list using Power Automate Desktop<\/strong>. Also, we will see how to <strong>delete an item from the SharePoint list using Power Automate Desktop<\/strong>.<\/p>\n\n\n\n<p>Now, let&#8217;s see an example of how to create an item in the SharePoint list using Power Automate Desktop.<\/p>\n\n\n\n<p>For example, in Power Automate Desktop, we have a custom form that contains the below columns and collects the information related to the product:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Id-Text<\/li>\n\n\n\n<li>Name- Text<\/li>\n\n\n\n<li>Description-Text(Multi-line)<\/li>\n\n\n\n<li>Price-Number<\/li>\n\n\n\n<li>Quantity-Number<\/li>\n\n\n\n<li>Testimonial-File type<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"633\" height=\"643\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/MS-Power-automate-Desktop-delete-item-in-SharePoint-Online-list.jpg\" alt=\"MS Power automate Desktop delete item in SharePoint Online list\" class=\"wp-image-75849\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/MS-Power-automate-Desktop-delete-item-in-SharePoint-Online-list.jpg 633w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/MS-Power-automate-Desktop-delete-item-in-SharePoint-Online-list-295x300.jpg 295w\" sizes=\"(max-width: 633px) 100vw, 633px\" \/><\/figure><\/div>\n\n\n<p>Once we fill out the form and click the Submit button, the item is created in the Product Details SharePoint list. Also, we will add the attachment to that particular item.<\/p>\n\n\n\n<p>So, this SharePoint list &#8216;Product Details&#8217; contains the below columns:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Title-Single line of text<\/li>\n\n\n\n<li>Name- Single line of text<\/li>\n\n\n\n<li>Description-Multiple lines of text<\/li>\n\n\n\n<li>Price- Currency<\/li>\n\n\n\n<li>Quantity- Number<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"230\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-create-item-in-SharePoint-list-1024x230.jpg\" alt=\"Power automate Desktop create item in SharePoint list\" class=\"wp-image-75781\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-create-item-in-SharePoint-list-1024x230.jpg 1024w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-create-item-in-SharePoint-list-300x67.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-create-item-in-SharePoint-list-768x172.jpg 768w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-create-item-in-SharePoint-list.jpg 1403w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_69_1 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.spguides.com\/create-and-delete-an-item-from-a-sharepoint-list-using-power-automate-desktop\/#Create_an_item_in_a_SharePoint_list_using_Power_Automate_Desktop\" title=\"Create an item in a SharePoint list using Power Automate Desktop\">Create an item in a SharePoint list using Power Automate Desktop<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.spguides.com\/create-and-delete-an-item-from-a-sharepoint-list-using-power-automate-desktop\/#Delete_an_item_from_the_SharePoint_list_using_Power_Automate_Desktop\" title=\"Delete an item from the SharePoint list using Power Automate Desktop\">Delete an item from the SharePoint list using Power Automate Desktop<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.spguides.com\/create-and-delete-an-item-from-a-sharepoint-list-using-power-automate-desktop\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Create_an_item_in_a_SharePoint_list_using_Power_Automate_Desktop\"><\/span>Create an item in a SharePoint list using Power Automate Desktop<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here, we will see how to create an item in the SharePoint list using Power Automate Desktop.<\/p>\n\n\n\n<p>Before creating the desktop flow, set the SharePoint Online List with the above-defined columns.<\/p>\n\n\n\n<p><strong>Step 1:<\/strong> Open Power Automate Desktop, provide the Flow name, and click the <strong>Create<\/strong> button.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1024\" height=\"650\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/How-to-create-item-in-SharePoint-Online-list-using-MS-Power-automate-Desktop-1024x650.jpg\" alt=\"How to create item in SharePoint Online list using MS Power automate Desktop\" class=\"wp-image-75850\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/How-to-create-item-in-SharePoint-Online-list-using-MS-Power-automate-Desktop-1024x650.jpg 1024w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/How-to-create-item-in-SharePoint-Online-list-using-MS-Power-automate-Desktop-300x191.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/How-to-create-item-in-SharePoint-Online-list-using-MS-Power-automate-Desktop-768x488.jpg 768w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/How-to-create-item-in-SharePoint-Online-list-using-MS-Power-automate-Desktop.jpg 1107w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 2:<\/strong> We will create a custom form in Power Automate Desktop. For this, expand the Display message section, drag and drop the Display Custom form action, and then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Select the Custom Form Designer button.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"770\" height=\"518\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-create-item-in-SharePoint-Online-list.jpg\" alt=\"Microsoft Power automate Desktop create item in SharePoint Online list\" class=\"wp-image-75817\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-create-item-in-SharePoint-Online-list.jpg 770w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-create-item-in-SharePoint-Online-list-300x202.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-create-item-in-SharePoint-Online-list-768x517.jpg 768w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/figure><\/div>\n\n\n<p>Then provide the Form name on the right-hand side under the Title section.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Next, we will create the First field i.e. Id field, so, drag and drop the Text field to the designer area.<\/li>\n\n\n\n<li>Then on the right side provide the field name and label that will be displayed in the form.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"514\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/MS-Power-automate-Desktop-create-item-in-SharePoint-list-1024x514.jpg\" alt=\"MS Power automate Desktop create item in SharePoint list\" class=\"wp-image-75824\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/MS-Power-automate-Desktop-create-item-in-SharePoint-list-1024x514.jpg 1024w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/MS-Power-automate-Desktop-create-item-in-SharePoint-list-300x151.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/MS-Power-automate-Desktop-create-item-in-SharePoint-list-768x386.jpg 768w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/MS-Power-automate-Desktop-create-item-in-SharePoint-list.jpg 1051w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>Similarly, add the rest of the field i.e. Name, Description, Price, and Quantity field. Drag and drop the File Input Field to the Designer area to add the Testimonial field. <\/p>\n\n\n\n<p>Now, you can change the Field name and Label on the right-hand side of the window. Now you can preview the Form after adding the fields to the form. It looks like below:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"763\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Power-automate-Desktop-create-item-in-SharePoint-Online-list-1024x763.jpg\" alt=\"Using Power automate Desktop create item in SharePoint Online list\" class=\"wp-image-75826\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Power-automate-Desktop-create-item-in-SharePoint-Online-list-1024x763.jpg 1024w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Power-automate-Desktop-create-item-in-SharePoint-Online-list-300x224.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Power-automate-Desktop-create-item-in-SharePoint-Online-list-768x572.jpg 768w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Power-automate-Desktop-create-item-in-SharePoint-Online-list.jpg 1257w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>Next, we will add the Submit button so we can submit the form and add the output data. For this drag and drop the Submit action, then provide the ID as Submit and Title as Done.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"770\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-create-item-in-SharePoint-list-1024x770.jpg\" alt=\"Power automate desktop create item in SharePoint list\" class=\"wp-image-75818\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-create-item-in-SharePoint-list-1024x770.jpg 1024w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-create-item-in-SharePoint-list-300x226.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-create-item-in-SharePoint-list-768x578.jpg 768w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-create-item-in-SharePoint-list.jpg 1272w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Step 3:<\/strong> Now, we will create an item in the SharePoint list; for this, drag and drop the Create Item action. Then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Site address: Select SharePoint site address.<\/li>\n\n\n\n<li>List name: Select the List name as Product Details<\/li>\n\n\n\n<li>Title:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>%CustomFormData.Id%<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Name:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>%CustomFormData.Name%<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Description:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>%CustomFormData.Description%<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Price:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>%CustomFormData.Price%<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Quantity:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>%CustomFormData.Quantity%<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"770\" height=\"728\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-MS-Power-automate-Desktop-create-item-in-SharePoint-Online-list.jpg\" alt=\"Using MS Power automate Desktop create item in SharePoint Online list\" class=\"wp-image-75829\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-MS-Power-automate-Desktop-create-item-in-SharePoint-Online-list.jpg 770w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-MS-Power-automate-Desktop-create-item-in-SharePoint-Online-list-300x284.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-MS-Power-automate-Desktop-create-item-in-SharePoint-Online-list-768x726.jpg 768w\" sizes=\"(max-width: 770px) 100vw, 770px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 4:<\/strong> We need to convert the file to binary to add attachments to the SharePoint list item. Drag and drop the &#8216;Convert File to binary&#8217; action for this. Then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>File path: Provide the below argument:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>%CustomFormData.Testimonial%<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"766\" height=\"518\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-create-item-in-SharePoint-Online-list.jpg\" alt=\"Using Microsoft Power automate Desktop create item in SharePoint Online list\" class=\"wp-image-75830\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-create-item-in-SharePoint-Online-list.jpg 766w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-create-item-in-SharePoint-Online-list-300x203.jpg 300w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 5:<\/strong> Now, we will add an attachment to the SharePoint list; for this, drag and drop the Add attachment action to the canvas. Then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Site address: Select the SharePoint site address<\/li>\n\n\n\n<li>List name: Provide the list name<\/li>\n\n\n\n<li>Id: Provide the below argument<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>%PostItemResponse.ID%<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>File name: Provide the file name.<\/li>\n\n\n\n<li>File content: Click on variable icon {x}, select the &#8216;Binary Data&#8217; variable, and click on Select.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"772\" height=\"522\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-create-item-in-SharePoint-list.jpg\" alt=\"Using Microsoft Power automate Desktop create item in SharePoint list\" class=\"wp-image-75833\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-create-item-in-SharePoint-list.jpg 772w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-create-item-in-SharePoint-list-300x203.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-create-item-in-SharePoint-list-768x519.jpg 768w\" sizes=\"(max-width: 772px) 100vw, 772px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 6:<\/strong> Now run the flow by clicking on the run button. Fill out the form and click on the &#8216;Done&#8217; button. Once the flow runs successfully, you can see the item added successfully to the SharePoint list.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"284\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-create-item-in-SharePoint-Online-list-1024x284.jpg\" alt=\"Power automate Desktop create item in SharePoint Online list\" class=\"wp-image-75792\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-create-item-in-SharePoint-Online-list-1024x284.jpg 1024w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-create-item-in-SharePoint-Online-list-300x83.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-create-item-in-SharePoint-Online-list-768x213.jpg 768w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-create-item-in-SharePoint-Online-list-1536x426.jpg 1536w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-create-item-in-SharePoint-Online-list.jpg 1812w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>This is how to create items in the SharePoint list using Power Automate Desktop.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Delete_an_item_from_the_SharePoint_list_using_Power_Automate_Desktop\"><\/span>Delete an item from the SharePoint list using Power Automate Desktop<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here, we will see how to delete an item from the SharePoint list using Power Automate Desktop.<\/p>\n\n\n\n<p>For this example, i will use the same Product Details SharePoint list, and I will create a desktop flow that will get all the items from the SharePoint list and check the quantity of the item. If the quantity is equal to 0, then we will delete the item from the SharePoint list.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"309\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-delete-item-in-SharePoint-Online-list-1024x309.jpg\" alt=\"Power automate Desktop delete item in SharePoint Online list\" class=\"wp-image-75847\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-delete-item-in-SharePoint-Online-list-1024x309.jpg 1024w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-delete-item-in-SharePoint-Online-list-300x91.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-delete-item-in-SharePoint-Online-list-768x232.jpg 768w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Power-automate-Desktop-delete-item-in-SharePoint-Online-list.jpg 1358w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 1:<\/strong> Open Power Automate Desktop, click on the +New flow -&gt; then provide the flow name and click on the <strong>Create<\/strong> button.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"652\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/How-to-delete-item-in-SharePoint-Online-list-using-MS-Power-automate-Desktop-1024x652.jpg\" alt=\"How to delete item in SharePoint Online list using MS Power automate Desktop\" class=\"wp-image-75851\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/How-to-delete-item-in-SharePoint-Online-list-using-MS-Power-automate-Desktop-1024x652.jpg 1024w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/How-to-delete-item-in-SharePoint-Online-list-using-MS-Power-automate-Desktop-300x191.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/How-to-delete-item-in-SharePoint-Online-list-using-MS-Power-automate-Desktop-768x489.jpg 768w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/How-to-delete-item-in-SharePoint-Online-list-using-MS-Power-automate-Desktop.jpg 1127w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 2:<\/strong> We will get items from the SharePoint list using Power Automate Desktop. For this, drag and drop the &#8216;Get items&#8217; action. Then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Site address: Select the Site address from the dropdown.<\/li>\n\n\n\n<li>List name: Select the list name from the drop-down.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"762\" height=\"512\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-Online-list.jpg\" alt=\"Using Microsoft Power automate Desktop delete item in SharePoint Online list\" class=\"wp-image-75841\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-Online-list.jpg 762w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-Online-list-300x202.jpg 300w\" sizes=\"(max-width: 762px) 100vw, 762px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 3:<\/strong> We will parse the JSON output of the last step, so drag and drop the &#8216;Convert JSON to custom object&#8217; action to canvas. Then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>JSON: Click on the variable icon {x}, and select the &#8216;GetItemResponse&#8217; variable.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"771\" height=\"520\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-MS-Power-automate-Desktop-delete-item-in-SharePoint-Online-list.jpg\" alt=\"Using MS Power automate Desktop delete item in SharePoint Online list\" class=\"wp-image-75843\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-MS-Power-automate-Desktop-delete-item-in-SharePoint-Online-list.jpg 771w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-MS-Power-automate-Desktop-delete-item-in-SharePoint-Online-list-300x202.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-MS-Power-automate-Desktop-delete-item-in-SharePoint-Online-list-768x518.jpg 768w\" sizes=\"(max-width: 771px) 100vw, 771px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 4:<\/strong> Now, we will loop through the SharePoint items from the list. So drag and drop the &#8216;For each&#8217; action to the canvas. Then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Value to iterate: Provide the below argument:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>%JsonAsCustomObject.value%<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"767\" height=\"402\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-MS-Power-automate-Desktop-delete-item-in-SharePoint-list.jpg\" alt=\"Using MS Power automate Desktop delete item in SharePoint list\" class=\"wp-image-75845\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-MS-Power-automate-Desktop-delete-item-in-SharePoint-list.jpg 767w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-MS-Power-automate-Desktop-delete-item-in-SharePoint-list-300x157.jpg 300w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 5:<\/strong> Next, we will check that the Quantity is equal to 0, then delete that particular item. For this drag and drop the IF condition action to canvas. Then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First Operand: Provide the first operand as:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>%CurrentItem.Quantity%<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Operator: Select the operator as &#8216;equal to&#8217; from the options.<\/li>\n\n\n\n<li>Second Operand: Provide the Second operand as 0.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"762\" height=\"541\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Power-automate-Desktop-delete-item-in-SharePoint-Online-list.jpg\" alt=\"Using Power automate Desktop delete item in SharePoint Online list\" class=\"wp-image-75846\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Power-automate-Desktop-delete-item-in-SharePoint-Online-list.jpg 762w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Power-automate-Desktop-delete-item-in-SharePoint-Online-list-300x213.jpg 300w\" sizes=\"(max-width: 762px) 100vw, 762px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 6:<\/strong> Now we will delete items in the SharePoint list, for this, drag and drop the Delete item action to canvas. Then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Site address: Select the SharePoint site address<\/li>\n\n\n\n<li>List name: Select the list name from dropdown<\/li>\n\n\n\n<li>Id: Provide the Id as below argument:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>%CurrentItem.ID%<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"772\" height=\"519\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-list.jpg\" alt=\"Using Microsoft Power automate Desktop delete item in SharePoint list\" class=\"wp-image-75837\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-list.jpg 772w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-list-300x202.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Using-Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-list-768x516.jpg 768w\" sizes=\"(max-width: 772px) 100vw, 772px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 7:<\/strong> Now run the flow by clicking on the run button. Once the flow runs successfully, you can see the item is deleted whose quantity =0.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-Online-list-1024x230.jpg\" alt=\"Microsoft Power automate Desktop delete item in SharePoint Online list\" class=\"wp-image-75848\" style=\"width:945px;height:212px\" width=\"945\" height=\"212\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-Online-list-1024x230.jpg 1024w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-Online-list-300x67.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-Online-list-768x173.jpg 768w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Microsoft-Power-automate-Desktop-delete-item-in-SharePoint-Online-list.jpg 1406w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/figure><\/div>\n\n\n<p>This is how to delete a SharePoint list item using Power Automate Desktop.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this Power Automate Desktop tutorial, we saw how to <strong>create an item in a SharePoint list using Power Automate Desktop<\/strong>. Also, we saw how to <strong>delete items from a SharePoint list using Power Automate Desktop<\/strong>.<\/p>\n\n\n\n<p>You may also like the following tutorials:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.spguides.com\/get-items-from-sharepoint-list-using-power-automate-desktop\/\">Get items from SharePoint List using Power Automate Desktop<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.spguides.com\/create-file-in-sharepoint-using-power-automate-desktop\/\">Create File in SharePoint using Power Automate Desktop<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.spguides.com\/get-an-item-from-a-list-using-power-automate-desktop\/\">How to get an item from a list using Power Automate Desktop?<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This Power Automate Desktop tutorial will show us how to create an item in a SharePoint list using Power Automate Desktop. Also, we will see how to delete an item from the SharePoint list using Power Automate Desktop. Now, let&#8217;s see an example of how to create an item in the SharePoint list using Power &#8230; <a title=\"How to Create and Delete an Item from a SharePoint List using Power Automate Desktop?\" class=\"read-more\" href=\"https:\/\/www.spguides.com\/create-and-delete-an-item-from-a-sharepoint-list-using-power-automate-desktop\/\" aria-label=\"Read more about How to Create and Delete an Item from a SharePoint List using Power Automate Desktop?\">read more&#8230;<\/a><\/p>\n","protected":false},"author":2,"featured_media":78383,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"ub_ctt_via":"","footnotes":""},"categories":[210],"tags":[3042],"class_list":["post-75226","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-automate","tag-create-and-delete-an-item-from-a-sharepoint-list-using-power-automate-desktop","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50"],"featured_image_src":"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Create-and-Delete-an-Item-from-a-SharePoint-List-using-Power-Automate-Desktop.jpg","author_info":{"display_name":"Bijay Kumar","author_link":"https:\/\/www.spguides.com\/author\/fewlines4biju\/"},"jetpack_featured_media_url":"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/09\/Create-and-Delete-an-Item-from-a-SharePoint-List-using-Power-Automate-Desktop.jpg","_links":{"self":[{"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/posts\/75226"}],"collection":[{"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/comments?post=75226"}],"version-history":[{"count":4,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/posts\/75226\/revisions"}],"predecessor-version":[{"id":76258,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/posts\/75226\/revisions\/76258"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/media\/78383"}],"wp:attachment":[{"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/media?parent=75226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/categories?post=75226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/tags?post=75226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}