Power Automate - Building Flows

Unanswered

Create a Sharepoint List and add columns

Like (0) Share

Report

Posted on 14 Sep 2022 16:26:38 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!

All responses (5)

Answers (0)

Expiscornovus 31,648 Most Valuable Professional on 15 Sep 2022 at 08:29:08

Like (0)

Report
Re: Create a Sharepoint List and add columns

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
matteoooooapps 8 on 15 Sep 2022 at 07:56:01

Like (0)

Report

Re: Create a Sharepoint List and add columns

Thank you! I realized that the columns are there but they are hidden.
Do you know a way to make them appear automatically?
matteoooooapps 8 on 15 Sep 2022 at 07:55:02

Like (0)

Report

Re: Create a Sharepoint List and add columns

You're right! The columns are there but they are hidden.
Do you know a way to make them appear automatically?
eyau 107 on 14 Sep 2022 at 21:44:02

Like (0)

Report

Re: Create a Sharepoint List and add columns

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!
Expiscornovus 31,648 Most Valuable Professional on 14 Sep 2022 at 21:35:31

Like (0)

Report

Re: Create a Sharepoint List and add columns

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.

Community site session details

Create a Sharepoint List and add columns

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

Create a Sharepoint List and add columns

Helpful resources

News and Announcements

Quick Links

Understanding Microsoft Agents - Introductory Session

Markus Franz – Community Spotlight

Kudos to the March Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates