Questions tagged [column]
columns (fields) created using out-of-the-box column types
1,098
questions
1
vote
0
answers
20
views
SharePoint list search for choice columns
I am having an issue with searching a list based on the contents of a choice column. I seem to be able to search by text-based fields, but I have an important field called Category that is a choice ...
- 47
0
votes
0
answers
15
views
Exclude list column from affecting search
I have a SharePoint Online list that I would like to be able to search efficiently using the list search bar. There are around 30 columns but only 5 that I want to use for the purposes of searching. ...
- 47
0
votes
0
answers
21
views
Method 'SetValueForUICulture' don't set other language value
I have a problem with SetValueForUICulture method in my PowerShell script, I added field using method Add-PnPField and later according to what I found on the internet I tried use SetValueForUICulture ...
- 1
0
votes
1
answer
34
views
Need to hide column data when it is folder or display data when it is file on SharePoint document library
We are using "Column Formatting" option on SP document library for particular column. When it folder, then that option need to hide, if it file or document inside the folder, then option ...
- 105
0
votes
1
answer
25
views
Hide a field only in NewForm
I have an SPO list for which I am using OOB forms.
I need to hide some fields in the NewForm, but show them in EditForm.
The list was created dynamically as mentioned here.
However, I am in a bind on ...
- 332
0
votes
2
answers
69
views
Delete a managed metadata site column from a library only
In SPO, i am trying to delete a Managed Metadata Site Column from a library. I'm using the below script to delete:
$SiteURL = "https://Abc.sharepoint.com/sites/SiteName"
$ListName = "...
- 1,502
0
votes
2
answers
711
views
Customizing PnP Search results
I have added some columns to a Document Library. I want to use the PnP Modern Search Results V4 to display the results but I am stuck trying to get columns that I added to display. I'll use this &...
- 149
1
vote
2
answers
119
views
Set index on a column in a large list programmatically
I can manually set an index on a column in a large SharePoint list (10000+ items) but I'm not able to do it programmatically.
With (PnP) PowerShell I've tried:
# get context
$Context = Get-PnPContext ...
- 11
0
votes
0
answers
52
views
Column Custom Formatting Not Working: On Prem 2019
What do I need to do, to get Custom Column Formatting to work?
Do I need to use a specific view?
Is there a feature that I have to activate; I didn't see anything obvious in Site Settings?
I am trying ...
- 379
0
votes
1
answer
26
views
Automatically delete the selective items from columns
I have a list which I use as a means for people to answer questions that I ask (think of an audit).
I have 87 rows and the first column is the criteria question which I have already filled. Then the ...
0
votes
1
answer
42
views
Unable to get "schemaXml" for a field using Rest API
I want to get "schemaXml" for a field, using this Rest API:
https://***.sharepoint.com/_api/web/lists/getbytitle('Documents')/fields?$filter=Name eq '_EndDate'$select=schemaXml
But I got ...
1
vote
1
answer
383
views
When adding a column the column appears in parent folder
I have created a Content Type called "Contracts Folder" where I have created some columns like "Contract Start Date" and "Contract End Date". I have a parent folder ...
- 25
1
vote
1
answer
48
views
Start and end columns in folder structure
I need two columns in my folder structure with contracts where I can type start date and end date. I have tried: "+Add column" --> "Date and time". The result is that it applies ...
- 25
0
votes
1
answer
12
views
Add a Column to the "Used By" Section of a Discussion Board in Classic SP
I have created a discussion board in classic SharePoint. By default, there are three things you can choose when creating a new discussion: Subject, Body, and selecting whether or not your discussion ...
- 1
0
votes
1
answer
36
views
SharePoint Online managed metadata column
I have a managed metadata column called 'year' - 2021, 2022, 2023 etc. This is in a SharePoint Online list.
It was working ok until around 3 days ago.
when i 'filter by' column, i now see the ...
1
vote
1
answer
127
views
Uneditable column
I have a column in the SharePoint list in which the name of the person who edited the previous column appears (using a power automate), I need this column to be no longer editable after the name ...
- 57
0
votes
0
answers
24
views
New list columns not showing after tick
I created a list and made views for each department. They all looked the same. I then added more columns but they didn't show. I went back in to default view and ticked them but this did not show ...
- 1
0
votes
1
answer
700
views
PowerApps - How can I reference the Created By SharePoint field in the form?
I am modifying a SharePoint form in PowerApps, and I'm trying to populate a text field based on whether or not the Created By field (from SharePoint) is populated. Essentially I'm trying to set a ...
- 363
0
votes
1
answer
983
views
Is it possible to change the column type of a column while the list already is created?
Is it possible to change the column type of a SharePoint column while the SharePoint List is already created?
- 99
0
votes
1
answer
284
views
Schema/structure of objects returned from RenderListDataAsStream and List/fields
Modified RenderListDataAsStream request:
curl --request POST \
--url 'https://XXX.sharepoint.com/sites/pilotTeamSite/_api/web/GetList(@listUrl)/RenderListDataAsStream?%40listUrl='\''%252Fsites%...
- 11
0
votes
1
answer
660
views
Yes/No nullable column on SharePoint
Is there a way to add a nullable by default Yes/No column on SharePoint list item?
Displayed as non-checked radios [ ] Yes [ ] No, or grayed/undefined checkbox.
- 121
0
votes
1
answer
88
views
Add a right sided border to a column in a list in SharePoint
I'm hoping to add a plain black border to break up the columns on what is going to be a list with a lot of columns.
Thank you!
- 1
1
vote
2
answers
421
views
PowerShell to determine where a specific column has been used
I am trying to come up with a script to find out in which document libraries under the site collection, a specific column (Company name) has been used.
I am using SharePoint online.
Is this something ...
- 559
0
votes
1
answer
210
views
why does a URL Link open to edit mode of SharePoint onlie list
why does a URL Link open to edit mode of SharePoint online list. i have site where u have to click a url link that should take you to another page, rather it takes you to edit mode of the list id item
1
vote
1
answer
336
views
SharePoint online column formatting seems to affect Edit In Grid view
Even the most basic JSON column formatter seems to make the Edit in Grid view search results list box render blank. I've tried using @currentField.lookupValue as well as much more complicated ...
1
vote
0
answers
217
views
Sharepoint REST API columns(fields) and content types modification
Does SharePoint REST API have some sort of modification time, flag, change token or ID for columns or content types modification?
For example, for a list item i can get last modified time from "...
- 11
1
vote
1
answer
603
views
Sharepoint Online - Hide Column based on content type
so basically I have a library of nested folders and a column with a request approval button.
I'd like to be able to hide the button for all folders and leave it visible for all files. I've tried a few ...
- 11
0
votes
1
answer
35
views
hide a specific Sharepoint form field if the user is not the creator of the record
I would like to hide a specific Sharepoint form field if the user is not the creator of the record.
I'm trying to use conditional formatting without success.
Some one can help me?
Thank in advance
0
votes
1
answer
120
views
How do I delete a list column?
In a SharePoint list, I have somehow ended up with duplicate columns of the "Title" column. I only want to keep the original column title.
Besides hiding the columns, how do I remove these ...
1
vote
2
answers
916
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, ...
- 11
0
votes
1
answer
53
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
1
answer
525
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 ...
- 3,010
0
votes
1
answer
243
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 ...
- 165
0
votes
0
answers
12
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
1
vote
2
answers
234
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....
- 11
0
votes
0
answers
126
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.
- 1
0
votes
1
answer
107
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 ...
- 1
0
votes
1
answer
110
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 ...
- 50
2
votes
1
answer
2k
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 ...
- 135
1
vote
1
answer
2k
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
...
- 135
0
votes
0
answers
60
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
1
answer
2k
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 ...
- 363
0
votes
1
answer
1k
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 ...
- 363
0
votes
1
answer
416
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!
- 101
0
votes
3
answers
2k
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 ...
- 53
1
vote
2
answers
80
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:
...
- 1,329
0
votes
1
answer
506
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
1
answer
655
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 ...
- 1
2
votes
1
answer
375
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 ...
- 25
0
votes
2
answers
881
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 ...
- 3,650