Questions tagged [list]

Rows of items containing columns of information.

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

List Failure - Permission - Error at Power Apps OnStart

Am I correct to assume that everyone who will be viewing the data in a Power Apps user interface will not only require permission on the Power Apps side, and but because the lists are in SharePoint, ...
0
votes
1answer
11 views

SharePoint 2013 Custom List / Document Library - Search Box

I have encountered a strange issue with the SP2013 search box. I have a series of custom lists and document libraries on the same site. The majority of them are open access to all of my colleagues (...
0
votes
0answers
12 views

Calculated (calculation based on other columns) IF OR ISBLANK AND Sharepoint Lists error formula

Can anyone help? I can't work out why this is erroring. this section =IF(OR(ISBLANK[Tech £]),"", at the start in bold makes it error. =IF(OR(ISBLANK([Tech £])),"",IF(AND([Tech Pay ...
1
vote
1answer
16 views

Searching a 365 Sharepoint List where I don't have access to site settings

We are a large organisation using Office 365 with our own tenant. I've created a List online by importing an Excel workbook. The problem is I can't get search working on the List. I've added two ...
0
votes
1answer
34 views

How we can build a sharepoint field which is Read-only + visible inside the list setting (similar to the created and created by built-in fields)

when building a sharepoint list, i always have a requirement to have a field which can not be edited using the list forms + can not be edited using quick edit grid >> so i always set the field ...
0
votes
1answer
24 views

Sharepoint Online List column link to folder in document library

I'm trying to have a column in my list that links to a folder in my document library which has a name that matches the Quote number of the item. So my list has the columns 'Name', 'Customer', 'Quote ...
1
vote
1answer
29 views

Display units in a Number Column while retaining Thousands Seperator

I'm trying to adjust the way that a SharePoint Number Column displays its value so that it can include a specific unit of measurement. I want people to enter into the field only a Number, but for the ...
0
votes
1answer
33 views

Prevent User with Read Permission to have access to site content and site usage

I have created a group and assign the Read permission to it. I modified the the Read permission to the below to prevent the site usage and site content access. List Permissions: View Items Open Items ...
0
votes
1answer
20 views

Update List Item in Sharepoint using old Sharepoint-API in Postman

I already asked a question here: enter link description here I wanted to retrieve the x-requestdigest from sharepoint to make list-operations just using postman. The provided solution worked great to ...
1
vote
1answer
30 views

Updating Large SharePoint Lists

I am accessing large (10,000+ line item) SharePoint lists from a Power Apps user interface. I created the lists by exporting them from Excel. The list data is created in another system and the Excel ...
2
votes
1answer
37 views

List - Conditional formatting of a “cell” based on another cell in the same row

I have two columns: "LFR sign" and "Filing". I would like to: If the "LFR sign" is not empty -> "Filing " becomes red if it's empty I am sure this is quite ...
1
vote
3answers
39 views

Validation IF Column

I am stuck on a validation column, I need Date Effective From mandatory if Approval Status is equal to Approved and vice versa I need Approval Status mandatory if Date Effective From is not blank. I ...
0
votes
1answer
25 views

How can I retrieve data in Power Apps from a SharePoint list based on source list item ID?

What I want to do is have fields like FormID1, FormID2, FormID3, etc. in my Power App solution, and be able to retrieve combinations of item detail from any connected lists on load, using source list ...
2
votes
1answer
26 views

Powershell Script Sharepoint Online | how to change a value in a list item (column)?

I have a list with a list item/column 'Category'. Let's say Category has values 'A','B', and 'C'. I want to find all the values which are 'A' and replace it with 'B'. How should I do it? I tried the ...
0
votes
1answer
48 views

Link list to multiple columns from another site

I have an "Entity" List on site 1 showing all company details. Site 2 is for a specific project which i will need to select relevant parties involved in the project from the Entity list. So ...
0
votes
1answer
136 views

Catastrophic failure when publishing an InfoPath form

I have a TeamSite on SharePoint (Office 365) and used to manage all my forms using InfoPath. Since a couple of days ago, when I create any NEW list, open the form on InfoPath Designer 2013 and try to ...
0
votes
2answers
34 views

Lookup column in SharePoint list

I've searched around but couldn't find an answer for a simple question: Is it possible to add a column to a SharePoint list that looks up another column in another list? Both lists are on the same ...
1
vote
1answer
38 views

How to make a custom print button with SharePoint Designer (2013) that would print the items in a list (not from the browser side)

I want to create a custom print button in a list on my SharePoint team site that would print the list in a pretty way, based on the filter or sorting chosen (if any). The Ctrl + P prints from the ...
1
vote
1answer
65 views

How do you turn off comments on a SharePoint list? [duplicate]

I do not want users to be able to add comments to each row of my SharePoint lists. How do I turn this feature off?
2
votes
1answer
125 views

SharePoint Online, how to disable new “Comments” feature?

Anyone know how to turn this OFF? I use my own field to track comments in our document approval system, this new feature confuses users. This icon appears in custom lists: PS: And what is this?
1
vote
1answer
37 views

Assign Incrementing ID from a range

How can i go about assigning a number to a field based on what was previously selected and also only assign numbers from a range. e.g. If i have a choice field with 3 options A, B, C A = assign ...
1
vote
1answer
41 views

How do I hide blank fields/divs on lists' card/gallery view?

I have a sharepoint list being used in a visual way with the "Gallery/Cards" view format: Let's say for example I have a field in an entry that doesn't need to have information and another ...
0
votes
1answer
34 views

How to merge two lists of different domains with same columns into one new list with a new column categorizing the merger?

I have 2 lists: Student (lies in student domain) Employees (lies in employee domain) They both have same columns. I would like to create a new merged list which should also include a column called '...
0
votes
1answer
17 views

How to keep Lookup values when cloning a list?

We have SharePoint 2016 and like to create some central maintained lists (a country list, flags, locations of our company, contacts etc.). Since we have a workflow that clones a list to a different ...
1
vote
1answer
9 views

After New Form route user to defined page

I want to integrate a new form from a custimized SP list in a web page. But after submit the form I don't want that the user will route to the list. I want to define what the user will see after ...
0
votes
0answers
29 views

How to get a Power Automate flow to stop updating after 1 item in a SharePoint list

New to SharePoint and Microsoft flow/Power Automate. I have made a flow that copies the sum of a calculated column (Summa) into a currency column that can display a sum (Total). The reason of course ...
0
votes
2answers
39 views

List Validation for Multiple Unrelated Conditions (one user message)

I am a newbee and hope you can help me as I've read many other posts and still stuck. I have multiple conditions that are unrelated and attempting to add the proper formula to the validation settings ...
0
votes
1answer
19 views

.cvs export of sharepoint list removes leading zero's

My site includes functionality that exports a list as a .csv file. I can't change the fact that the list is being exported as a .csv. The problem is that when the list is exported, the leading zeros ...
0
votes
2answers
24 views

Hide List-View web part when no item is slected

Added a list web-part and list-view web part in SharePoint modern page. But when no item is selected, the list-view web part is displaying grey with connection details which is not looking good. So, ...
1
vote
2answers
39 views

Get years from date column

I have a column HireDate, a date column, and I would like to have a Seniority column number of years depending of Today's Date - Hire Date. Any help please?
1
vote
1answer
31 views

How to Show/Hide multiple column fields based on dropdown selection - SharePoint

I am using a SharePoint list in which we are using multiple columns covering different process steps to be filled based on a dropdown selection. The steps are different depending on the mission ...
0
votes
1answer
14 views

How to use CSOM, SOAP or Rest API to detect anonymous views of list items for a List?

Let's say I have a SharePoint site with anonymous view enabled for the entire website But I have a List that breaks role inheritance. How do I use CSOM, Rest API or SOAP API to detect if a List has ...
1
vote
2answers
23 views

Dynamic filtering using lists, hide information until selected

New to this forum, tried searching without any luck. I wish to hide information from a list until a selection has occurred. I'm using dynamic filtering. Example I got two lists (List1, List2) List 1: ...
0
votes
1answer
33 views

Line count in multi-line column

I have a simple custom list with multiple line column. I need to get count in each multi line column of the list item. (not word count) As of now, I am exporting the list to excel and by using excel ...
0
votes
0answers
24 views

Add a filter menu to the list page

I created Sharepoint - List as a stock list. I have a button in the column that sends a request for an item and at the same time adds a reserved flag to the item. As a result of the search, ...
1
vote
2answers
137 views

Delete Comment Box in right side of SP items

How do I remove the COMMENT box showing in the right side of SharePoint list items? It just shows up recently with no reason. Thanks much
0
votes
1answer
17 views

Patch function formula

I am testing Patch functionality on PowerApps to store records on a SharePoint list. I created a simple dropdown and button to test functionality. I do have a formula error, that I cannot figure out? ...
2
votes
1answer
29 views

Sharepoint List - The button inside the column does not work when searching

I created Sharepoint - List as a stock list. I have a button in the column that sends a request for an item and at the same time adds a reserved flag to the item. Code here: { "elmType": &...
0
votes
1answer
25 views

How to avoid the creation of the column called “Target Path”

Which types of lists can I create that DO NOT automatically create the required field column called "Target Path"? How can I avoid its creation in the beginning?
0
votes
1answer
25 views

Does column deletion make lastModifiedDateTime change?

As per the title, I want to use the lastModifiedDateTime field from a Graph API request to keep track of the state of a list. If a user deletes an entry from the list, does the field get updated, or ...
0
votes
0answers
38 views

User does not have permission to access List on Communication site

My scenario : I have a SharePoint group that have contribute permission on the site, there is a list that by default inherit from the site permission to eventually give access to the group, when I use ...
0
votes
1answer
57 views

Formatting list row based on score column Office365

I have created formatted the list as a gallery. using two columns such as created by and score. I was wondering if there are any way to do change the background color based on the score achieved. For ...
0
votes
2answers
20 views

I need it to show Yes automatically when the status is completed

I need it to show YES automatically when the status is completed and remaining as NO if is still in progress. Please share a code to make this happen. See the images attached. I have also tried ...
0
votes
2answers
26 views

SP view formatting row display

Is there any solution to hide specific row in the list using JSON for view formatting. I want to display only rows that match the terms of the current user and hide others. In Column formatting I can ...
0
votes
2answers
20 views

How to also attach folder and not just file to the SharePoint List item?

I was wondering if there is any way of attaching folders to the SharePoint List item? As far as I know, we can attach documents but we can not attach folders, is there any way of achieving this? ...
1
vote
2answers
34 views

SharePoint modern view formatting with JSON: URL returns void

I'm trying to format a List in SharePoint modern view. When clicking on the the URL "Bekijk recept" I get a javascript:void(0); instead of opening the URL. Here you can see some of the code:...
0
votes
2answers
34 views

Create calculated column that increases daily and resets on value of another column

Let's say I have two columns in a SharePoint list: [Invoice Age] - text (20, 23, 25) [Payment Status] - text (Not Paid, Paid) I'd like to create a calculated column [Invoice Age] that will increase by ...
0
votes
1answer
34 views

Reduce the size of the People Picker column

hope you're doing well. I'm on SharePoint online and looking for a solution to reduce the number of visible users in a People Picker column. I mean, if you create a "multiline of text", you'...
0
votes
1answer
52 views

SharePoint Online - Show column description or full column name when hovering the column header

We currently have a SharePoint list that has quite many columns, with describing column names making the column names take up quite a lot of width. Many of them get cut off in the middle of the name, ...
0
votes
0answers
9 views

I want to filter the the returned results of camlquery one more time and show it in listview?

So i have a value that called unitnames . And i cannot search this value with <Eq> keyword, because one data column have semicolons. But i cannot search it with <Contains> because it ...

1
2 3 4 5
113