Skip to main content

Questions tagged [column]

columns (fields) created using out-of-the-box column types

Filter by
Sorted by
Tagged with
2 votes
1 answer
2k views

How to Display Created By Field in InfoPath AND Sharepoint list with multiple values?

The article "How to Display Created By Field in InfoPath" seemed to work for a user on this forum. However, my needs are slightly different. I'm trying to create a list with the entry form showing ...
0 votes
2 answers
1k views

Column formatting changes not saving

For my document library on sharepoint online modern view, I have a column for Title. I've tried to format it so that the height changes dynamically based on how long the title is and when I save it at ...
0 votes
1 answer
2k views

On click of save button, 1 column to take the value of another column in a list

I have a list with columns "due date" and "revised date" in SharePoint. I want to enter the due date column only when I am entering items for the first time. Onclick of save button I want the ...
2 votes
2 answers
4k views

SharePoint Excel export issues (ID export to lookup columns/Columns out of order)

Good day, I have 2 issues I am trying to workout on some SharePoint Lists. I was hoping I could get a little help as my developer skills are just now developing beyond OTB solutions. Issue 1: I ...
3 votes
2 answers
1k views

Calculated Column needs left alignment

I have the same exact problem as related here Calculated Column left align header However, the solution suggested is inadequate. This would require me to manual add the web part to each list that I ...
0 votes
1 answer
14 views

Can we add "#N/A" to the people picker field in the sharepoint list

Can we add "#N/A" to the people and groups field, as we don't want to leave it blank if there is no allocator.
0 votes
2 answers
2k views

Making a yes/no column show an icon rather than text

I'd like to have a Yes/No column that rather than showing the usual text ("Yes"/"No"), shows an icon - say green or red. I know I can create another column (a calculated one) with a formula that ...
0 votes
0 answers
30 views

Modified by Column for Changes to Specific Column

