Questions tagged [list]

Rows of items containing columns of information.

Filter by
Sorted by
Tagged with
1 vote
1 answer
13 views

Upload Attachments on SP CUSTOM list

I'm using HTML to create a custom list with bootstrap and then JSOM to manipulate and display the list on a SP custom list. I am looking to add attachments and I can't figure it out. Can anyone help? ...
user avatar
  • 11
1 vote
1 answer
10 views

Retrieve information from Lookup field (SharePoint list) in power automate

I am trying to create an automation in power automate, triggered when a table A is edited. Unfortunately, multiples values of that table are lookups, getting their data in other tables. When trying to ...
user avatar
  • 13
1 vote
1 answer
6 views

Why can't I change the width in a Sharepoint list gallery view with Json?

I'm fairly new to using JSON and I'm trying to create a Gallery view to use with dynamic filtering. I have the view working the way I want, but I can't get the width and height of the 'card' to be ...
user avatar
  • 11
-1 votes
2 answers
29 views

Stop users from directly accessing and using OOTB Lists

There are two type of Users on my Site. Power Users and Normal Users. I want the Power Users to have access to the OOTB Lists and they can do whatever they want with those List and List Items. However ...
user avatar
0 votes
1 answer
26 views

SharePoint List - How to determine percentage complete based on completed columns?

I have 30 columns, most of them using Yes/No, but also some text. Is there a way to have a Progress column that will automatically calculate how many of the columns have been completed and determine ...
user avatar
  • 1
1 vote
1 answer
12 views

Average Ignoring Blank Columns

Really struggling with formula on a calculated column on my SharePoint list for some reason! I am trying to get the average of 3 columns sometimes one will be blank some times there will be no blanks. ...
user avatar
  • 13
0 votes
1 answer
16 views

How Do I Link 2 SharePoint Lists with 1 ID?

I’m assisting with the build of an intake form in power apps. Currently we have 2 separate SharePoint lists linked to the power app. The issue we’re having is with the ID column. The ID column values ...
user avatar
  • 1
1 vote
1 answer
22 views

calculate the sum of months from a fiscal year horizontally from one list to a summary list

List 1- Food Jan Feb Mar Total 1000 1000 1000 3000 sum sum sum sum This list is a category and lists 2-Clothes, 3-Water, 4-Internet, 5-Misc are the same I need the sum of the columns of this list ...
user avatar
0 votes
1 answer
15 views

Show hide columns based on the logged in user using JSON formaating

I have a custom SharePoint Group, there are many members in that group. And a group of certain columns in my list that only should be shown to these custom SharePoint Group members. I am thinking of a ...
user avatar
0 votes
1 answer
19 views

Calculated column not working properly

I have a calculated column which is not working as intended. There is an 'if' condition which checks the value from a date column called 'Modified' and it sets the calculated column to 90 days after ...
user avatar
  • 103
0 votes
1 answer
17 views

Restrict Sharepoint extension to be used on one specific list

There is an extension (custom ribbon) button on top of the list, that is connected to third-party apps, updating the list where you run it. It's needed to restrict the extension to be used only in the ...
user avatar
2 votes
1 answer
18 views

Applying metadata to SharePoint Online metadata columns inherited from a content type

I have a series of content types created in the content type gallery of the SharePoint admin center. I am trying to apply metadata in bulk using PowerShell to columns inherited from those content ...
user avatar
0 votes
2 answers
21 views

Using JSON to hide or show row depending on a row value

Can anyone explain this? I wrote this JSON back in June. It's to show birthdays for the current month. I have a simple list with a date field. To hide rows that are not in current month, I am ...
user avatar
0 votes
1 answer
15 views

Can I easily link from one item to another in the Issue Tracker template?

This is my first time using the Issue Tracker template in (O365) SharePoint. Other issue-tracking systems typically have some kind of shorthand where you can write #123 or MYPROJ-123 in the body of ...
user avatar
  • 103
0 votes
0 answers
30 views

How to compare two Sharepoint Lists and add Item from one list into the other one?

I've tried to compare two SharePoint Online lists. Both of them have an "email" as list item and if the email is equal then it should import the list item "Steuernummer" (German ...
user avatar
0 votes
1 answer
19 views

Conditionally show hide column is not working in SharePoint Online Grid view

I am conditionally showing and hiding the "Approver Name" column based on the "IsApprovalNeeded" column which is working fine in the form but while we try in grid view it always ...
user avatar
1 vote
1 answer
13 views

Can I change a column from Choice to Text without data loss?

