Questions tagged [list]

Rows of items containing columns of information.

Filter by
Sorted by
Tagged with
0
votes
2answers
36 views

How to protect a list in SharePoint?

I have created a list in SharePoint as a database for my access application. Since data is confidential and everyone is having access to SharePoint how can I prevent data so anyone can not access ...
0
votes
1answer
8 views

CAML Query with multiple properties

I want to use CAML query to delete elements from a SharePoint list. Right now it deletes element if they have a specific text in their title: camlQuery.set_viewXml('<View><Query><...
0
votes
2answers
22 views

SP2010 - 2019 How can I put in a hyperlink that is based on the user entry of that field or another field?

How do you create an item that takes a user entered ticket number and concatenate that with a URL to create a hyperlink to the ticket in the ticketing system. User enters ticket # 123456 URL to ...
0
votes
1answer
13 views

Print line entry from a sharepoint list

New to the sharepoint and power platform setup and wanted some advice. I have setup a simple payment request generator in powerapps and power automate where the data and its approval status gets ...
1
vote
2answers
20 views

Deleting element from list using CAML Query not working (deleteObject of undefined)

I want to delete a list element using CAML Query. The element has the value 55 in the column CorrespondingListID. This is the function I use: deleteFromHistory: function(){ console.log("...
1
vote
1answer
25 views

Text Case in a list

I'm trying to get the text in upper case in a list. The column is a choice column where i typed all the options in upper case. In searching this site and others it says to create a calculated column ...
0
votes
1answer
13 views

How do I embed a list from another SharePoint?

I am attempting to embed list content into a SharePoint page that is stored on a separate SP within our enterprise. The goal is to create a centralized dashboard for reps to see various dynamic tasks ...
0
votes
1answer
19 views

Deleting SharePoint List elements with specific values in a column

I'm a bit stuck right now. Using JavaScript I wrote a function that deletes an element from a list with a specific ID: deleteItem: function() { let siteUrl = 'mysite'; let clientContext = new SP....
0
votes
1answer
12 views

Create columns for each month

I need to create a forecast list where users can enter the projected number of staff for each project. Rather than manually entering the columns for each month, is there an automated way of creating a ...
0
votes
0answers
8 views

Advanced Boolean to Filter views

I am trying to filter an approval database. There is one tag that switches from to A1 to A2 to A3 to A4, to again, based on current approval level. There is also 4 userID tags - Approval 1, ...
0
votes
1answer
25 views

Autocomplete in text box to save it to list in SharePoint 2013

I have two lists one of the list has the column "Title" with all the data . The other list has the outcome column where i am trying to get the autocomplete of this first list "Title" column data. I ...
0
votes
1answer
15 views

After creating the first list with choice fields I cannot lookup those fields - how do I keep data integrity and still link?

I have seen older answers that I can have a calculated field for the lookup but that seems silly and redundant. I have 3 choice fields I would have to do that for for 100s of records. Is that really ...
0
votes
1answer
10 views

Moving custom list artifacts from DEV to PROD

In an On-premises SharePoint 2013 Enterprise Farm, would like to move custom list artifacts from DEV to PROD given the followings: The list with contents already exists in PROD In DEV, using ...
1
vote
1answer
31 views

How to Set Yes/No field on selected list items (if/else) using JavaScript in SharePoint 2013

In SharePoint 2013, "Discussion" list, I have created a button "fix/unfix" (Yes/No type field) discussion. But the script only works the second time and subsequent times. This script checks the value ...
0
votes
1answer
11 views

List Groups issue (2013)

Alright I have built a list that targets key words (No/Yes, see attachments). The CSS changes the background color to red for no and green for yes on particular cells within the list. This works ...
0
votes
1answer
8 views

Add color to specifc list cells after grouping by is applied

Alright ive searched a ton of different threads on here so far with no luck. I normally modify the cells in a list with red/green depending on the content within the list item column in this case if ...
0
votes
0answers
23 views

SharePoint List StickyHeaders - How do I modify relative position of headers from top of page?

After spending quite a bit of time troubleshooting the StickyHeaders script (How to make a custom list have sticky/floating headers), I finally got it working (awesome!)...there was one important ...
0
votes
1answer
44 views

Email body as the attachment in a Sharepoint list

I'm trying to create a flow that will: receive an email from a shared mailbox create a list item on SharePoint and add the email message as an attachment to that list item Preferably, when opening ...
1
vote
3answers
19 views

roll back an item in alist due to rejecttion in the approval process

Is there a way to roll back a changed item in a list due to the rejection in the approval process? Seems an item would not roll back to its previous state if an approve reject the changes due to the ...
0
votes
0answers
12 views

Create folder in attachments on costum list

I despair slowly. I want to create a folder via JavaScript and rest api in the attachments of a custom list. but I can't find an example on the internet. Who can help me? My List Name ist "Reviews" ...
0
votes
0answers
24 views

List Columns disappearing in SharePoint Online view

I have a list that was working fine for months...one day 3 columns disappeared from a view. The view has them set up, but they're not appearing. The columns come up in other views, why would this ...
0
votes
0answers
34 views

Sharepoint 2013 Custom action tokens - can I get a specific field from the current list item?

I'm trying to create a custom action for a list, that appears in the ribbon when viewing a specific list item. The list item has two fields that I want referenced in the custom action (email address ...
0
votes
1answer
34 views

Delete an item from a list by approval

I am trying to design an approval process for deleting items from a list, but barely I can find a step by step guideline for this. I was able to accomplish this process (i.e. approval) for create or ...
0
votes
0answers
13 views

Column type “file upload” not available [duplicate]

I'd create a custom list and add a new column. I want to have this new cloumn as an attachement upload column. But I could not find the type "file upload". Where I can configure the column types? I ...
4
votes
1answer
44 views

Copy a list to another list by MS flow

I am trying to replicate this https://www.sharepointsky.com/microsoft-flow-copy-list-items-to-another-list/ and was successful in the update part (i.e. when the item from the source exist in the ...
1
vote
2answers
41 views

In list, create link to a document in a library

I have a library that holds documents, of course. I also have a list that (in each item) has a few columns that lookup from that library's document properties. What I'm trying to do now is create a ...
0
votes
1answer
14 views

Automatically update list items that get their information from a different library

I'm trying to see what my options are to accomplish the following: I have a list and a library on a site. The list will provide a link to the document in the attached library, as well as display ...
1
vote
1answer
24 views

Can I use a list workflow to make changes in two different lists in SPD 2013

I want to know if I can use List workflow rather than the Site Workflow to make changes from one list to another if something has been changed or do I need a site workflow to achieve this? I also ...
2
votes
2answers
107 views

Percentage formula showing extra numbers

I'm trying to get a SharePoint formula to show a percentage of time remaining on a contract. I'm nearly there but it's showing a lot of numbers to the right of the decimal point. I've tried a few ...
2
votes
1answer
53 views

Grant access to a user based on the value of fields(columns)

I have several user groups such as X1_userGroup X2_userGroup X3_userGroup and in my SharePoint list I have several columns, two of the important one are: Asset_type, Code X1 ,1 X2 ,1 ...
0
votes
0answers
11 views

Bulk Restore Version history to specific version

Can someone perhaps help me out with the best way of restoring the a specific version for all list items. So using this method above I can retrieve the entire version history for list items using the ...
1
vote
1answer
19 views

Copy list column value to another in SharePoint Online

Within a SharePoint Online list I am attempting to update a column based on another column, all within the same list. List - TestUpdate Source Column - Created Destination Column - Scan Date I ...
2
votes
1answer
31 views

SharePoint List column validation related to another item

I have a SP list with 3 fields: "report type" (choose list "A", "B" or "AB") "Type A due date" "Type B due date". I want to set-up column validation for the due date so that "Type A due date" is ...
0
votes
1answer
28 views

List parameter not provided for web part connection

I'm new in SP and my goal is to have one list, several qChartViews will show list's data and one DateFilter web part to select date range for all charts. I created a list and defined the list ...
1
vote
0answers
28 views

Sharepoint API filter result

When using following request: [...]/_api/web/Lists/getByTitle('SVC')/items?$select=FileRef,File_x0020_Type&$top=5000 I get the top 5000 items in the result. However when adding following filter ...
1
vote
1answer
42 views

limit a user to see specific view of a SharePoint list

How can I grant permission to a user to only see a specific view of a SharePoint list and not "All Items", I cannot find any related settings in "Permissions for this list". This solution here View ...
1
vote
1answer
33 views

SharePoint list change text of term ID to Managed Metadata column

I have a list with 2 columns, both are simple text and in one I have code in other one I have termId for Managed Metadata. What I want to do is create a new Managed Metadata column and then somehow ...
1
vote
1answer
32 views

Manual Entry Sharepoint List

I have a list with a choice column with the option "Can add values manually" activated. However, I wish that at the end of the month I would be able to clean the dropdown to prevent it from being ...
2
votes
1answer
29 views

Calendar List - remove links to other views and “find an item” search box

I have a list of calendar events and at the top of the page is a horizontal row of links to other calendar views and a search box to "find an item". How do I remove these? Below is a screenshot of ...
1
vote
1answer
18 views

SharePoint list validation formula

I need help with the following: I have 2 columns in a list and when "Yes" is selected in column 1, then "Yes" must be selected in column 2 also What I need is: If [column 1]="Yes", then [column 2] ...
1
vote
1answer
36 views

JSON Coding - Delve profile pictures not linking up in SharePoint List

Wondering if someone could take a look at my JSON coding on my SharePoint list to see why it isn't linking up the User's Delve account profile picture? { "$schema": "https://developer.microsoft.com/...
2
votes
3answers
72 views

Import Excel to SharePoint custom list

I have a excel file which has 500 records and I like to migrate those records with the same column name into SharePoint 2013 custom list? What would be the best option? I have a very limited ...
2
votes
1answer
32 views

Find List Creator using PnP

I would like to identify the creator of a list with PowerShell PnP. AFAIK, I need to read the Author property, but the best I've found is the GUID of the author. > $l = Get-PnPList -Identity <...
0
votes
1answer
17 views

Working out the percentage of a term left from dats into months

I've got a field called Term months which contains the length of a contract in months and a field called Days Left which has the remain length of the contract in days. What would the formula be for ...
0
votes
0answers
13 views

Submit form and open a new one but with the same values

I would like to know a way of submiting a form and getting a new one with the same info than the previous. The thing is that there is an option called "Leave the form open". I want to have something ...
0
votes
2answers
30 views

Update Item Choice selection based on other List

I'm relatively new to all this, so I apologize if this is simply not possible or incredibly easy. I have two lists, the first is 'Projects' which is a list of various projects being worked on, and ...
0
votes
0answers
21 views

SharePoint - PreSaveAction function problems

I have a jquery control that i developed with JSLink. If I save the form the contents of the list item disappears. So I have created a PreSaveAction function in jquery that at the moment copies ...
2
votes
3answers
29 views

Delete list item versions fast!

Hey SharePoint Ninjas, I have a SharePoint 2010 list that has approx 9000 items. Now, each item has 4000+ versions (crazy I know) I cannot rely on normal foreach loop in powershell to delete it. It ...
0
votes
0answers
26 views

Lookup Column in SharePoint 2013

I have two lists. One is the 'Product' list and the other is the 'product description' list. There is a unique productId in the product list. Using jquery I have modified the Title column of the '...
0
votes
1answer
90 views

JSON conditional format column based on choice from another column

I am using SharePoint online. I have a choice column and a text column, If the choice "phone" is selected from the choice column, I want the text column to change color. For some reason it wont work - ...

1
2 3 4 5
107