Questions tagged [column]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
30 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
31 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
43 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
23 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
18 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
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 ...
1
vote
1answer
22 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
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
31 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
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
300 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
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 ...
1
vote
1answer
157 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
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 ...
2
votes
1answer
139 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
11 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
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
77 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
71 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
29 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
41 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
38 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
23 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 ...
0
votes
2answers
38 views

I would like to insert another =IF in this formel

I would like to insert another =IF in this formel, for example: =IF it says "Hello" I want the text to be the color green. Is that possible? { "$schema": "https://developer.microsoft.com/json-...
1
vote
1answer
269 views

How to add list column to list content type via SharePoint online PowerShell?

I'm trying to add some custom property to list content type at SharePoint Online site by following script: $context=New-Object Microsoft.SharePoint.Client.ClientContext($URL) $context.Credentials = ...
3
votes
1answer
84 views

SPO: Workflow not working

I have this basic workflow that would get the value of the "created by" column and would populate it as a user name in a people column. The issue is it is not working. I can see the flow going to ...
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
292 views

Insert bold in column formatting

How do I insert code so this will also become Bold? { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "debugMode": true, "...

1
2 3 4 5
21