Error: Column 'Gender' does not exist. It may have been deleted by another user.

[Sonu123]

Scenario: Here i am creating site content type using Power automate rest API call -> Then i am getting content type id. After that i am getting all site columns using Power automate rest API call -> then fetched the column i want to add to the content type in SharePoint -> Once i have the internal name of the site column, i am adding it to Site content type using rest API call.

So, while adding site column to the Site content type using below rest API code, getting error 400: Bad request' : Column 'Gender' does not exist. It may have been deleted by another user.

"Method: POST
Uri : _api/web/contenttypes('0x01004D8EA36C4B25CB4398F0B6FDAAFED8B0')/fieldlinks
Header: 

Content-Type

application/json;odata=verbose

Accept

application/json;odata=verbose
Body: {
"__metadata": {
"type": "SP.FieldLink"
},
"FieldInternalName":"Gender"
}"

Can you please help me to add a site column/ existing site column (custom site column or built-in site column) using Power Automate rest a call

@Pstork1 @Expiscornovus

[ManishSolanki]

Hi @Sonu123 

As per my knowledge, site Columns cannot be added to a content type using the REST service, here the link for more details:

SP.FieldLinkCollection.add Method (sp.js) | Microsoft Learn

I leave it to our expert @Expiscornovus  for his valuable comments.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[Sonu123]

@ManishSolanki Then how i can solve it using SharePoint list. Can you share me the solution or some example.

Thanks 

[Expiscornovus]

Hi @Sonu123,

In the documentation the below limits are listed for the Fieldlinks method you are using. 

https://learn.microsoft.com/en-us/previous-versions/office/sharepoint-visio/jj245869(v=office.15)#po...

• Site Columns cannot be added to a content type using the REST service.

• You can add a field to a site content type only if the field already exists on the parent content type.

• You can add a field to a content type associated with a list only if the field already exists on the list. To add a completely new field to a list content type, you have to first add it to the list and then add it to the content type in a separate call to the REST service.

One of those limits is that you can cannot add site columns to a content type using the REST service. So, it looks like what you are trying to achieve is not possible via this specific method.

I would suggest to have a look at alternatives SharePoint methods (I will also have a look). Or this should also be possible via either PowerShell, CLI or code.

[Expiscornovus]

Hi @Sonu123,

I had another look, specifically at the SharePoint REST operations via the Microsoft Graph REST API.

https://learn.microsoft.com/en-us/sharepoint/dev/apis/sharepoint-rest-graph

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

Might be possible via the Columns Add method. First tests look promising 😁

1. HTTP request in Power Automate. 

It uses SiteId, ContentTypeId and SiteColumnId

2. End result in my Content Type gallery. Site Column ColumnA has been added to the Facilities FAQ Content Type.

[Sonu123]

Thanks a lot...i works for me