Questions tagged [list]

Rows of items containing columns of information.

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

Get data from SharePoint Online using VBScript

Good day, I have a list of contacts in SharePoint Online. I want to use a VBS on my desktop to grab the emails of the contacts, open a new Outlook email object, and put the emails in the "to&...
0
votes
1answer
26 views

How to set up data for cascading dropdown in SharePoint list without 1:1 filter criteria?

EDIT: I missed a major constraint in this question (I can't use Power Apps), so the question is no longer valid for me. I'm leaving it in case it's useful to anyone else, but I've posted a new, ...
0
votes
0answers
19 views

Format SharePoint Online List row based on multiple conditions in same field using json

From the code below, the [if(length([$Employee.lookupValue]) == 0, 'ms-bgColor-red'] portion changes a row to ms-bgColor-red if the field is empty. How do I extend this condition so that, in the same ...
0
votes
1answer
21 views

Sharepoint List, change ownership

I am trying to change ownership to a sharepoint list as I am leaving my company. The approval person who gets requests for access must be changed to someone else. Can this be done? I could not find ...
0
votes
1answer
38 views

SharePoint list: creates ';#' in choice columns after saving new item

I have a SharePoint list to which I add rows by filling 'New Item' form. One of the columns in my list is a choice column with multiple options and which also allows to add values manually. When I ...
0
votes
1answer
22 views

How to create a SharePoint list Template for a list for which threshold is breached?

I have a list whose threshold limit is breached (over 5000 items). How to create a list template for this list?
0
votes
1answer
28 views

Nested lookup columns in a list

For some context, I work within a small design team who cover the whole of the UK. Our business also offer installation services, with various offices around the country. I have a list, Projects, ...
0
votes
1answer
28 views

SharePoint list limit 5k or 30 million

I created an intense invoice form using SharePoint SPFx. The invoice form has many fields. When the user submits the invoice I have it adding to a SharePoint list called "invoice". I ...
0
votes
1answer
32 views

HTML Table for Column Description?

Is it possible to insert a small HTML table for the column descriptions. I have a bunch of acronyms that I use the description to have the definition of what they represent, and instead of having them ...
0
votes
1answer
25 views

Can we update +New button on a SharePoint List to new url

I have microsoft form to submit requests which comes and save in a SharePoint List. Users will also have access to the list. Can we make the +New button in the list to redirect to microsoft form. Can ...
0
votes
2answers
17 views

Hiding Retention Label on SP Online list

I have enabled the Microsoft Compliance Center's retention policy, mainly for our document library. However, every time we create a new record in the SharePoint list, a field called "Apply label&...
0
votes
2answers
18 views

Multiple concurrent views of a single list

I am new to SharePoint! I have a list, for which I have created a new view named as 'calendar'. Now I want to display the default view and calendar view side by side. Created a 2-column sections, for ...
1
vote
1answer
23 views

Folder of Lists inside site contents

I have a little bit large number of lists in my site contents. Is there anyway to organize them in folders under the site contents ?
0
votes
1answer
21 views

Create a clone of an item in a list2 - Update list2 columns when there are changes in list1

I would like to ask you about the following flow. I have a list (list1) that first I run a flow to update status columns based on some conditions (from blank to "pending") and then I need ...
0
votes
0answers
5 views

I enter large formula into calculated column and click ok, no errors appear, and when i click edit the column the majority of the formula is gone

I enter a fairly large formula consisting of nested IFs, ANDs, & OR statements and the formula is accepted without errors when I click ok. When I then hit edit to view the formula again, most of ...
0
votes
1answer
13 views

Column minimum value based on Content Type

I'm creating a transactions list for a SharePoint site. I have two Content Types used for this list. Sale and Production. The list items will mostly come from external sources, but in case of manual ...
0
votes
1answer
27 views

Using If-Then-Else structure to format rows based on a date column

Hoping someone can help. I have been working on this issue for a few days now (lots of googling and playing with the code formatting). What I'm trying to accomplish: I have a sharepoint site to track ...
0
votes
0answers
16 views

Creating calculated columns using data from calculated columns

I tried to create a calculated column which uses data from other calculated columns in the same list. I'm getting an error message, that the columns do not exist even though i can select them from the ...
0
votes
2answers
42 views

JSON Formatting - Capital Letter

Is it possible to format the contents of a column to show the first letter of every word entered as a capital or even format all the word to capital letters? Is this possible via the JSON formatting ...
0
votes
1answer
20 views

Can I make a calculated column that uses text in the boolean comparison but returns a number?

I'm trying to make a calculated column with a 5 level conditional as follows: =SI([Impacto Inherente]="Crítico";400;(SI([Impacto Inherente]="Mayor";300;(SI([Impacto Inherente]=&...
1
vote
1answer
30 views

Column with lookup doesn't show the selected list columns

I am having a trouble with lookup column from one list to other list, the columns are not showing in selection. I have list called Business Case and list Status report, I would like to add some of the ...
0
votes
0answers
16 views

People picker query to get user and its role

People picker are working perfectly in sharepoint 2013, but in check permission, it shows only user login name and not show user role [sharepoint analyst or ...]. What can I do now?
0
votes
0answers
18 views

Why my context menu options desapear after I added the sharepoint list to a page and hold commandbar of the list?

folks. I've created a context menu custom action for my sharepoint list, but when I added the list to a page and switched "Hold command bar" to hide it - I can't see my custom action anymore....
0
votes
1answer
26 views

How to publish several SharePoint lists to a one single document?

I am looking for an advice on how to publish several SharePoint lists to one document which will be published based on item created. Example: I have following lists: Proposal --> Description, ...
0
votes
0answers
7 views

Power Apps ComboBox show only unique values - How to deal with spaces at the end of values

I have a sharepoint list with Power Apps insert form. The combo boxes in the form use the following code to bring list of unique values from their columns. This works, however if there is a row with ...
2
votes
0answers
22 views

Updating a Sharepoint list with input from an Excel file using Power Automate

I previously did this using MS Access. I have a worksheet in an Excel file, let's call it the input, that is the source for the update for a Sharepoint list. For easier labelling, I'll call the item ...
0
votes
0answers
24 views

Start an Approval Flow from a SharePoint List item - Use Approval App in Teams - Add attachments

I would like to create an approval flow that starts when a user changes a column in SharePoint list from "Pending" to "Send for approval". The item in list, will also have ...
0
votes
3answers
30 views

How can I search lookup value in SharePoint list (Modern site)?

Can anyone help me on how to search "Partner Full Name" (#1), which are lookup values from "Partner List" (#2)? I use the Search this list box (#3).
0
votes
0answers
8 views

Export list data to excel through a custom web part

Using SharePoint 2013 here, does anyone know how I may be able to create a custom Web Part to export a list to an Excel file? Users have moved to Chrome and now get the "Microsoft SharePoint ...
0
votes
1answer
29 views

Unable to run a PowerAutomate Flow on a SharePoint List

I am unable to run a Power Automate flow within my created SharePoint list. The code which I used seems to be ok, however when I click on the button within SharePoint and try and run my flow I get the ...
1
vote
1answer
29 views

How to remove space from a title column in SharePoint online

I am sure this question has been asked many times, but would someone please be able to guide me with my issue with removing a space between title word, e.g. title "Project ABC" and I would ...
0
votes
1answer
20 views

Power Apps - Combo Box Update

I am using Power App form in the SharePoint list. My comboxes suddenly stopped working correctly. I used a code below for the Update field in the Power App form for my custom combo boxes It used to ...
0
votes
1answer
34 views

How to fill blank SharePoint List Lookup field with default value using json

The following is part of JSON formatting in a SP List that turns rows red if field LookupFieldX is empty: { "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting....
3
votes
1answer
47 views

Data Bar Color Change

I would like to format the "Data Bar" in SharePoint to change color based on the percentage. So anything under 25% should be green, 26-50 should be yellow and 51-100 should be light red. I ...
0
votes
0answers
14 views

Adding hyperlinks to a list that don't start with HTTP

I am trying to put hyperlinks into my list that start with ms-word:ofe|u| I put this at the start of the link to the sharepoint document I want to open so that it immediately opens to the word ...
0
votes
0answers
10 views

How to filter Sharepoint list through Visio diagram

I would like to create a SP Page with 2 web parts: a Visio diagram and a list. The list should be filtered based on the shape the user click at. I'm using Visio Professional 2016. All examples I have ...
0
votes
0answers
25 views

SharePoint List Filter - and/or condition? Search box?

the users wish for and/or filter conditions to apply on a SharePoint list. Example Filter-search 1 (multiple columns connected with 'or': Either column "Active" can be set on "yes" ...
2
votes
2answers
41 views

SharePoint list - Simple Row Numbering/Auto

I cannot find any simple answer for this. I have a SharePoint list. I need to have a column that will show row number that starts from 1 and then auto increments for the next rows 2,3,4,5 etc. and ...
1
vote
0answers
8 views

SPO: get a list Remote Event Receivers subscribed to some List

I've searched a lot about it but didn't find anything about it. Is there any way to get the list of Remote Event receivers subscribed to a List and its remote endpoint? I'm currently managing an ...
0
votes
0answers
6 views

SP2019 on premise - Save list as template including users & dates items added

I am looking to add some more to the following code passed on in a previous question on Saving list as a template in SP2019 on premise. I now need to know how to include the original dates and users ...
0
votes
1answer
25 views

Cannot add user to existing SharePoint list

I have a list with 3 columns - Person column, Text Column and Choice column. When I try to add a new item into the list, I start typing the person's name, the search box finds it, i click Enter, but ...
0
votes
1answer
49 views

Modify a specific column for an Item when another column is modified

For an Item in my list I have three columns, "date started", "date completed", and "# of business days to complete" Is there a way to build a flow so that when "date ...
0
votes
2answers
38 views

Format SharePoint List row based on empty column using json

How do I extend the solution provided here to highlight a row if, say, column "LookUpColumnABC" is empty? I tried incorporating if([$LookUpColumnABC] == '', if([$LookUpColumnABC] == "&...
1
vote
1answer
48 views

JSON Formatting : How to add mail link when multiple user

I would like to add the mail icon in front of multiple users. I followed the tutorials but they just explain how to put the icon when there is only one user. What I have: What I would like to have: ...
1
vote
1answer
50 views

JSON Sharepoint Row Conditional Formatting

I have been attempting to format the colour of each row via the date in my $CONTRACTEXPIRES column. I have the formatting set successfully to be red if the date has passed and green if it has not. ...
1
vote
1answer
35 views

Column validation of sharepoint list

I am trying to create a column validation based on the other column's output and I constantly get the error. I have 2 fields: Testing - choice column with the value "Yes" or null. Test date ...
1
vote
1answer
37 views

SharePoint Online list - remove column name from grouped view

I'm trying to remove column names from the grouped list. I followed the instructions given here: SharePoint Online list - format group headers to remove column name but I seem to have another issue. I ...
1
vote
1answer
27 views

Group by column name and content type in Sharepoint Online

I'm trying to refine our SharePoint List (Office 365). I have searched the Internet for answers but cannot find anything that is usable to me. I am not the tenancy level administrator just a local ...
1
vote
1answer
173 views

SharePoint list losing JSON formatting

In SharePoint Online I add simple JSON sectioning to a list form. Preview looks fine and saving the JSON works, too. But after closing the dialog and opening a list item, the formatting is lost. Going ...
0
votes
1answer
52 views

Update People picker column using JSON formatting SharePoint

Can we update people picker field in SharePoint using JSON formatting? I want to update field with current user name.

1
2 3 4 5
127