Answered

Automating the showing of a SharePoint column in a Document Library

(0) Share

Report

Posted on by Carl__D

Hello,

I have built a SharePoint provisioning script with Power Automate and a final requirement is for the Sensitivity column to be visible within the Document Library.

Does anyone know of a way to automate this step?

Provision Columns.png

Thank you

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @Carl__D,

Yes, this should be possible via the SharePoint REST API. You can use a Send an HTTP request to SharePoint action for this.

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-rest

Below is an example with the Sensitivity column (internal name is _DisplayName).

I am using two variables for the List Name and the View ID. You can replace that by your values.

URI

_api/web/lists/getByTitle('@{variables('ListName')}')/Views('@{variables('ViewId')}')/ViewFields/addViewField

Body

{ "strField": "_DisplayName" }

Was this reply helpful? Yes No
Carl__D 84 on at

Like (0)

Report

Hi @Expiscornovus,

Thank you for your reply!

I'm sure I'm missing something obvious as fairly new to HTTP calls, but I believe I am replicating this process:
But getting the following error:

'{"odata.error":{"code":"-2147024809, System.ArgumentException","message":{"lang":"en-US","value":"The specified view is invalid."}}}

I made a 'getbytitle' request further up the chain in order to parse out the View ID so I believe it is right.

Any help would be much appreciated.

Thanks

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

Like (0)

Report

Hi @Carl__D,

What values are you using for the ListName and ViewID variables?

In my example I used TestLibrary & 5884FA4F-20DA-4D5B-9B42-95276E0A91FC (which is the All Documents view of my TestLibrary)

Was this reply helpful? Yes No
Carl__D 84 on at

Like (0)

Report

Hi @Expiscornovus ,

I'm also using a 'TestLibrary'.

When sending a GET "_api/Web/Lists/getbytitle('TestLibrary')"
I'm using the output: "Id": "99b4711a-e3fb-4bfe-a4ad-513ee4ecac87"

So my variables are:
ListName = TestLibrary
ViewID = 99B4711A-E3FB-4BFE-A4AD-513EE4ECAC87

Thanks

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

Like (0)

Report

Hi @Carl__D,

Can you run the following two GET HTTP requests and check if those work?

If so, can you share the outputs of those two responses?

Was this reply helpful? Yes No
Carl__D 84 on at

Like (1)

Report

Ah i'm an idiot, I was using the List ID instead of the View ID.
Worked a treat. Thank you so much for your help with this! 🙂

Was this reply helpful? Yes No