Questions tagged [column]

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

336 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
1answer
24 views

Delete columns on XL SharePoint O365 Doc Library

Scenario: We have a large document library (roughly 122k documents/folders), housing most of our sales documents. We use Power Automate (replacing SP Designer 2013 workflows) to dynamically add ...
0
votes
1answer
23 views

Include Owner and Editor metadata in list item Details panel

One of my users recently moved from SharePoint 2007 to SharePoint Online (modern ux). She asked me how to display the "Created by [name]" and "Last Modified by [name]" in the ...
0
votes
1answer
27 views

Help with SharePoint List

I'm stuck here with this SharePoint List columns formula. Probably there is a easier way of doing this. I have a column with two choices, one for phone and other for laptop. I created the columns but ...
0
votes
1answer
21 views

SharePoint How to return item field value by Ajax

Good day, I have the List. The List has checkbox field "DocOrg". The user must select checkbox "DocOrg" value and the script must send ajax query to another list, find another list ...
0
votes
1answer
43 views

In a list view, how do I filter a Person column to find invalid values?

We have a SharePoint list. A column on the list is of the type "Person or Group". The field is set to allow "People only", chosen from "All Users". How do I create a view ...
0
votes
1answer
36 views

SharePoint Online modern site: Create Site column with multilingual Title using powershell

I can't figure-out how to create a site column with multilingual Title in SharePoint Online on modern sites using powershell. Example: I would like to create a column with the English Title "...
0
votes
1answer
299 views

Sensitivity label value for PDF documents not showing in SharePoint Online library

I have sensitivity labels enabled for my Office 365 tenant and have created labels, policies as well as some DLP rules. All appears to be working correctly in SharePoint libraries, apart from PDF ...
0
votes
1answer
19 views

How can't i refresh ListItemAllFields when site column is updated?

I'm updating site column with this code: Field field = site.Fields.GetById(property.MappedSiteColumn); clientContext.Load(field); field.SchemaXml = xml; clientContext.ExecuteQuery(); The site column ...
0
votes
1answer
20 views

Editing Format of an attribute in SharePoint list is different from its viewwing format

I am working on a list and the format of a column is currency and currency format is $NZ and it shows the values as it's supposed to (e.g. $123,000), but when a user wants to enter a new row or edit ...
0
votes
1answer
39 views

CASE SENSITIVE Custom Validtion syntax for the IN operator for a column of SharePoint list

I am entering the below condition as the validation formula for an attribute in the SP list, but it allows me to enter "innovation" instead of "Innovation", how can I avoid this. =...
0
votes
2answers
49 views

Is there a way to remove white-space from the Text?

For example, If I give input text in the Column as - mo bi le pho ne. Then the data should be saved in the column as- mobilephone (it should remove all the white-spaces) Also, the Validation formula ...
0
votes
0answers
8 views

Want to Update Drop-Down Column Selected value with Single Item (Record) Collection Column name Quantity in Power Apps. Need Help

As beginning I have attached the List to the gallery & Copied the Selected Row (all Columns) as per my choice into Collection(ChooseItems) in one Screen. I have selected many rows from Gallery and ...
0
votes
1answer
65 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 '...
0
votes
1answer
23 views

Update column based on file views in document library

I have a document library with a bunch of files im sharing with others. I have a column called "Opened" which is based on a yes/no value, and it defaults to no for each file. I'm wondering how I can ...
0
votes
1answer
101 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
1answer
72 views

Column Validation/Validation Settings, How can I add a formula where if one answers YES to one column it will require them to fill out certain columns

I have a sharepoint list where I have a series of questions. The first question in the series is a YES/NO question, and it states if the answer is no, there is no need to answer the next few ...
0
votes
0answers
20 views

Unable to set User SharePoint group column (lookup) value

Would like to request for some assistance in SharePoint. I have a SharePoint group called Users and SharePoint List called Role and Department. I have added Role and Department to Users column as ...
0
votes
0answers
22 views

Enable Table Styles Group for enhanced rich text field

Good Day, I have enhanced rich text field in some SharePoint List. I can insert table to this field, but Table Styles Group is grayed out. How can I enable Table Styles Group for rich text field? I ...
0
votes
2answers
43 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
1answer
76 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 ...
0
votes
1answer
40 views

Can't get Organization Name from AD

Good day, I have a question with getting user profile data from AD by JavaScript for SharePoint Display Form. I can get user Department by script: <SharePoint:ScriptLink ID="ScriptLink2" name="SP....
0
votes
1answer
14 views

Create columns for each month

I need to create a forecast list where users can enter the projected number of staff for each project. Rather than manually entering the columns for each month, is there an automated way of creating a ...
0
votes
0answers
10 views

Validation settings acting weird

