Create custom column - Access Denied

Question

Hi

Developing an external app logging on to Teams(Sharepoint). Get an error when I try to create a custom column. Usually the ODataError object will list up the API permission I'm missing but this time around I only get 'Access Denied'. Anyone knows what permission my application is missing?

 

Cheers
Tore

 

 

var columnDef = new Microsoft.Graph.Models.ColumnDefinition
{
Description = "test1",
EnforceUniqueValues = false,
Hidden = false,
Indexed = false,
Name = "Title1",
Text = new TextColumn
{
AllowMultipleLines = false,
AppendChangesToExistingText = false,
LinesForEditing = 0,
MaxLength = 255,
},
};

try
{
// Returns 43 list columns
var colums = await _graphClient.Drives[item.ParentReference.DriveId].List.Columns.GetAsync();
//Throws Access Denied error
var result = await _graphClient.Drives[item.ParentReference.DriveId].List.Columns.PostAsync(columnDef);
}

catch (ODataError err)
{
//Access Denied
}

Answer 1

Hi @Marskar, Tore

You should create column definitions in a site. Here are the permissions you need:

Code snippet:

var graphClient = new GraphServiceClient(requestAdapter);

var requestBody = new ColumnDefinition
{
	Description = "test2",
	EnforceUniqueValues = false,
	Hidden = false,
	Indexed = false,
	Name = "Title2",
	Text = new TextColumn
	{
		AllowMultipleLines = false,
		AppendChangesToExistingText = false,
		LinesForEditing = 0,
		MaxLength = 255,
	},
};
var result = await graphClient.Sites["{site-id}"].Columns.PostAsync(requestBody);

Hope this helps.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.