Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [list]

Rows of items containing columns of information.

Filter by
Sorted by
Tagged with
0 votes
1 answer
9 views

Calculated column issue in Sharepoint List - Excel Formula Given

I have tried to apply the following formula in the SharePoint list but somehow it gives an error. Can the same formula be used or any changes are to be made? Please help me out. I have given the ...
user avatar
0 votes
0 answers
13 views

How to get a list from a folder or document by url using javascript?

I have custom action ribbon button on document library and I have more than folder when I open folder and click on button i want to get list from this folder using javascript
user avatar
  • 1
0 votes
0 answers
19 views

Working Around Permissions Break Script Time Out/List Threshold Limitations

I have a document library with a large amount of directories and thus permissions which I would like to break inheritance of and have come across the SharePointDiary script which works perfectly apart ...
user avatar
0 votes
0 answers
13 views

Show/hide a column based on a selection from another column

I'm trying to format my SharePoint form to show/hide a column based on a selection from another column. If 'Other' is chosen from a column named 'Communication support', I'd like a free text column '...
user avatar
0 votes
0 answers
28 views

Can I change the default item count site-wide for all current and future lists?

In SharePoint Online, the default item count per page of a list is 30 items per page. While this can be modified at will, it can only be done per list, as far as I am aware. I have a scenario where a ...
user avatar
  • 219
0 votes
3 answers
28 views

How to detect enabled QuickEdit on a List or Library from client?

When trying to enforce certain business rules on list Forms, there's always the risk that users will use QuickEdit to circumvent them. Is there a way to detect if QuickEdit is enabled (or whether this ...
user avatar
0 votes
1 answer
14 views

Sharepoint Limited-access user permission lockdown mode is enabled, open word file in desktop app

I have enabled "Limited-access user permission lockdown mode", and my recipient open the word file by desktop app ,notice that the file is open as "READ ONLY" and cannot save the ...
user avatar
0 votes
0 answers
8 views

Import Spreadsheet without ActiveX workaround

I have seen this asked many places without a solution/work around ... Users are getting an activeX error when trying to use the "Import Spreadsheet" app in our SharePoint 2016 OnPrem ...
user avatar
  • 23
0 votes
1 answer
9 views

How to find the largest number from a sharepoint list column?

First time using Sharepoint Lists. Can a guru please help me if it's possible to set the default value in a column to display the largest number in the column? see screenshots below.
user avatar
  • 1
0 votes
1 answer
18 views

Is there a way to create calculated column in sharePoint based on an excel export list?

I have created a SharePoint list based on an excel list and now I'm trying to create a calculated column using one of the columns that was imported, but it seems that it's not possible. The imported ...
user avatar
0 votes
1 answer
9 views

What is the most efficient approach to pulling data (using Vue) from a SP list to then export it to Excel?

I've run across many descriptions on how to effectively/efficiently set up a click event that pulls data from a single SharePoint list and then exports the data to Excel in a Vue.js environment. So ...
user avatar
0 votes
1 answer
14 views

How to Share a SharePoint list item to specific external user?

I am trying to give access to a specific external user for a list item and the user is not added as a guest yet. How can we perform this using Power Automate/SharePoint Rest API. Note: Since it is a ...
user avatar
  • 196
0 votes
1 answer
47 views

How to display image in Sharepoint List from SQL Server

I have the following problem when I want to display an image in a column of type "Hyperlink or Picture" of Sharepoint List, the image comes from a column in a SQL Server table of data type &...
user avatar
0 votes
1 answer
17 views

How to hide certain fields in sharepoint list [duplicate]

everyone. I have been scouring the internet trying to find the solution here, and everything I'm finding isn't helping. I'm trying to figure out how to hide the 'Q' before the question. That's ...
user avatar
0 votes
1 answer
51 views

SharePoint list column formatting schema do not resolve

I have the following column formatting: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", &...
user avatar
  • 101
0 votes
0 answers
21 views

How to render an unordered list without truncation?

In my sharepoint list, I want to have a column that displays an undordered list. I can do this with a richtext column, but SP truncates it. Long ago, I would do this, and it rendered the entire list ...
user avatar
  • 3,521
0 votes
1 answer
21 views

List element: allow multiple editos

Under the advanced list settings I'm able to limit the editing of elements only for those who are listed as creators of the list element. Is it possible to have more than one "creator" of a ...
user avatar
  • 129
0 votes
1 answer
9 views