So I got this problem with validation settings on a sharepoint list.. I use the formula below and it kinda works. I cant choose "tekniker klar" and save the form if I havent filled in these columns [...
0
votes
1answer
20 views

Column validation user message pops up for millisecond

So I got this column validation: =[Sleep]>TODAY() And user message "NO". And it works, I cant put a date back in time, but the user message "NO" is just popping up for a millisecond, someone knows ...
0
votes
4answers
54 views

Add a Document - SharePoint Online || Deos not display the recently added column to the List

Looking for a way to add existing newly created column called Business Area which is a choice based column to add a document form in SharePoint Online. This form appear when I try uploading a ...
0
votes
1answer
33 views

How to convert documents to Base64

It would be awesome if we could convert documents (word, excel, PDF, images) to base64 and then store the value in a column. I would love to automate this if possible. I know it is possible with flow, ...
0
votes
2answers
371 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
0answers
114 views

Reset column to default value

Given is a list with a yes/no column. Default value of this column is "no". What is the most efficient way to reset all items in the column to "no". I definitely don't want to solve the problem by ...
0
votes
2answers
23 views

Calculated Column with IF ISBLANK, else if “ABC”, then return “XYX”

If [OH:Subsample ID] is blank, OR if it contains "ABC", then the calculated field should return result "XYZ". No idea how to put that into syntax. I can get two separate lines, but can't get them ...
0
votes
0answers
82 views

Managed metadata columns show numbers instead of terms in document libraries

In Sharepoint Online, when I open a document library that has managed metadata columns, everything looks fine. However, when I preview a document and close the preview, the managed metadata terms are ...
0
votes
1answer
96 views

mandatory lookup column doesn't work

So I have a pretty basic scenario. Two lists (Projects and Clients). In the Projects list I have a mandatory lookup field that aims at the Clients Title column. Now when I fill out the form for ...
0
votes
0answers
76 views

Set dynamic default values for SPO list with custom new form

I have a SP Online list with custom new form. I want to update default values for 3 columns dynamically using the URL and make the columns ready only. For Eg, I have the below URL: https://company....
0
votes
1answer
29 views

How to programatically get the status value of a Content Type column using C#?

I am attempting to read the property of the Item content type which shows the Required, Hidden or Optional property for a particular column. if (spList.TryFindContentType("Item", out SPContentType ...
0
votes
0answers
41 views

SharePont 2016: How to make “Creator” column UNIQUE

I want to enforce unique values for "Created by" column. the "Created By" column unique. When I have to add a new element and an item really exist in the same "Created By" list - it shows an error ...
0
votes
1answer
13 views

Change Column Type On Move

I'm working on creating an auto-archive process with the information management policy settings. I managed to get it to work for the most part but hit a snag when trying to move a document set which ...
0
votes
1answer
84 views

Get a document modifiedBy in JAVA with RestApi

As you can see in images, I have some folder in my document library. I wanna reach the files in the folder and take the "modifiedby" column and change it with java-rest api. I can reach the file ...
0
votes
2answers
545 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
1answer
32 views

Fields are in different language in view vs in new/edit/display form

I have very strange SharePoint 2010 behaviour. Basically I have SharePoint site in 2 languages, default is English and there is German. So when I change my language to German then there is everything ...
0
votes
1answer
50 views

Content type fields marked as “hidden” aren't being hidden in the form?

I have a SharePoint Online list library which allows users to create a list item by using a simple form. In the backend of this site I've configured some hidden columns which are needed for some ...
0
votes
1answer
17 views

Column Validation in 2010

I need to use a column to capture ID numbers. I need a way to ensure that the answers entered are only numbers and exactly 12 digits in length. I've tried a zillion different formulas but keep ...
0
votes
1answer
91 views

Sharepoint 2013 - how to make a column content bold in task list

I am struggling with making any content under the 'Task Name' column in bold. I am using Sharepoint 2013. I have a task list (classic) and I want to make each task name in Bold. I would like to add a ...
0
votes
0answers
86 views

column options in sharepoint online list

For a list i created in sharepoint online: On some of my columns, the drop down arrow only shows "column settings" While other columns show "A to Z", "Z to A", "Filter by", "Group by Contact" and "...
0
votes
1answer
308 views

Bulk edit for large number of files not working?

I'm on Sharepoint Online, and I have a document library of about 1600 files. I have about 1000 files that are Unassigned in a certain column that I want to change from Unassigned to some other ...
0
votes
1answer
421 views

Invalid Field Name error when creating Sharepoint page

I'm trying to create a new Sharepoint page but I am getting the following error: Invalid field name. {50631c24-1371-4ecf-a5ae-ed41b03f4499} .../Pages TECHNICAL DETAILS Troubleshoot issues ...
0
votes
1answer
222 views

Verify Date Selected Is atleast 3 Business Days Away

We have a SharePoint site that we use to schedule customer appointments. These appointments need to be scheduled on a weekday and need to be at least three business days away, but no more than 45 ...
0
votes
2answers
31 views

SP Folder Status Indicator

Would it be possible to create a column on a SP folder as a status indicator i.e. review completed. Thank you.
0
votes
1answer
37 views

Cannot Remove Field from Sharepoint AddIn

I have a provider-hosted SharePoint Online add-in project. In this project I have added a lookup field with name CaseLawyer and deployed the app in the site. After that, I have deleted this field form ...
0
votes
1answer
589 views

Using JSON data bars Column formatting for text (stages)

I am looking at using column formatting to allow us to easily identify which stage a project is in. In SharePoint online using modern views. We have 4 stages and would like to have a 25%, 50% 75%, ...
0
votes
1answer
28 views

Bring list Column headers back

Following a great tip from How can I get rid of the columns header when the style 'Boxed' was selected? I was able to hide all the column headers and everyone was happy! Until of course ...
0
votes
2answers
17 views

What validation code should I use such that if any Column entry is changed it shows an error ?

I'm basically trying to keep 5 columns of my list locked(uneditable) while the last column editable. I'm a beginner and thought this would be the easiest way to achieve this. Do kindly suggest any ...

1 2 3
4
5
7