I want to change a SharePoint Choice column to a single(or multi)-line text, Can I do this without data loss? What will happen to the data if I change it?
user avatar
  • 11
0 votes
0 answers
14 views

Get DateTime value from modified column with ajax call

I am wondering if it is possible to get value of modified column (datetime) if user try to edit item in SharePoint 2013 (maybe with javascript ajax call ?!) I am trying to get value from specific item ...
user avatar
0 votes
1 answer
25 views

Sharepoint list: permission levels

I'm planning to create a SharePoint list which holds user requests. List elements are created by me, the affected user is listed as requestor in a people column. I want to design strict permissions ...
user avatar
  • 139
0 votes
0 answers
9 views

Model task dependency in Sharepoint Lists - start date of task B not before due date of task A

Often tasks in projects depend on other tasks that need to be done before. That is the reason why I am looking for a way to model task dependencies in a Sharepoint List. This means I want to see at a ...
user avatar
  • 101
0 votes
2 answers
31 views

SharePoint Online list row formatting with the LookUp column string start with condition using JSON

I have a project list with the color status as Blue-PRJ1, Blue-PRJ2, Blue-PRJ3, Green-PRJ1, Green-PRJ2, Green-PRJ3, etc. The color status column is the LookUp type column. When the user selects the ...
user avatar
0 votes
1 answer
18 views

Validate time field for 23:59 format in SharePoint Online list

I'm trying to add validation to a text column in an SPO list so that entered data only contains values from 00:00 to 23:59. I referred this article for a validation code which works fine. But it does ...
user avatar
1 vote
2 answers
18 views

How to connect SharePoint online list to insert data from out side the SharePoint platform using

We have a requirement to push data from the external application into the SharePoint online list. Please guide me on the steps and specifically the how the authentication should happen from external ...
user avatar
0 votes
0 answers
17 views

How to build summary page of data from other lists filtered by a certain item/document?

I am looking for a way in SharePoint Online to build a summary page where an item is displayed at the top and a couple other lists/libraries are shown below with items/docs filtered by the item at the ...
user avatar
  • 371
1 vote
1 answer
18 views

Date Column Help

Help I help for finding a formula so that columns [Dec2022][Jan2023][Feb2023] would return a value from columns [wage]*[headcount] only if the [StartingDate] is equals to a dec 1,2022 ,jan 1, 2023,feb ...
user avatar
0 votes
2 answers
34 views

How can I make a column (Multiple lines of text) read-only?

I'm working with Sharepoint List - No Power Automate, and I'm trying to make columns read-only. I could make other columns (single line of text) read-only by making a second column of calculated type ...
user avatar
  • 1
0 votes
1 answer
33 views

Is there a way to export a list as a csv file with the Rest API?

Via the user interface in Sharepoint there is the possibility to export a list as .csv. Unfortunately, you can only load the items from the list via the Rest API, but not download the entire list as a ...
user avatar
0 votes
1 answer
39 views

SharePoint List/Ticketing System- How to keep reply emails under the same Item

I recently just created a SharePoint list which I will be using as a ticketing system. The idea is when we get an email send to "Ticket@outlook.com.au" it will produce an item in my ...
user avatar
0 votes
1 answer
17 views

SharePoint List - sort column by a conditional format

I have a conditionally formatted (JSON) date column that changes color to green if it is completed on time. Is there a way to select/sort on just the green dates? or is this something that only Excel ...
user avatar
  • 35
1 vote
1 answer
26 views

SPClientPeoplePicker.SPClientPeoplePickerDict ProcessedUserList DisplayName values

I've used this code (found on this site) to access a people picker field in SP2016: var peoplePickerID = "field title"; var clientPeoplePicker = SPClientPeoplePicker....
user avatar
  • 21
1 vote
1 answer
18 views

Need help with my SharePoint list validation formula. I cant seem to figure out how to combine the below statements. Any help is appreciated!

I have a SharePoint list with the fields listed in bold at the bottom. I currently am using the below formula to validate that when options 1 and 3 are selected, I am requiring ticket number is not ...
user avatar
0 votes
1 answer
25 views

Replicating a 'vlookup' in Microsoft Lists

I'm looking for some help with a couple of lists I'm working with. Essentially I have a main list called 'Risk Events' which has an automatically generated ID for each item, and then another list ...
user avatar
  • 1
0 votes
0 answers
25 views

Getting email address of a user who filled columns of SharePoint list

I have a SharePoint list with 100 users and they are invited to do the following: The first column has the users's name. The users have to find their name and answer the questions on column 2,3 and 4. ...
user avatar
  • 1
