Questions tagged [column]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
16 views

Text Column Validation: Numbers only, 5 numbers, a period, and 3 numbers

In my SharePoint list, I need a text column [ID] to validate as 5 numbers, a period, and then 3 numbers. Example: "15202.123" and I need help. :-) Thank you!
0
votes
1answer
43 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
1answer
23 views

Email users based on results of choice column with checkboxes (multiple selections)

I am looking to create a workflow that sends an email to users based upon the results of column that allows multiple selections. The column has 8 selections and it basically needs to email user "...
2
votes
1answer
23 views

How to find all selectable properties of a list item

If I run the query ..._api/web/lists/GetByTitle('Site Pages')/items, I get a list of properties, but it is not comprehensive. For example, FileRef is not visible in the resulting JSON, but can be ...
0
votes
2answers
32 views

Hidden columns visible in edit form for a content type in SharePoint online

Recently we migrated few sites from SharePoint 2010 to SharePoint online. The source site had few managed metadata columns. For each of these columns, SP2010 had created a Single line of text column ...
0
votes
1answer
53 views

SharePoint Online - Show column description or full column name when hovering the column header

We currently have a SharePoint list that has quite many columns, with describing column names making the column names take up quite a lot of width. Many of them get cut off in the middle of the name, ...
0
votes
1answer
37 views

Flow to modify columns on dynamically determined Sharepoint library

I have a flow through Power Automate and one of its functions is to modify metadata of a file stored in a Sharepoint library based on certain criteria. The metadata is stored in custom columns and the ...
0
votes
1answer
76 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="...
1
vote
1answer
23 views

Nesting IF Statements in SharePoint Calculated Column

Uhh!. I have 3 statements that individually return my values. Now, I need to put these together into one formula. Here are my statements that need combined into one calculated column. Thank you. 1st ...
0
votes
1answer
15 views

How can I make a list view with 4 columns use two zones or columns on a wiki page

I have a list view that contains 4 columns. The list is being shown on a wiki page. I want to wrap the list so that it is not so long. By wrap, I mean split the number of rows in half and show the ...
1
vote
0answers
33 views

Tenant level mapping to crawled property

I have mapped a crawled property ows_DocumentType to RefinableString00 in the SPO Admin console, and I can confirm that all my Site Collections see this mapping. How do I create the columns on these ...
0
votes
0answers
30 views

People column not showing up in Word quick parts

I have a People column in my document library, and I have added it to my Document Set. I have also checked the People column to be a shared column in the Document Set Settings. I have other columns ...
0
votes
1answer
25 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
24 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 ...
1
vote
1answer
25 views

Sharepoint list column display

I got a list where i use the PromotedState column to display if a site is a sitepage or a newspage based on the number "0" and "2" (0=sitepage, 2=newspage). The column is populated ...
0
votes
1answer
28 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
31 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
48 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
32 views

Set Form Values from Popup window

Good Day, I have the non-standard task. I have SharePoint Document List and Directory List. The Directory List includes three columns: “Process” (single-line field), “Process Group” (choice field), “...
0
votes
1answer
50 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
421 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 ...
2
votes
1answer
36 views

Do File Libraries have any column types that can be modified after approval?

I have a Doc Library with versioning, content approval, etc. that gets updated with a Flow/Power Automate after the user has checked-in. I want to have a column or two that are not doc properties and ...
0
votes
1answer
21 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
48 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
61 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 ...
1
vote
1answer
292 views

Unable to delete Column

Forgive me if this has been asked before but I have not been able to find a solution that works. I am currently teaching myself how to use SharePoint. I have created some columns that have errors in ...
0
votes
0answers
9 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
103 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
148 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
103 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 ...
2
votes
1answer
190 views

[PnP][SharePoint] How to add a column to all content types of a list?

I have a list in SharePoint with 50 content types. My list has two columns that I want to add to each content type in my list using PNP library. Until now I have something like this: Add-PnPField -...
0
votes
1answer
13 views

Infopath-Populate ID from SharePoint List

I have an InfoPath 2013 form with multiple views with a lot of fields for users to fill out. My final page after the user submits the form through the main data connection is a view that says "Thank ...
0
votes
0answers
25 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
62 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
98 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
33 views

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

I am trying to find out how can I write a code to restrict a user to enter a value among a set of predefined values (i.e. IN Operator) in a column of a SharePoint list. My column name is "Asset type" ...
0
votes
2answers
87 views

Make SharePoint Online list columns read only based on yes/no checkbox

I have 7 columns that I need to make Read Only (greyed out) as soon as the item is saved when "Field 7" is ticked (yes/no checkbox column). I have managed to make these 7 columns read only using the ...
1
vote
1answer
33 views

How to validate a column based on the value in another column?

I'm trying to come up with a formula that could validate a column. I have a form in SharePoint to register parcel shipments. There's a column that contains a shipment code (values 1, 2, 3). If the ...
1
vote
0answers
16 views

How to update the External Content Type of existing column

I have a list with multiple columns as the type of External Data. There are some changes in the External Content Type. so I want to update the reference for some of the columns. But I am not able to ...
0
votes
1answer
57 views

Remove 'Target Path' Column

I have a colleague that created a list that I inherited. It was created as a task list, and comes complete with the column 'Target Path', which is not only a required field, but I cannot seem to ...
1
vote
1answer
40 views

Changing Hyperlink Column based on InfoPath forms

I have a requirement from my client that's unlike anything I've done in SP. So, I'm re-designing their Change Request system. I've build a form with multiple views in InfoPath that serve different ...
3
votes
2answers
39 views

Make a DATETIME column show red background 2 hours after duedate

So I got this code, it makes the background green when it has passed the set taskduedate. But I want it to show red background when it has passed 2 hours after taskduedate, it that possible? { "...
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 ...
1
vote
0answers
24 views

Setting person column with workflow

I am using a reusable workflow to collect feedback on a document. One of the initiation form parameters is "owner" with the "person or group" information type. I am trying to get the "owner" parameter ...
1
vote
1answer
27 views

Can I use a list workflow to make changes in two different lists in SPD 2013

I want to know if I can use List workflow rather than the Site Workflow to make changes from one list to another if something has been changed or do I need a site workflow to achieve this? I also ...
1
vote
0answers
21 views

I am trying to make a value limited RSVP System

I have been tasked with creating a list in SharePoint to let users pick one of three training sessions. Each training session must be limited to 50 users. I've been leaning towards a list with a ...

1
2 3 4 5
21