How do I view the "Created by" and other default columns?

In the settings for my list, I can see the default Created By, Modified By, etc columns. But when I just view the list on my Sharepoint site, I can't see those. How do I make them visible, just like ...
user avatar
  • 101
0 votes
0 answers
31 views

Add column to list, which shows item-level permissions

Is there a way to create a column, that shows all groups and users (SP groups and AD) that can view this item? I'm not talking about having column-level permissions as this was the only thing I found ...
user avatar
0 votes
1 answer
13 views

Trying to use WEEKDAY function to make a column always return a Friday date, based off another date column

So far I have this, anyone know why it isn't working?? Goal is to return the first Friday after the [Est. Stock Date]. =IF(WEEKDAY("[Est. Stock Date]"=1,[Est. Stock Date]+5,IF(WEEKDAY("[...
user avatar
1 vote
2 answers
20 views

Creating Column conditional formatting that are only visible in specific views

My department has a list that are used by many teams. For team's views I would like to format columns that will note affect the view of the other teams. It looks like by default, column conditional ...
user avatar
0 votes
0 answers
11 views

Sharepoint List Item Timeline

I am wanting to know how one makes a timeline for a list ITEM in SharePoint online (365) and not for the list as a whole. To give information on how I am attempting to do this: My goal is to have a ...
user avatar
  • 1
0 votes
0 answers
10 views

Dispform.aspx stuck in Classic view mode after addition of content types

I have a large Microsoft List that defaults to the Modern list mode. Recently I was experimenting (bad idea!) with content types. Specifically, what I did was: Enable management of content types in ...
user avatar
0 votes
0 answers
8 views

Sharepoint Online List - Date values not consistent

Hello, I'm currently working in a Sharepoint project with users all over the globe and we have been having this following issue: The following picture shows the version history of the item someone in ...
user avatar
0 votes
0 answers
7 views

Is it currently possible, using a SharePoint Online list, to pull each reading into a JSON/GeoJSON format using SPFx or would a database be better

I have used PowerApps to create a Project Experience form which then patches the data to a Sharepoint list in raw text. Now I am unsure of what is the "correct", or best, method to pull this ...
user avatar
0 votes
1 answer
20 views

list formatting: multiple mailto-links break code

