You’re offline. This is a read only version of the page.
Hi,
I need to create an instant cloud flow on Power Automate that, once trigged, creates a new sharepoint list (called "NewList")and adds 3 columns: "Name", "ID" and "Role".
I followed a web tutorial and I created the list as you can see below, and it works.
Share
ReportBODY:
{ "AllowContentTypes": true,
"BaseTemplate": 100,
"ContentTypesEnabled": true,
"Description": "My list description",
"Title": "NewList" }Then, I tried to add a new column ("Name") adding a new 'Send an HTTP request to Sharepoint' step (see below) and, once run the flow it returns with success but no column is actually added.
BODY:
{ '__metadata':
{ 'type': 'SP.Field' },
'FieldTypeKind': 2,
'Title':'Name' }However, I don't know how to create more than one column in a single step (I think I have to change the 'body' but I'm not very familiar with JSON language).
I don't know if it's the right process, if you have any suggestions please comment below.
Can you point me out how to solve these issues?
Thank you in advance!
Hi @matteoooooapps,
Yes, this is possible via the SP.ViewFieldCollection.add Method
Use a POST request with this syntax:
Uri
All responses (
Answers (http://<sitecollection>/<site>/_api/web/lists(listid)/Views(viewid)/ViewFields/addViewField
Body
{
"strField": "TestCustomColumn"
}
Here is another example:
Thank you! I realized that the columns are there but they are hidden.
Do you know a way to make them appear automatically?
You're right! The columns are there but they are hidden.
Do you know a way to make them appear automatically?
Hi,
You're on the right track and it looks like you should have it. Click on the Show/Hide columns in MS Lists and see if your new column is hidden. If not you can check out this article and scroll down to the "Power Automate create Sharepoint list columns" section. This will go over how to create a list column in sharepoint via the HTTP Request and will probably go over what you already know. There is code on there to follow up, so it should be good to go.
Hope this helps!
Hi @matteoooooapps,
Did you check the list settings if the name column is actually there? It might be a case of that the column is created in the list but simply not showing up in your default view.
Can you btw share some screenshots of your Send an HTTP configuration? This way we know which methods you used and this could help with the troubleshooting.
#1
David_MA
161
Super User 2025 Season 1
#2
Michael E. Gernaey
148
Super User 2025 Season 1
#3
stampcoin
139
