Unanswered

Create a Sharepoint List and add columns

(0) Share

Report

Posted on by matteoooooapps

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.

BODY:
{ "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!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 33,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
eyau 109 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
matteoooooapps 8 on at

Like (0)

Report
Copy link

Link copied!

You're right! The columns are there but they are hidden.
Do you know a way to make them appear automatically?

Was this reply helpful? Yes No
matteoooooapps 8 on at

Like (0)

Report
Copy link

Link copied!

Thank you! I realized that the columns are there but they are hidden.
Do you know a way to make them appear automatically?

Was this reply helpful? Yes No
Expiscornovus 33,828 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @matteoooooapps,

Yes, this is possible via the SP.ViewFieldCollection.add Method

Use a POST request with this syntax:

Uri

http://<sitecollection>/<site>/_api/web/lists(listid)/Views(viewid)/ViewFields/addViewField

Body

{ "strField": "TestCustomColumn" }

Here is another example:

https://powerusers.microsoft.com/t5/Building-Flows/Using-REST-API-to-create-a-field-in-a-Sharepoint-list-all/m-p/1048014/highlight/true#M136898

Was this reply helpful? Yes No