Questions tagged [column]

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

Filter by
Sorted by
Tagged with
0
votes
0answers
9 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
68 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
16 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
30 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
20 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
26 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
55 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
29 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
33 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
22 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
25 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
75 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
32 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 ...
0
votes
0answers
34 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
129 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
19 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
44 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
42 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
27 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
19 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
280 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
26 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
25 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
115 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
152 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
110 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
266 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
24 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
16 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
52 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
69 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
28 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
26 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
68 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
57 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
35 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
107 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
1k 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
39 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
22 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
76 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
107 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
1k 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
1answer
221 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
28 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
339 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
245 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 ...

1
2 3 4 5
22