0 votes
1 answer
19 views

Color Code SharePoint 2013 Column based on Date Column

I followed this post on this site about color coding a SharePoint Column based on a date column. This worked really well and I got the result I wanted. I followed the answer from @chris-g. Below is my ...
user avatar
  • 43
1 vote
1 answer
41 views

JSON IF Blank IF Not Blank

I am trying to update SharePoint List Form in SharePoint Online so that when a Single Line text field is blank the Header will display a specific message and color but if there is any data in the ...
user avatar
  • 23
0 votes
1 answer
25 views

Power Automate - How can I update a SharePoint column when PowerApps form is submitted?

I have a Modern SharePoint list with a ton of columns, including a Status drop-down column. The list form is a PowerApps form. I want the Status column to populate "Submitted" when the ...
user avatar
  • 183
0 votes
1 answer
21 views

Power Apps - Hide a Drop-down field based on a Text field containing value or not

I have a Power Apps form (based on an SP list) in which I need to Hide some fields based on whether or not a text field contains any value. I can't figure out how to add hideable sections like ...
user avatar
  • 183
0 votes
0 answers
11 views

Update other items with the same title whenever one is changed

I have a sharepoint list that keeps track of current project. I have "nested" the list by having each phase of a project be its own list entry and then grouping by title. However some ...
user avatar
0 votes
1 answer
27 views

Is it possible to Import Data to a Multiple Choices Field Column in a SharePoint List?

I am currently in the process of migrating data from a previous SharePoint list to a new SharePoint list outside our organization's network. One of the fields in the original list is multiple choice ...
user avatar
  • 1
0 votes
0 answers
8 views

Edge datepicker uses "." as delimiter is it possible to change this behaviour?

I suppose this is a 2-sided question. I have a sharepoint list in which users select dates. However my sharepoint list only allows values in the form of "DD/MM/YYYY" I dont mind the format ...
user avatar
0 votes
0 answers
7 views

Folders in a List

I have two issues with a list (not a library). This list was created (years ago) and has over 5K records. The creator used "approval" feature AND folders. We have removed the approval ...
user avatar
  • 1
0 votes
0 answers
7 views

Removing unnecessary fields across SharePoint API requests

I'm currently building an app which will use the _API to pull the list into (currently) an XML format, however, there are multiplier fields that I don't really need. I have first created the API link ...
user avatar
0 votes
0 answers
19 views

Export data from SP 2013 list to SQL database with comment versions

I'm trying to figure out a way to get comments from all item versions into one column in a sql table and view, but still unsuccessful. I have listed the script I wrote below, but I can't add comments ...
user avatar
1 vote
0 answers
10 views

Filter list web part on site page for references to that site page

I have a Site Pages library and a Glossary list. In the Glossary list, I added a lookup column to the Site Pages library (allowing for multiple values). I am essentially looking to "tag" ...
user avatar
3 votes
2 answers
133 views

Compare 2 dates and conditionally format

I am trying to compare 2 dates and conditionally format one of the columns based on the result. I have a 'Due' and 'Date Completed'. So I am trying to format the 'Date Completed' green if on or before ...
user avatar
  • 35
0 votes
0 answers
8 views

Creating flow to act as Lookup

I'm looking at creating a SharePoint list with calculated columns, and need to work around SharePoint's limitation on column types. I have looked into creating a Flow to act as a look up. However, as ...
user avatar
  • 31
1 vote
0 answers
35 views

Sharepoint list formatting- contact card image, name and title with hover for more text information (about the person)

I am trying to format a list view by tailoring samples from github. I am trying to create a user profile card where you hover over the card and information about the person is shown like a short bio ...
user avatar
  • 11
0 votes
1 answer
17 views

Error Posting to Person or Group Field

When I submit the info to the list, I was getting the following error (which I assume is due to trying to incorrectly post to a Person or Group column: A 'PrimitiveValue' node with non-null value was ...
user avatar
  • 103
0 votes
1 answer
28 views

SharePoint online column update

I have a SP list, one of the columns contains different numbers. I need to replace these numbers with text. For instance, if column color contains: 1 -> replace it with the text white 2 -> ...
user avatar
  • 31
0 votes
0 answers
4 views

Syncing a SharePoint list to a calendar on SharePoint Online title page returning an error

When Syncing a List to a SharePoint title page calendar returning an error 'Error loading list; "ExecutiveQueryError; One or More field types are not installed properly. Go to the last settings ...
user avatar

1
2 3 4 5
131