Questions tagged [column]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
17 views

Having different columns and categories for each file level

I have been tasked with reorganizing our SharePoint library using metadata filters. I was curious if it was possible to change what columns are present based on what file level I am in. For example, ...
0
votes
1answer
27 views

SharePoint Online - Lists - Update Field Based On Text From Another Field

I currently have a list where there is a column "Rating" that has values of: low medium high and effectively I am wanting to have another column labelled "Score" fill in based on ...
1
vote
1answer
27 views

Where is the secret list of field types kept?

I was trying to update a property on an existing SharePoint site column using the REST API. I found some tutorials like this Stack exchange post or this blog. They both have a __metadata property for ...
0
votes
0answers
5 views

Getting the Count of Null (or Non-Null) Values in Several Columns in REST Request

A SharePoint list/library view can be set up to give the user the count of "non-empty" or "non-null" (any value entered) within a column of that list/library. So without making ...
0
votes
1answer
15 views

Document Library: force column entries in specific folders only

I want to create a document folder within a existing document library. My goal is to add additional metadata via SharePoint columns (year, product type, etc.) to the document which have to be filled ...
0
votes
0answers
11 views

Field form size/format changed

After few data/form changes our sharepoint form has changed its format from this: To this: I already checked these settings and everything looks ok Settings / Advanced Settings / Dialogs -> NO ...
1
vote
2answers
71 views

Format column using JSON

I want to format a column if there is a date in the column, otherwise leave it blank. This is the code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting....
0
votes
0answers
26 views

Deleted column is still appearing in new & edit forms of a list

The already deleted column is still appearing in the New and Edit Forms of a list. We have already deleted the column but still it appears.
0
votes
1answer
26 views

Don't want parent to inherit from sub-folder

There is some columns I want to have in my sub-folder, but the parent-folder automatically inherit these. Is it possible to have columns in the sub-folder, but not in the parent-folder? Here May is ...
0
votes
1answer
19 views

Can I (dynamically) specify displayed columns using URL for list?

I know how to create a URL using defined (i.e. static named) views for a list/lib. I know that a URL can be created to specify filtering and sorting on a column of a view. But can a URL itself ...
2
votes
1answer
295 views

How do you create a Radio Button column in Sharepoint List?

Currently using PowerApps to make a form, and I'd like for a few of the inputs to be radio buttons like so: But then in the linked SharePoint List, I cant seem to find a radio button column type: I ...
1
vote
1answer
21 views

Faster way to create choices for column in SharePoint list?

I'm currently trying to recreate an old application built in Access in Power apps. This app includes a form with dropdown menu including multiple locations: Example: location 1 location 2 location 3 ...
0
votes
0answers
34 views

Specific column cannot be edited, every other one can

After exporting an excel table to a SharePoint List, I would like to edit one of my columns to change the type from Single line of text to Choice. However, one specific column does not have the "...
0
votes
1answer
275 views

Modern SharePoint Web Part - Remove Horizontal Scroll bar

I have a Document Library web part on my modern page in which I'd only like the users to see 4 of the 7 columns. I would normally hide the extra three columns, but due to a JSON script, they have to ...
0
votes
1answer
287 views

Power Automate - Set Column value to equal value of another Column in same list

I have a modern list with about 5,000 entries. My client has added two columns since creating all this data, and I need to set one column to equal the value of the other (doing this manually will ...
0
votes
1answer
90 views

Restored Deleted List Column on SPO

Is it possible to restore a column, and data, that was deleted from a list on SharePoint Online? If so, what are the steps to do so? Thank you!
0
votes
1answer
44 views

Validation Column Not Working

I have a Validation Setting column which seems not to be working with the formula =RTW>=StartDate and I get 'Something went Wrong', however it works if I have the formula =RTW=>Today() it does ...
0
votes
3answers
59 views

How to grant permissions at the column level Document Library

I'm using SharePoint 2013 I have a document library in which I would like to grant permissions at the column level, I mean that I want to show certain users some columns and not all. I've been ...
1
vote
2answers
25 views

How to total the number of selected columns that have string data?

Within a SharePoint Online list, if I have a record that has 6 columns like so... ID: #id of this record Title: "my first test" Step 1: "apple" Step 2: "grape" Step 3: ...
0
votes
1answer
88 views

Identifying the Field ID for updating an Item based on a condition in a Workflow

Based on a condition in a workflow I want to update an item that has been approved in the workflow. On the conditional branch that indicates "Yes", after I Identify the Site Address, and ...
0
votes
1answer
238 views

How to set field as hidden in list content type using API?

I need to set field as hidden (not visible on list form) using REST API. I don't know how to setup command. I found location of this parameter in xml but I don't know how to refer and update them, you ...
0
votes
0answers
84 views

Disable sharepoint column JSON formatting in edit mode

Is there a way to use JSON column formatting only in Sharepoint list view mode and NOT to use it in edit mode? The things is I am using a Multiple choice column in my Sharepoint list and formatting ...
1
vote
1answer
63 views

SPFX - Update list with a new field fails

I'm trying to deploy a new field (column) to a custom list that has been deployed using a SPFx Extension. The field gets added to the site, but it does not get added to the ContentType. I've been ...
0
votes
2answers
337 views

Create list columns in SharePoint Online site through SharePoint Online Management Shell

I have a requirement to create large number of columns in a SharePoint Online custom list through SharePoint Online Management Shell. I can't find any script to get this done. I want the PowerShell ...
0
votes
1answer
21 views

Version history not saving properties

I have 3 environments on which I have Versioning turned on. Each of them is created from the same PnP template, and has the same logicApps/etc connected to them. On one of them however, version ...
0
votes
1answer
70 views

json column formatting - change txtcontent onhover or active css link?

I have a button for a flow that users can click in a SharePoint library [modern experience]. I'm wondering if it's possible to change the txtcontent of the button after the button is active? Just ...
0
votes
0answers
44 views

SP2013 - library settings won't let me edit certain columns

I have FULL CONTROL perms on a library that I'm working on. However, when I go to the settings, some of the columns won't let me click on them to make changes or delete them. Here are some of things ...
0
votes
1answer
50 views

When custom column deleted, internal name still exists

I have an app that pulls data from custom column by internal name. If I create the column and delete it, than create it again, SharePoint still has the internal name saved and then appends a 0 to the ...
1
vote
1answer
22 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
645 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
27 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
67 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
200 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
277 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
518 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
501 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
27 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
18 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
62 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
1answer
29 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
30 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
28 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
29 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
133 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
96 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
39 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
151 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 "...
1
vote
2answers
2k 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
22 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
40 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 ...

1
2 3 4 5
22