Questions tagged [column]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
45 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
73 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
8 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
30 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
117 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
26 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
37 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
49 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
30 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
19 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
21 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 ...
1
vote
4answers
327 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
53 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
134 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
38 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?
0
votes
1answer
48 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. ...
0
votes
0answers
10 views

Creating a Date Column to display in the “Friendly” Format

I'm confused. I have a column "Date Chart Requested" and at first it did display the dates as "5 days ago" which is exactly what I want. But after further tweaking of the custom list, it no longer ...
0
votes
2answers
42 views

SPO How to Hide column on Display form for specific group permission?

I want to hide a column for a specific group permission on Display form. I have found a jQuery code and I have tried to use it but the column still visible to the user that is on this particular ...
1
vote
2answers
52 views

SPO: Display column only on Edit Form

I have a column called "Comments", i have hide this column to appear in New form. But i want to make this column appear on edit form so i can see the related comments of the approvers and the "...
1
vote
1answer
75 views

If calculated value column exceeds 24 hours

I got this calculated column that shows values of "hh:mm:ss". But i've noticed that if its exceeds 24:00:00 it will restarts to ex. 01:00:00.. Is there any way to make a validation or format the ...
1
vote
0answers
31 views

Problems with exporting a list to Excel

I have modified my view and selected just the columns that i want to show. But when I export the content to excel I can see more columns. (In my nomal view I am not seeing them, just when I export it ...
2
votes
1answer
369 views

Yes/No field in JSON view formatting

This is about JSON formatted views (not columns) in modern SharePoint online. List A has a Yes/No field. The values show as Yes or No in the view. When I format the view and show the field value ...
0
votes
4answers
48 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
19 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, ...
1
vote
1answer
22 views

Page Layout field

I need some help to update a field in page layout. I don't have much information but I am trying my best to explain the issue. In our page-layout we have a hidden field for the owner to choose to ...
0
votes
0answers
14 views

Sharepoint List - Quick Edit adding a text box

I'm a SharePoint neophyte without admin access. I'm experiencing an odd problem when editing items in a list. I have a column set to 'Multiple lines of text' and Enhanced Rich Text. If I edit an item ...
0
votes
1answer
18 views

SharePoint 2013, Column Ordering doesn't seem to be working

New here. Just started working in SharePoint 2013 to manage various project docs and due dates for my team. I set up a list using the Import Spreadsheet app that had the column headers ordered in a ...
0
votes
1answer
30 views

SPO How to set permission for a specific column in a list?

I have a list contain 3 columns: Ex: A,B,C The Admin can create/edit and delete all columns. My requirement is: The invited user can also create/edit and delete except of column C. He can see it ...
0
votes
2answers
54 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
1answer
23 views

Value of the Yes/No Column

What is the values of the Yes/No Column in SharePoint? 1, 0 Yes, No "Yes", "No" True, False Trying to use calculations: =IF([Col1]=Yes, 1, 0) So if it's true, put 1, else 2. But not matter what, ...
0
votes
1answer
109 views

Show/Hide in New form based on dropdown selection jQuery

I have a dropdown list contain values, last value is called "Others" when its selected i want to show a new textbox under the field and if its not selected it should be hidden. I have followed this ...
0
votes
1answer
57 views

Powershell script to update list column from another column Conditional

Any help is greatly appreciated. Here is the scenario: I have a powershell script which I am using from another post on stackexchange. I have two fields in a list, the script copies the value from ...
0
votes
1answer
47 views

Conditional validation of SharePoint Online column

I am trying to validate a SharePoint online task list column, in the way that the column "Assigned" (People column) must be populated for the user to be allowed to save with info in "Due date" (Date/...
0
votes
0answers
29 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
20 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
1answer
19 views

Delete column from content type doesn't work

This is the code I use: Add-PSSnapin "Microsoft.SharePoint.PowerShell" $web = Get-SPWeb "Myshareointsite/Projects/Test" $list = $web.Lists["Risks"] $ContentType = $list.ContentTypes["Item"] $...
0
votes
0answers
59 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 ...
1
vote
1answer
23 views

Is there the capability to store a number range within a column?

I am trying to identify the best column type to store a selection of number values and ranges of number, e.g. 10,000-20,000. A majority of the values will be individual numbers but some need to ...
0
votes
1answer
51 views

Referencing 'Version' Column

Hi there, I am relatively new to using SharePoint as well as JSON and as mentioned in the subject, I am having issues in trying to reference the Version column (set by the approval status). What I ...
0
votes
0answers
13 views

How to only show specific columns in external list picker

How would one use an external list containing several columns to map each column in the external list to a drop-down control in a SharePoint List item? In the picture attached, how does one take each ...
0
votes
1answer
35 views

Get List Column configuration using pnp.js

I want to fetch the List column configuation to check if a field is required or not. But I am not able to figure out which function to use by looking at the documentation.
0
votes
1answer
30 views

How to create a lookup field from another lookup column

I have one lookup column. I need to create another lookup column to look up the existing lookup column in different lists. I am notable to do this, Could you please suggest some idea to implement the ...
0
votes
1answer
57 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 ...
1
vote
1answer
15 views

Adding columns to an existing list on Sharepoint 2010 intranet

I am trying to add two new columns to an existing list on an intranet page (on SharePoint 2010). I've used the guidance here and seem to be able to only get so far. I've found the list I want to add ...
0
votes
0answers
35 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
28 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
2answers
43 views

Hide items in a form

Recently, I see this function broken in SharePoint, I do not set it. Please help me. To begin, Go to List Settings. Click on Advanced Settings. Select Yes on Allow management of content types. ...
1
vote
0answers
7 views

SharePoint default Column values are added to all documents of a library even if the specific contenttype does not includes the column

in our document libraries documents are assigned to different contenttypes. These contenttypes share some columns but not all. If we now define default values for a managed metadata column, all ...
1
vote
0answers
13 views

Add “Select All” (similar to “clear all filter”) option from the column header

I need to click "Select All" under any column (similar to "Clear all" button on Column Header menu ). It should select all values of column. Can it be done using Script Editor? What script would it ...
0
votes
0answers
38 views

Custom List Grouped Columns - Default Collapsed Not Working

I hope someone can help with the following: I have created two separate custom lists. Both lists are grouped by individual columns, with the groupings set to 'collapsed' by default. The first list ...

1 2 3 4 5 21