Power Automate: Useful HTTP Request Actions Part 4

 Hello Friends,

Welcome back with another post on Power Automate. This post is in continuation to one of my earlier post(s) on different ways we can use HTTP request action (Send an HTTP request to SharePoint) in Power Automate to get different kind of information. I will be adding more and more options in this post from time to time. Below is the link of earlier post(s)-

1. Power Automate: Useful HTTP Request Actions Part 1
   
2. Power Automate: Useful HTTP Request Actions Part 2
   
3. Power Automate: Useful HTTP Request Actions Part 3
   

Today, we will learn about below ones-

1. Create SharePoint List
2. Create Column(s)
3. Update Column(s) Display Name
4. Read Excel And Insert Data

Sometimes, there is a requirement to read an uploaded excel and create List for that in SharePoint and insert items in that list. So, either you need to do this activity manually OR you can use Power Automate to achieve the same. We are discussing Power Automate option here.

1. Our process will divide into following steps-
1. Create SharePoint List
2. Create/Rename Columns In List
3. Read Excel from Document Library
4. Add Items from Excel into SharePoint list

Let's start-

1. Create SharePoint List-
1. First we will create custom SharePoint list named "SharePointListTemplateIDs" using Power Automate.
2. Add an action "Send HTTP request to SharePoint".
3. 
4. The Body template used is-

5. {
   
   	"__metadata":{ "type":"SP.List" },
   	"AllowContentTypes":true,
   	"BaseTemplate":100,
   	"Title":"SharePointListTemplateIDs",
   
   	"Description":"This list contains the IDs of different types of lists/libraries we can create."
   
   }
   

6. BaseTemplate is the Id that represents to a  List type. 100 is for Custom list. Rest are as below-
7. 
8. This will create list in SharePoint.
2. Create/Rename Columns In List-
1. We will create/rename below columns-
1. Name: (We will not be creating this column. We will use Title Column and will rename it to Name)
2. TemplateID: (Type: Number; Required: true) 
3. Description: (Type: Text (Multiline); Required: false)
2. For this, we will follow below steps-
1. Rename "Title" to "Name"
2. Create "TemplateID"
3. Rename "TemplateID" to "Template ID"
4. Create "Description"
3. Inputs are-
1. Rename "Title" to "Name"
1. 
2. Create "TemplateID"
1. 
3. Rename "TemplateID" to "Template ID"
1. 
4. Create "Description"
1. 
   
   
3. Read Excel from Document Library-
1. Now we will read the Excel file. We had uploaded the file in Documents library. This file contains the Name/TemplateID/Description columns as shown above in the post.
1. 
4. Add Items from Excel into SharePoint List-
1. 
5. That's all. Now save the flow and execute it.
6. Here's the result-
1. 
7. Please feel free to sent me your queries or any functionality that you want to achieve and currently not able to do so. I would be happy, if would be able to provide it's solution.
8. Next Post Link-
1. Coming soon...

With this, I am concluding this post.

Happy Coding !!!

Will see you again with some new topics.

Stay Safe !

Stay Healthy !