Questions tagged [list]

Rows of items containing columns of information.

Filter by
Sorted by
Tagged with
0 votes
0 answers
5 views

View/edit rows in SharePoint List that only relevant to the specific team

I'm trying to create a SharePoint List in my organisation. The list is created centrally, which allows different teams to view and edit the rows that only relevant to them. There is a column which ...
0 votes
0 answers
3 views

Calculate working days between two dates by each month

I have a SharePoint list with start date and end date. I also have 12 calculated columns for each month - Jan to Dec. I want to calculate these columns so that they display working days between start ...
  • 1
1 vote
1 answer
7 views

Don't generate Card in SharePoint Online List Gallery View (JSON)

I have got a SharePoint list that i would like to display in a SharePoint Site. Different Users should only see the elements that are meant for them. This is determined by the columns Zielgruppen (...
  • 11
0 votes
0 answers
16 views

Sharepoint Lookup

I have two SP lists a source(Demo Lookup List) and a target(Demo list). The project column in Demo List is the lookup column source in Demo Lookup List giving the title values. when in edit mode if ...
1 vote
1 answer
17 views

Help passing list item ID

I'm currently using a script to display calendar events with some added styling. It's originally from: Display Calendar Events From SharePoint Calendar Lists Using Rest API I'm running into an issue ...
  • 11
0 votes
1 answer
10 views

Custom form cant save email value to list from dropdown input

Have big problem, i created custom form and one input is Person type in dropdown input. This input i limited only for persons in specific group. Problem is, if i choose one member from the group, save ...
  • 103
0 votes
1 answer
25 views

Sharepoint Lists assign task to same multiple users

I have been tasked to create some sort of digital document. In summary, our company will release safety bulletins that all employees need to read and confirm that they have read them. I would ideally ...
0 votes
1 answer
17 views

Setting different default views to modern list and web part and modifying the "See all" link URL

I know I can set a view for modern list web part in the settings of that web part and then I can also browse manually to the list itself and make a different view as the default view there. The ...
  • 768
0 votes
1 answer
23 views

Lists: group headers 100% width

When formatting the group headers in a SharePoint list I found no way to span them dynamically over the full width of the list. The DIV container is as long as it's content or bound to a fixed width ...
  • 149
0 votes
1 answer
16 views

How to dynamically hide/show a DIV area in a custom row formatter

I have a custom row formatter to display Q&A information in a list. I'd like for the display to show on Row 1 the Q, and Row 2 the A. But - I want the initial view to not display any of the "...
0 votes
0 answers
7 views

SharePoint not picking up date

I am new to SharePoint as I have just started playing with it. I have an xlsx file with two date columns Request Date and Deadline. The datatype of both of these columns is date as shown below. ...
  • 103
0 votes
1 answer
18 views

JSON Formatting a List Column - Two colors for two situations

I have a Modern SharePoint list with a Review Date column. I'm trying to configure JSON so that if the entry has Today's Date, it will highlight Red. If it is between today and 15 days from now, it ...
  • 197
0 votes
1 answer
22 views

JSON to format SharePoint List items under a Header

I have formatted a list to look like the one below. I would like to wrap them in a DIV so i can have a header above them named "Useful Tools" or something. I can't seem to get a header above ...
0 votes
0 answers
12 views

Hours as a default value in sharepoint list [closed]

How can I have a default hour for my SharePoint list? I want to set date as today (it is easy part) and also want to set the hour myself as a default time.
  • 1
0 votes
1 answer
14 views

Display only year from a date

I want to import in a SharePoint list a column containing the "year". So, I have in the import column just a number, like "2020". Then, I use the List to display is a custom React ...
  • 107
0 votes
1 answer
23 views

SharePoint list has random write protection for user

We have a SharePoint Online list which automatically sets for ~80% of the users a write protection: Unfortunately these users should have write or full access to the list. I already checked item ...
  • 149
0 votes
0 answers
28 views

SharePoint list-subaction (addSPLookupFieldXML) is invalid

I get the following error when creating a new list and using an existing list as source: Unfortunately the source list has no lookup column, only one choice column with two options (ja, nein).
  • 149
1 vote
1 answer
24 views

SharePoint list column @rowindex in descending order

I created a new SharePoint list from an excel file. in the excel file I had ID column which held a sequential number added automatically. I don't want this column to be entered manually so I used the ...
0 votes
0 answers
25 views

Error-No item exists at http://<siteurl>l/List?ID=xx&xx. It may have been deleted or renamed by another user shows up when clicking calendar events

I have created a custom form by combining the display form of calendar list and a new item form of another custom list (Event Attendees) using SharePoint designer 2013. I can add an event in the ...
0 votes
2 answers
24 views

Formatting a date column with various factors

This should be simple and I hope it is. I'm trying to get a date column to format in the following way: If the date is GREATER than 2 weeks leading up to the date, its green Is the date is LESS than 2 ...
0 votes
1 answer
16 views

SharePoint Modern List - Change fill color of column headers

I have a Modern SP list, and the client wants the column headers to be highlighted in yellow, or have a fill color of yellow. Does anyone know of the JSON I could use to accomplish this?
  • 197
1 vote
1 answer
10 views

Sharepoint List - Calculating weekdays between two dates ignoring blanks (Project Registration Date to Gate 0)

Hi I have a calculated column that counts me no. of weekdays =(DATEDIF([Registration],[Gate 0],"D"))-INT(DATEDIF([Registration],[Gate 0],"D")/7)*2-IF((WEEKDAY([Gate 0])-WEEKDAY([...
0 votes
1 answer
22 views

Filter Query with Rest API (Internal Name or New Name)

I am making a fetch to retrieve information from a SharePoint list that meet a certain criteria. I need the EndDate to be greater than or equal to todays date. I also need to other columns to equal a ...
  • 107
0 votes
1 answer
16 views

Open a custom form from New item list button

I'm looking to open a custom New Item form developed in SPFX on click on New Item button in SharePoint List, and on the edit form as well, I want my custom form to be load. How can I implement such ...
  • 886
0 votes
1 answer
51 views

Sending an email via SMTP connection in Power Automate

I am trying to use the SMTP connection in a Power Automate flow in order to customize the "From" field (customer doesn't want emails from me, SP list, or Microsoft PowerApps, rather an email ...
  • 197
0 votes
0 answers
7 views

Sharepoint 2013 list items are not appearing in workflow list

The problem I'm having is that list items are not duplicating over to the Workflow tasks. Anyone know how to fix this? The workflow tasks is selected in the settings for the workflow so I don't know ...
0 votes
0 answers
9 views

Filter Microsoft List by week and show items that fall into multiple weeks

Hi I currently have a Microsoft list that has a week start and week end date columns. I have items that run through multiple weeks, but I want them to show in each week in filtering or grouping. For ...
0 votes
1 answer
11 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?
1 vote
1 answer
11 views

Is it possible to change the background colour of the title of a column in a list with JSON?

I am trying to finalize a list and I want to change the color of my column titles. I am not an admin in my company and i cant implement CSS easily. Does someone know if its possible with JSON to ...
  • 11
0 votes
1 answer
18 views

Issue tracker with custom front end app

I would like to have an issue tracker list but I don't want anyone (besides admins) to be able to view that list. I would like to create a custom front end so that when a user logs in, they are ...
  • 103
0 votes
1 answer
14 views

Creating a list with the links to all the documents inside a document library

I am using SharePoint online. We have a large document library with PDF of contract files that we need to catalogue. We have a excel spreadsheet that contains all the info we need and importing this ...
0 votes
1 answer
19 views

Update sharepoint list column inside a timer job and also fetch its current value

I have a Timer job created to send reminder emails for attendees who are registered for the events. When is send an email, i need to update "IS EMAIL SEND" column of event attendees list ...
0 votes
1 answer
17 views

Extract correct event name for sharepoint events calendar list

I created a timer job for sending email daily for an events calendar list in sahrepoint onpremise 2016. When i put following code, it is not giving me exact event name: using (SPSite site = new ...
1 vote
1 answer
119 views

Does the Pagination Threshold setting in the Get Items action relate to how many items can be returned or how many items can be searched?

If I have a list that contains, for example, 3,000,000 items. If I apply the following settings in the Get items action: Top Count: `5000` Settings > Pagination > Threshold: `100000` Odata ...
0 votes
1 answer
27 views

Display popup notification if date entered in column is less than 21 days

I have a column named Date of Request and its type is Date and Time. I would like to enable a warning popup message/notification when the user enters a date for a requested maintenance that is less ...
0 votes
1 answer
64 views

What is the default number of items that are retrieved in the Get Items action and what options are there for getting more than 5,000 items?

The placeholder text in the Top Count field in the Get Items action says: Total number of entries to retrieve (default-all) That placeholder text communicates to me that, by default, it gets ALL ...
1 vote
1 answer
14 views

How to sort text field with first two digit numbers

I have below current order in my default column (LinkFilename). I want require orders mentioned in below. How we can do this? Current Order: 1_Project Management 10_Prototyping 11_Marketing ...
1 vote
1 answer
27 views

Calculated Column JSON link to document

I want to create a link to a document library that is automatically created by a flow. The flow creates a file in a SharePoint document library with the following string "[Field1]-[Field2"]-'...
  • 11
1 vote
1 answer
9 views

SharePoint Online Json formatting. Highlight 1 column if several others are filled in

I am trying to include a column to basically serve as a checklist for several other columns. The column 'Can we launch' is supposed to fill as green when all referred to columns are filled in. If one ...
2 votes
1 answer
40 views

Connecting List and Library on SPO

I would like to connect a List and a Library in a way that when I select an item in the List, the Library will display files that have tags related to selected item. So let's say that I have a List ...
  • 33
1 vote
1 answer
11 views

Editing a number of lists of a SharePoint site together

I don't know if this is the right place to ask but I am creating a powerapp canvas based app. My data source are saved as SharePoint list files. I have to change the column type from single line of ...
0 votes
0 answers
20 views

No Longer Able to Authenticate to SharePoint

For several years, I have had a PowerShell script that has been able to connect to a SharePoint site just fine to read and work with a list. Last week we started getting this error: Exception calling &...
0 votes
1 answer
38 views

PNP Powershell Updating Choice field

I have written a powershell script which reads off of a CSV and creates records in a list. There are duplicate customer names within the CSV but they will have a different 'interested system' field. ...
  • 3
0 votes
1 answer
39 views

How to exclude holidays from calculated column

Hey I am trying to calculated the difference between two dates excluding weekends and holidays but so fat I was only able to come across this formula IF(ISERROR(DATEDIF([Start Date], [End Date],"...
0 votes
1 answer
33 views

Hover card for groups in sharepoint lists

I have a person type field in a sharepoint list. This field accepts both groups and individuals. When hovering over an individual I can see the default person card, but nothing appears when I hover ...
  • 1
0 votes
1 answer
19 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
13 views

Linked lists: auto-create items

We need to split up information into multiple list, which are then linked in on "master list". (sample image from internet) In the sample our master list is "Orders", "...
  • 149
0 votes
1 answer
15 views

Sharepoint Security Question Deletion

How to allow a top-level user to delete items but not folders, or columns? How to go around with this?
3 votes
1 answer
57 views

(SP List) How to wrap a text in the format view?

What I'm trying to do is achieve making my own header and hiding the original header so that the users can't change the setting. To accomplish this, I found that I can change the "Format View&...
  • 43
2 votes
1 answer
16 views

Where can one find the FULL list of allowable values for directionalHint?

All I can find in the documentation is the standard four options. "topCenter", "bottomCenter", "leftCenter", and "rightCenter". But in one example (custom-hover-...

1
2 3 4 5
125