When I use an a element in JSON to generate a mailto-link, everything works fine: { "elmType": "a", "style": { "position": "absolute", ...
user avatar
  • 129
0 votes
1 answer
15 views

Creating an auto-increment column in Lists which resets when value changes in another Column

I'm new to Sharepoint lists and I'm trying to do this below task: I have a "Module" column which has values like SAL,MAR,AUD I need ID column which should auto-generate values like SAL_001,...
user avatar
1 vote
1 answer
27 views

SharePoint List Advanced mode JSON Syntax for CC email to

I have a simple SharePoint list of email template to send an email to our customers. I have the basic JSON format that I got from here https://docs.microsoft.com/en-us/sharepoint/dev/declarative-...
user avatar
  • 11
0 votes
1 answer
15 views

Create an index that restarts in the beginning of each year

I have never worked with power automate or sharepoint lists in the past. We have a test request system that has a unique identifier of the following format: "PTL"-YEAR-Index. PTL is a ...
user avatar
0 votes
1 answer
8 views

Asset Management App - How do I filter a collection of lists displayed in a PowerApps gallery using a comboBox of people names?

I am trying to find a way to filter a collection of SharePoint Lists displayed in a PowerApps Gallery using a ComboBox dropdown. This ComboBox dropdown gets data from another sharepoint lists for ...
user avatar
0 votes
0 answers
20 views

How would you write some html code, in a basic SharePoint page table, that pulls a count from a SharePoint list on the same website?

So, I made a table that I am hoping to insert some kind of code into each cell that can pull some information from various SharePoint lists. I have some SharePoint lists that have item counts based ...
user avatar
  • 1
1 vote
2 answers
40 views

Trying to format column with another column

I have a "Completion Date" column and a "Current Step" Column in a list. I am trying to format this "Completion Date" Column so that when the "Current Step" is ...
user avatar
0 votes
0 answers
12 views

SharePoint 2016 - I found code to embed hyperlinks to Month/Week/Day calendar view, but can I embed hyperlinks to my modified Current Views?

I have set up different Calendar overlays to group different types of events, and I would like to create hyperlinks above the calendar so that users can jump between the views (All Items, Meetings, ...
user avatar
  • 1
0 votes
0 answers
14 views

SharePoint 2016 Calendar - I have code to open Events into a modal window, but how do I refresh the page/webapps after changes are made?

I am new to using code in my SharePoint pages--thank you for your patience. So I found the below code, which will make Calendar events open into modal windows, directly into Edit Item mode, but when I ...
user avatar
  • 1
0 votes
0 answers
9 views

I'm trying to calculate the Hitrate percentage of a manager for each week of the month, there are months when we have 5 weeks as well

I'm trying to calculate the Hitrate percentage of a manager for each week of the month, there are months when we have 5 weeks as well. Below is the code I'm using: =IF(OR(HRW01+HRW02+HRW03+HRW04=4,...
user avatar
  • 1
0 votes
1 answer
12 views

List: remove line delimiter

Is it possible to remove the light greyish delimiters in a SharePoint List? I already set margin to 0 but nothing happened.
user avatar
  • 129
1 vote
1 answer
50 views

How to apply 2 conditions with the flow and create the list of approvers?

I have two lists, one gets the submitted information from PowerApps and the other one is more like a matrix, to identify the people who are assigned as approvers. Identification process starts with ...
user avatar
0 votes
1 answer
22 views

Add another attachments column to sharepoint list

I've used the Asset manager template to for a list of the companies machines. This template has the attachments column enabled. This column is used for all documents for the machine. I would like to ...
user avatar
0 votes
0 answers
23 views

Cannot delete attachment from list item

I have a list and I am using the attachments column to attach a document to the list, however when running some tests it attached documents to the wrong list item and now when I try to delete the ...
user avatar
0 votes
0 answers
24 views

This table exceeds the maximum number of supported columns (300) but I only have 9

I am using list for the first time, simply testing out how it works on a small dataset that I would like to share with my team. I have formatted my existing excel file into a 295x9 table. Attempting ...
user avatar
0 votes
1 answer
19 views

Get data from SharePoint List and SQL Table - compare them - PowerShell

I want to make a script which will get data from SharePoint list (from a specific column) and also get data from SQL table (from a specific column) and compare them. If the comparison value is true ...
user avatar
1 vote
1 answer
49 views

SharePoint Search REST API does not return custom columns values

I've been trying to use SharePoint REST API to retrieve a number of files on my site but for some reason, if it does tell me the name or descriptions of the files, it returns null for every single ...
user avatar
0 votes
1 answer
24 views

want to update a field of a DevOps workitem using Power automate. This field is a text field which should have the number of workitems created earlier

want to update a field of a DevOps workitem using Power automate. This field is a text field which should have the number of workitems created earlier. I am trying to create a list item in a ...
user avatar
  • 99
1 vote
1 answer
29 views

Take value from a person or group column in a list and insert it into another list

I have a list that includes a person/group column, and I'd like to set up a flow to extract that value and insert it into a similar column in a different list. Is this possible? Not quite sure what ...
user avatar
  • 21
0 votes
1 answer
17 views

Lookup Category, Subcategory based on column value

I've used the Asset manager template to for a list of the companies machines. I would like to edit the Modell column, to be a lookup from another list. This list contains all models, but also a ...
user avatar
0 votes
0 answers
16 views

Map showing people's locations and info

i've seen an old youtube video where someone creates a map next to a list of people for showing their locations and details. I'm trying to do the same but it seems that lists don't have anymore a map ...
user avatar
1 vote
1 answer
41 views

Json formatting sharepoint list link inside gallery

I am trying to create a sharepoint list and customizing the json format of this list to make it look nice. I have decided to go with the gallery layout, would like to show a link to bring my users to ...
user avatar
  • 115
0 votes
1 answer
32 views

Conditional Duration Column in SharePoint Online

We have a SPO list with a metadata column named Status of type choice that contains the following values: Opened Closed Re-opened We want to create another column called Case Duration that will ...
user avatar
0 votes
2 answers
32 views

How can we save a link over 255 characters in SharePoint hyperlink column

I have created a SharePoint list of a catalog for certain items, Each record has a hyperlink to view the data. This hyperlink column is not letting me save long URLS. How should I handle this issue? ...
user avatar
0 votes
1 answer
40 views

How do you find where an SharePoint auto notification came from?

My issue is trying to locate where an auto notification is coming from that was sent out but ran out of ideas on other ways to try. So I have a couple users that received an auto notification from ...
user avatar
  • 43

1
2 3 4 5
130