Questions tagged [column]
columns (fields) created using out-of-the-box column types
1,106
questions
0
votes
1
answer
14
views
Add image column in content type
I created a SharePoint library and added two columns to it: one column is of the image type, and the other is of the number type.
Now, I want to include both of these columns in the content type.
2
votes
1
answer
48
views
Issue Fetching DisplayName Column Data from SharePoint List via REST API
I am facing an issue while attempting to retrieve data from a SharePoint list using the REST API. The list contains a single line of text column named "DisplayName". However, when making a ...
1
vote
1
answer
78
views
Cannot change the "Created By" column in a SharePoint list item using Graph API
I'm trying to programmatically change the "Created By" -field of a list item in a SharePoint list. As a development tool, I'm using the Microsoft Graph API python library - msgraph-sdk for ...
0
votes
0
answers
11
views
SharePoint Core Column Name issue
While I was creating a new content type based on Document, I accidentally renamed the core column name 'Name' to another value.
Unfortunately this has perpetuated to other content types based on this ...
0
votes
0
answers
28
views
Column name getting changed
I have created 3 Single line of Text columns named L1, L2, L3
In list the display names show correctly, however internal name of column got generated as _x004c_1
What could cause this? Is there any SP ...
0
votes
1
answer
51
views
How do I make a column in a Microsoft SharePoint an auto-incrementing identifier that the user can not edit?
How do I make a column in a Microsoft SharePoint an auto-incrementing identifier that the user can not edit?
I want it such that an ID field is incremented automatically when a user enters a new row ...
0
votes
1
answer
77
views
Problem on JSON formating with a connected field of a lookup Column
In my List A I have a lookup column "CODE PROJET" and one connected lookup column "FIN RECONDCT" both coming from an other SharePoint list B.
On a field of the A List I try to do ...
0
votes
1
answer
13
views
Use JSON to calculate Average
Can anyone please help !!
Im using a 2x SharePoint Online lists.
One list contains a REGISTER
One list contains a list of ACTIONS to be taken against items on the REGISTER list
I have managed to ...
0
votes
1
answer
96
views
Why can't I update author field in SharePoint online using pnp powershell?
I have tried to update the Author field in a library or file in SharePoint online, and it throws an error, like it Author field is read only. Yes, I know what read-only means, but why this difference ...
0
votes
1
answer
106
views
What is the best SharePoint column type to store latitude and longitude inside our custom list
What is the best SharePoint column type to store latitude and longitude inside our custom list?
1
vote
0
answers
51
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 ...
0
votes
0
answers
38
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. ...
0
votes
0
answers
33
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 ...
0
votes
1
answer
174
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 ...
0
votes
1
answer
31
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 ...
0
votes
2
answers
151
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 = "...
0
votes
3
answers
2k
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 &...
1
vote
3
answers
259
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 ...
0
votes
1
answer
46
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
88
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
767
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 ...
1
vote
1
answer
82
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 ...
0
votes
1
answer
24
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 ...
0
votes
1
answer
46
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
542
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 ...
0
votes
1
answer
1k
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 ...
0
votes
1
answer
2k
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?
0
votes
1
answer
439
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%...
0
votes
1
answer
902
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.
0
votes
1
answer
141
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
vote
2
answers
530
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 ...
0
votes
1
answer
264
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
407
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
261
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 "...
1
vote
1
answer
746
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 ...
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
177
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
1k
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
1
answer
57
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
717
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
1
answer
338
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
0
answers
13
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
2
answers
255
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
0
answers
155
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
1
answer
151
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
1
answer
147
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
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 ...
1
vote
1
answer
3k
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
0
answers
72
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 ...