Questions tagged [column]
columns (fields) created using out-of-the-box column types
1,118 questions
0
votes
1
answer
31
views
SP2019 & jQuery: On Choice Selection, Concatenate Date + Choice-made + Modified By, Send to Mult Lines of Text Field
One of the most frequent questions I get on a SP2019 Classic List is "what, when, who":
What Choice option was selected, by whom, and when?
Using [MyChoice] choice field and [MyMultiLines] ...
- 157
1
vote
1
answer
25
views
SP2019: Freeze Column 1 when scrolling right
I am looking for a way, in a SP2019 List, to freeze Column 1 (or Columns 1, 2, 3) when scrolling to the right. I do not have access to SPD. JQuery would be great.
Thank you!
- 157
0
votes
1
answer
33
views
Display List GUID and List Name In SharePoint Online Column in View
I'm trying to display the list name and the list GUID in the default view of a SharePoint Online list. Is this possible? I haven't found a calculated column method or JSON formatting method but I ...
- 1
0
votes
1
answer
19
views
Need help with validation formula for document list in SharePoint list
I am trying to apply validation to document title column, we replacing spaces in title with dashes manually, Validation should fail if it cant find dash in title column, but only want to apply it to ...
0
votes
2
answers
83
views
List columns does not appear in search config after 2 days
I have created a new Content Type with custom columns.
Some of them must be indexed, so I need to link them to some RefinableString values.
But after 2 days I have created these columns, in the Search ...
- 103
0
votes
1
answer
36
views
Can we add "#N/A" to the people picker field in the sharepoint list
Can we add "#N/A" to the people and groups field, as we don't want to leave it blank if there is no allocator.
- 1
0
votes
0
answers
37
views
Modified by Column for Changes to Specific Column
I have a document library which users and their managers need to provide acknowledgement on documents. We do this with a date field for both manager and user (Manager Acknowledgement and User ...
- 1
0
votes
0
answers
51
views
Help! Get Column Names (not internal) in a Track SharePoint Column Changes Flow
I'm building a flow to track column changes in SharePoint, following this video.
It all works great, except I'd like the notification email to show the column display names instead of the internal ...
- 1
0
votes
0
answers
9
views
SharePoint Tracking List Glitch - Last Row gets deleted when a column is added or hidden
I set up a team SharePoint site using the Project Management template. It includes two separate tracking lists. An annoying glitch in both lists is that if I add or hide a column, it will delete the ...
- 1
0
votes
0
answers
25
views
Document library web part + column
I have a need and don't know how to solve it. I have a document library and I'm displaying it on a page through a document library web part.
I would like to have on the right side of the listing a ...
0
votes
1
answer
296
views
In PowerApps column chart, how ow do you deselect a selected column
I am using PowerApps charts to control a gallery. The Pie chart works fine I can select a wedge in the pie and it filters the gallery - to clear the selection all i have to do is click outside the ...
0
votes
0
answers
41
views
Add Custom User Property to "Show Field" section in SharePoint list
I have SharePoint 2019 on prem and in one Site Collection i have a list and i want to create two new columns with the information type "Person or Group" then choose for the first column the ...
- 101
0
votes
1
answer
60
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.
- 41
2
votes
1
answer
198
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 ...
- 2,346
1
vote
1
answer
390
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
13
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
36
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 ...
- 3,556
0
votes
1
answer
387
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 ...
- 101
0
votes
1
answer
218
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 ...
- 1
0
votes
1
answer
65
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 ...
- 13
0
votes
1
answer
427
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
129
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
89
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
1
answer
434
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
51
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
287
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,522
1
vote
3
answers
4k
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 &...
- 159
1
vote
3
answers
453
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
1
answer
131
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
148
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
2k
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
117
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
35
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
60
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
895
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
1
answer
2k
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 ...
- 445
2
votes
1
answer
4k
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?
- 145
0
votes
1
answer
674
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
1k
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.
- 133
0
votes
1
answer
518
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
746
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 ...
- 605
0
votes
1
answer
358
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
514
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
305
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
1k
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
36
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
201
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
2k
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
94
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
898
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,053