Questions tagged [column]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
20 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
0answers
8 views

How do I provide a list of choice if a former column is YES [closed]

i need the user to have a list of choices to choose based on the selection of another column. For example if column A has choices aa,bb,cc and if user selects cc then the next column should have a ...
0
votes
1answer
18 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
34 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
18 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
35 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
19 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
25 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
34 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
39 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
7 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
27 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
22 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
32 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
26 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
19 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
53 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
10 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
9 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
35 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
28 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
30 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
43 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
26 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
24 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
32 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
35 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
39 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
13 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
25 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
20 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
164 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
82 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
108 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, "...
4
votes
4answers
184 views

Page Library - new column with required field, how to prevent page creation if required field not filled

Here's my problem: In my default page library I have added the column "Content type". This contains a selection list (manual, source code, etc.) and can be edited via drop-down menu. I have set this ...
0
votes
1answer
33 views

Copy user field value to SharePoint online site

I have a user field in a list that has allow multiple user setting on. ie I can have more than one user in the field. I am trying to copy my User field data form on prem SP2016 site to online site. ...
4
votes
0answers
123 views

Highlighted content - how to filter by custom column?

We use SharePoint as a wiki. So we create modern pages in the standard library and in a newly added column we specify that it is a wiki page. The views are filtered accordingly so that only wiki pages ...
2
votes
3answers
56 views

How to write internal column names to host

At the moment I m trying to use this: Add-PSSnapin microsoft.sharepoint.powershell #Get Web $web = Get-SPWeb http://... #Get List $list = $web.Lists["List1"] $list.DefaultView.ViewFields | Write-...
0
votes
1answer
33 views

SharePoint column fill notification in SharePoint designer 2013 Workflow

I am using SharePoint designer 2013 and want to notify certain people if a specific column in the list has been updated by someone. I simply want to know what can I use in the stages so that it can ...
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
1answer
22 views

When adding an item, will deleting the coloumn where we add new data, will it delete the previous data already entered in the records

I have a share point website with a list and important records. However my manager told me to amend the columns, as it's type has also to be changed to choice from Azure AD rather than the single line ...
2
votes
4answers
2k views

The “_x0020_” of the Internal name for a SharePoint column

I am currently doing documentation for our SharePoint Applications. For the purpose of explanation/definition, What is the "x0020" portion of a SharePoint internal name for a column? I'm not sure if ...
0
votes
1answer
422 views

Get value of Name column from SPO list for JSON formatting

First of all, apologies if this horse has been beaten before but I can't find anything so far to help me out. I'm trying to do some conditional formatting of a column in a SP list. One of the ...
2
votes
3answers
1k views

Change the Yes/No Column Type into a Checkbox for a SharePoint Online List

I am having trouble trying to find out how to change the Yes/No Dropdown to a Checkbox while in quick edit mode. I am on a SharePoint Online list and have tried a few different things without any luck....
0
votes
1answer
208 views

Is it possible to recover a deleted column from a list in SharePoint 2013?

I accidentally deleted a column from a list that contained a lot of entered data. I have no backup of this data, is there any way to recover?
1
vote
1answer
51 views

Columns doesnt count right

So I got this example: The green value should show 01:00:00 but it doesnt. I think the formula I got "ROUND" it somehow (I got the code online). And I need this code so the value can exceed 24 hours. ...

1
2 3 4 5
21