Deleting site columns from Content Types

(0) Share

Report

Posted on by AL-11030839-0

Has anyone successfully deleted site columns from the Documents Content Type using Power Automate.
I created a flow that adds sites columns to the Documents Content Type, now I want to create a way to retract the changes, if needed.

I have added a Https request that gets the fieldlinks > id first, using:

/_api/web/contenttypes('0x0101')/FieldLinks?$filter=Name eq '@{items('Apply_to_each_2')?['InternalName']}'

then I am trying to delete using another request using:

/_api/web/contenttypes('0x0101')/FieldLinks('@{first(body('Send_an_HTTP_request_to_SharePoint_-_Get_FieldLinks')?['d']?['results'])?['ID']}')/deleteObject()

The request succeeds, the response body is blank and the column still exists in the content type.

Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Expiscornovus 33,891 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AL-11030839-0,

Personally I haven't seen the FieldLinks part working with just a delete object method. But that might also require an update to the content type as well?

I have recently used the delete columnDefinition method of the Graph API instead.

https://learn.microsoft.com/en-us/graph/api/columndefinition-delete?view=graph-rest-1.0&tabs=http

Below is an example of that.

_api/v2.0/sites/@{variables('SiteId')}/contentTypes/@{variables('ContentTypeId')}/columns/@{first(outputs('Send_an_HTTP_request_to_SharePoint_-_Get_Column')?['body']['value'])['id']}

Also double check if your Content Type is editable, before you run the flow

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, LinkedIn, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No