I have a document library which users and their managers need to provide acknowledgement on documents. We do this with a date field for both manager and user (Manager Acknowledgement and User ...
0 votes
1 answer
2k views

Documents library - column that shows folders total size

My client wants a document library with folders representing contracts. In each folder there will be lots of files and my client would like to have a column that shows total files size inside each ...
1 vote
2 answers
1k views

Having different columns and categories for each file level

I have been tasked with reorganizing our SharePoint library using metadata filters. I was curious if it was possible to change what columns are present based on what file level I am in. For example, ...
0 votes
2 answers
6k views

Show only unique (not repeating) values of column in sharepoint list 2013

I have a list with two columns. Column names are Username and Status (options Free and Busy). Usernames can have both Free and Busy status or only one type Free or Busy. To make more clear this is ...
0 votes
0 answers
14 views

Help! Get Column Names (not internal) in a Track SharePoint Column Changes Flow

I'm building a flow to track column changes in SharePoint, following this video. It all works great, except I'd like the notification email to show the column display names instead of the internal ...
0 votes
0 answers
6 views

SharePoint Tracking List Glitch - Last Row gets deleted when a column is added or hidden

I set up a team SharePoint site using the Project Management template. It includes two separate tracking lists. An annoying glitch in both lists is that if I add or hide a column, it will delete the ...
0 votes
2 answers
3k views

Save to a People or Group column using SP 2013 REST API by login name only (without the ID)

This question will be a duplicate of this one (which has no accepted answer). I am trying to save a SP 2013 list item using the REST API. One of the columns is a People or Group column. Normally ...
0 votes
2 answers
1k views

Count Number of Items of Specific Value and update field in another list

I am stumbling with this in a huge way and I'm hoping someone here can help. I have a SharePoint List that has two fields I want to collect data from. The first field in Location and the Second is ...
0 votes
1 answer
1k views

Efficient way to get all the field (column) values in an array from SharePoint List

I have to get all the field (column) values in an array from a SharePoint list. Right now I am looping through all the items in the list and creating an array. But it is very inefficient if I have ...
0 votes
1 answer
2k views

Correct way of Convert Enhanced Rich Text field to Plain Text (multiline) - Sharepoint 2013

I changed a type of a Enhanced Rich Text column to Plain Text field. I am seeing similar to the following content in the text field now. <div class="...
0 votes
2 answers
2k views

List that I've created is defaulted with "Stop editing this list", want to make it so it defaults as "new item or edit this list"

One of the lists I've created is defaulted with this interface: I want it to be able to default with "new item or edit this list" instead as such:
0 votes
0 answers
16 views

Document library web part + column

I have a need and don't know how to solve it. I have a document library and I'm displaying it on a page through a document library web part. I would like to have on the right side of the listing a ...
0 votes
2 answers
2k views

Make a column auto update by Parent Folder Value

I am setting up a new Document Library to organize several different types of Documents. I have a Folder View and a Metadata view. I am using a column named "Section" to sort the metadata view. I ...
0 votes
0 answers
23 views

In PowerApps column chart, how ow do you deselect a selected column

I am using PowerApps charts to control a gallery. The Pie chart works fine I can select a wedge in the pie and it filters the gallery - to clear the selection all i have to do is click outside the ...
0 votes
0 answers
20 views

Add Custom User Property to "Show Field" section in SharePoint list

I have SharePoint 2019 on prem and in one Site Collection i have a list and i want to create two new columns with the information type "Person or Group" then choose for the first column the ...
0 votes
2 answers
1k views

Create Custom People Picker Column in SharePoint 2013

I want to create custom Person or Group type of field which is mapped to User profile.when we add user name to that field then auto fill other columns like first Name,Last Name,Email,Work phone. In ...
0 votes
1 answer
1k views

How to mask a field like SSN or ID field?

Is there way to mask a field like social security number or ID field? I like mask field both in list view level, edit form and view form. Is it possible? Sharepoint 2013 (we have nintex form as well)
0 votes
3 answers
2k views

How to grant permissions at the column level Document Library

I'm using SharePoint 2013 I have a document library in which I would like to grant permissions at the column level, I mean that I want to show certain users some columns and not all. I've been ...
1 vote
1 answer
2k views

Locking Sharepoint column after data is input

How can I lock a column (in a list) from further changes after it is initially populated? I want to lock down the "initial due date" and only allow changes to a "revised due date" column so we can ...
6 votes
3 answers
69k views

SharePoint Online, Change Column Widths On Custom List

I have created a Custom List via Importing Excel Spreadsheet. How do I adjust the column widths? I tried to follow the below link, (my view is AllItems.aspx) and it never shows me the menu outlined ...
0 votes
1 answer
4k views

JSON Sharepoint Calculated Columns

First time coding with JSON and need a little help...... I am attempting to make a calculated column with conditional formatting. So far i can get it to work but only partially. What i want is to have ...
0 votes
2 answers
2k views

In a library, I find a column called TAGS, what is it?

While playing around, I noticed a column appearing among the available ones in the view settings called 'Tags'. I have displayed it and the image inside the library (of a person) showed the tag '...
0 votes
1 answer
2k views

Create a column unique to only a single folder within a document library

I am currently working on a standalone project that has numerous documents that will reside within the project folder located within my organizations document library. Below is an idealized example ...
1 vote
3 answers
5k views

Conditional Columns in SharePoint List

Is there a way to have a Conditional Column with Multi-Line Text that will only show up in the list if a certain status is selected?
0 votes
1 answer
21 views

Add image column in content type

I created a SharePoint library and added two columns to it: one column is of the image type, and the other is of the number type. Now, I want to include both of these columns in the content type.
5 votes
1 answer
4k views

Phone number column validation

I want to add phone number column with below format: 1-121-343-6917, 434-5503 & 60-12-444 444 Used below method =TEXT(123456 ,CHOOSE( LEN(123456) ,"0" ...
0 votes
1 answer
1k views

Is it posible for a document set to inherit metadata from a document which is inside this document set

I'm running in to this problem where people want to add metadata to a document using that same document. This is possible using Word quickparts. Now for the fun part, the documents are inside a '...
1 vote
1 answer
158 views

Cannot change the "Created By" column in a SharePoint list item using Graph API

I'm trying to programmatically change the "Created By" -field of a list item in a SharePoint list. As a development tool, I'm using the Microsoft Graph API python library - msgraph-sdk for ...
2 votes
1 answer
75 views

Issue Fetching DisplayName Column Data from SharePoint List via REST API

I am facing an issue while attempting to retrieve data from a SharePoint list using the REST API. The list contains a single line of text column named "DisplayName". However, when making a ...
1 vote
3 answers
18k views

New line break in SharePoint column description

I am provisioning a list declaratively in Visual Studio. In the schema for the list I want to include a field that has multiple lines of text for its description. Currently I have this in the schema....
0 votes
1 answer
1k views

Retrieve a single field's version history from SharePoint

My company uses a SharePoint list as an asset inventory database. One of the fields is a Notes field. I am able to pull the current contents of the field by linking to the list in MSAccess, but I ...
0 votes
0 answers
11 views

SharePoint Core Column Name issue

While I was creating a new content type based on Document, I accidentally renamed the core column name 'Name' to another value. Unfortunately this has perpetuated to other content types based on this ...
0 votes
0 answers
29 views

Column name getting changed

I have created 3 Single line of Text columns named L1, L2, L3 In list the display names show correctly, however internal name of column got generated as _x004c_1 What could cause this? Is there any SP ...
1 vote
4 answers
2k views

hide Name of column from document library in SharePoint 2013

how to hide “Name” of column from document library in SharePoint 2013
1 vote
1 answer
1k views

Sharepoint Online - Recover column from lists of project sites

I have a site collection with a lot of subsites attached to projects (each subsite is a site created by a project). Those subsites has a list with its fields. I executed a PowerShell script that ...
0 votes
1 answer
106 views

How do I make a column in a Microsoft SharePoint an auto-incrementing identifier that the user can not edit?

How do I make a column in a Microsoft SharePoint an auto-incrementing identifier that the user can not edit? I want it such that an ID field is incremented automatically when a user enters a new row ...
1 vote
3 answers
322 views

Set index on a column in a large list programmatically

I can manually set an index on a column in a large SharePoint list (10000+ items) but I'm not able to do it programmatically. With (PnP) PowerShell I've tried: # get context $Context = Get-PnPContext ...
2 votes
1 answer
1k views

Amending the Calendar form in Sharepoint 2013

I have a question about the Calendar app. I made the Location field compulsory from the Validation settings and a red warning message appears, when you try to save an event without its location. How ...
0 votes
1 answer
111 views

Problem on JSON formating with a connected field of a lookup Column

In my List A I have a lookup column "CODE PROJET" and one connected lookup column "FIN RECONDCT" both coming from an other SharePoint list B. On a field of the A List I try to do ...
0 votes
1 answer
26 views

Use JSON to calculate Average

Can anyone please help !! Im using a 2x SharePoint Online lists. One list contains a REGISTER One list contains a list of ACTIONS to be taken against items on the REGISTER list I have managed to ...
1 vote
1 answer
1k views

how to change the format of the “person or group” column

In my document set (Sharepoint 2010) I have a column with type of “person or group” which I can add the name of some users to it. The format of the names is like this: firsName1 Surname1; firstNmae2 ...
0 votes
3 answers
2k views

Customizing PnP Search results

I have added some columns to a Document Library. I want to use the PnP Modern Search Results V4 to display the results but I am stuck trying to get columns that I added to display. I'll use this &...
0 votes
1 answer
240 views

What is the best SharePoint column type to store latitude and longitude inside our custom list

What is the best SharePoint column type to store latitude and longitude inside our custom list?

1
2 3 4 5
23