Questions tagged [list]

Rows of items containing columns of information.

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

How to clear data from certain cells in a row (either a list or form in power apps) based on selection from dropdown

Is there a way to clear data from certain cells in a row (either a list or form in power apps) based on selection from dropdown? Example in an edit form, the user clicks on status and changes current ...
0
votes
1answer
78 views

Edit SharePoint online list header styles

I am having a SharePoint Online list which has long column names like "Agreement delivered to planned vertical" and "Status of approval from XXXX". In normal view, I'm able to see ...
1
vote
1answer
18 views

Pass whatever is at current page ID to next page using a url

I want to pass my current ID dynamically when I click a hyperlink button from my ../dispform.aspx?ID=248 page to a second page .../dispformManager.aspx?ID=@ID Does anyone have the correct code for ...
1
vote
0answers
51 views

Subtract amount from one column to another column on a site based on expense code

I am fairly new to SharePoint online and Power Automate and looking for a solution to do the following: I have two lists List 1: Budget name, Expense Code, Allowance and Total Budget available. List ...
0
votes
1answer
44 views

Powershell script to copy value of Created By user field to another field

I created a custom list and here I want to copy Created By column value to another field in same list Source Field: Created By Destination Field: Item Created User (this is Person/Group Field) I ...
1
vote
1answer
187 views

Display Current Month Birthdays Using Events Web Part

I have created an Events List in SharePoint Online for employee birthdays and anniversaries. I am using Power Automate to pull the Birthday and Hire Date for employees in the current month and ...
0
votes
0answers
7 views

How to display entries that I've searched for in a more appealing way

When I search for data in a list using the search box, if I select a specific entry from the suggestions given in the dropdown menu, it takes me to a version of the new item form but with the data ...
1
vote
1answer
69 views

List Items not clickable. Can't view items

I have 2 SharePoint lists. (List A) was created by importing Excel file, and the other one was created manually (List B). We use both Lists to input and view data. Whenever we create an item in List B,...
1
vote
2answers
27 views

How to correctly pass argument to final 'if' conditional when column formatting using JSON?

Based on the example here, I am using the following JSON to add icons next to column values, depending on their value: { "$schema": "https://developer.microsoft.com/json-schemas/sp/...
1
vote
1answer
49 views

How to separate 'Person or Group' column values by a comma and display on one line?

When you select multiple Persons from a Person or Group column in a SharePoint List, each value will be displayed on its own line, eg: Person_01 Person_02 However, a Choice column that allows ...
0
votes
0answers
26 views

Edit form showing up blank when adding Multiline column in SharePoint List

I have one list and when I am adding a Multiple line of text column in that list with Append Changes to Existing Text option selected as Yes, edit form stops loading and gives blank screen. I have to ...
0
votes
2answers
27 views

Not able to use renamed Title column in a calculated field

I'm trying to set a formula that uses the Title field which was renamed. But when I save the calculated field the SPO shows an error telling me that I'm using a field that does not exist (!!!). The [...
1
vote
1answer
52 views

Change choice column after reaching certain date via JSON in SharePoint list

I have a maintenance scheduler list with two inputs: MaintenanceStart (dateTime column) and Status (Choice column) The predefined value in status column is 'Scheduled maintenance' and I would like to ...
0
votes
1answer
19 views

Alerts Per User On Custom List Views

I have a client who has a calendar set up and they want to use alerts, but the issue is at the moment everyone with alerts gets an alert. They use the calendar for time off requests so only a user's ...
0
votes
1answer
47 views

SharePoint List View Filter

I have a choice column "Position" which I am referencing in the new list view filter to create a bunch of different views for departments. Each department can only view certain relevant &...
1
vote
2answers
86 views

How to display login user name in New Item Form in Custom List

I created one Custom Column name Employee Name it is Person/Group type, when user open New item current login user name show in this column How to do this?
0
votes
2answers
18 views

Show different column in New Item form and Edit Item form in Custom list

I created a custom list with some columns in SharePoint 2016 Publishing site. Is there any way to show different column in New Item form and Edit Item form any way OOTB.
0
votes
2answers
24 views

Customize New Experience SharePoint List with InfoPath?

Is this possible? I have created a new style list because the MS Flow works 100000000 times better than workflows. But now that I have switched to this experience, I cannot find anything related to ...
0
votes
0answers
24 views

Working with Microsoft Forms, SharePoint Lists, Attachments and external users

I am trying to figure out a way for external users to create entries inside a SharePoint list. We need to collect certain information from them and also one attachment (PDF or picture). MS Forms would ...
0
votes
1answer
15 views

Lists Vs App. when we should use each

Inside SharePoint online, we now have 2 options to create lists (mainly custom lists), either: Using App Using Lists As follow: Now in our case we want to create a ticketing system, where users ...
0
votes
2answers
62 views

Automatically update column based on date

Hopefully, somone can provide a bit of assistance. The below question has been previously submitted and answered, but I cannot find it. I have a column name, [status], that has two options, "...
0
votes
2answers
22 views

Can we create a custom permission level on our custom list which allow users to create items without been able to view/edit them

We have a custom list inside our SharePoint online >> and we want to create a custom permission level to allow users to create new items, but without been able to edit or even view them. Is this ...
1
vote
1answer
56 views

Convert People Picker to New Text Column

I have a SharePoint online list where I have a People Picker field ("PeoplePickerColumn"). I want to create a new text column ("PeopleTextColumn") in the list that populates based ...
1
vote
1answer
31 views

Why does this code works? Calling executeQuery without Load [CSOM]

First question: Why we don't need ctx.Load(web) before defining the List? I see that we use web object in defining the List Second question: Why are we not calling ctx.Load() before ExecuteQuery ...
0
votes
0answers
9 views

Populate Employee Name and his Department from AD in Custom List

I Created a custom list and it has below columns: Appointment Date and Time Department Employee Here I want to Populate Departments from Company and when I select specific department related ...
0
votes
2answers
73 views

Modern SharePoint - Date field not getting saved

Facing an issue with the Date fields in Modern SharePoint. When I type in the date or select a date and then change the year (by manually editing in the input box), it does not get saved. It used to ...
0
votes
2answers
52 views

Sending Data to SharePoint List From Checkbox HTML Form

I have used a POST before to send list items to SharePoint, although the only items that were included were text inputs so I could call the #id of that input and create the value like so: var item = { ...
0
votes
0answers
56 views

Get SharePoint Online List Items using rest api in SSIS Package

I'm new to SSIS, need to retrieve SharePoint List Items and send to SQL Server Database. I know how to do it using OData Source, but the list has a multi-select lookup column and this column is not ...
0
votes
0answers
28 views

Grant permission to SP lists, not just list elements

I have a bunch of SharePoint lists (10+) located at the root of a SP site and I would like to manage access rights (allow additional users compared to the baseline group of the SharePoint site) ...
1
vote
1answer
17 views

Faster way to create choices for column in SharePoint list?

I'm currently trying to recreate an old application built in Access in Power apps. This app includes a form with dropdown menu including multiple locations: Example: location 1 location 2 location 3 ...
0
votes
2answers
44 views

SHP 2016 Copy a list to to another List using PS

The below PowerShell I was able to copy all items from a list to another list but I am missing the metadata in the destination list. How to keep the Metadata when copying the list. Please help. #Get ...
1
vote
1answer
93 views

Customise person column with JSON

Now the settings are made to be small: Is there some way to make the person card bigger on height and font size? I use Person or Group column.
0
votes
1answer
21 views

Send email to Created by user after create new event in custom list

I created a custom list and added event content type. Here I want when new item or event created, send email to created by user. New item created Emial: New Item Created email also how to Send email ...
1
vote
1answer
105 views

Bigger font size in hyperlink column in a list via JSON

I would like to make an alternative text in a hyperlink column bigger. In a title column, it works fine with this code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/...
0
votes
1answer
38 views

Task List in SharePoint 2013

I want to export the task list which has enabled Send e-mail when ownership is assigned in the list using PowerShell: $ctx=Get-PnPContext $Lists = Get-PnPList $ctx.Load($Liss) $ctx.ExecuteQuery() ...
0
votes
1answer
24 views

How to color new list record like outlook do? [closed]

Is there any possibility to color new record on SharePoint list like outlook new emails?
0
votes
1answer
310 views

Format List View: JSON background colours 'ms-bgColor2' property - very few colours available

I'm attempting to change the colour of the bg-Color property. By standard on my list the colour is set to white. I'd like to change it to a different colour, but there are very few available to me. ...
0
votes
1answer
204 views

RowLimit not working in PowerShell Get-PnPListitem

I am trying to get few items from SharePoint list so I am using RowLimit in a query, but it doesn't seem to work. $query = "<View><Query> <Where><Eq> <FieldRef Name='...
0
votes
1answer
43 views

Convert SharePoint Custom List in Datasheet View to a Regular Custom List

I created a custom list in datasheet view and populated it with a fairly large number of items. I am now discovering a few limitations with this list type versus a the standard SharePoint custom list (...
0
votes
1answer
156 views

SharePoint Online modern list view search box - add default filter

Is it possible to tweak list view search box (Modern) and add additional filter using SPFx?
1
vote
1answer
638 views

Add background-color or any css to "Section" in List Form in SharePoint Online using JSON formatting

We have provision to create Sections in Form body by putting in JSON code. I also need to change background-color CSS property of the section. { "sections": [ { &...
0
votes
1answer
39 views

SP2016 Copy specific records from big list to anther list with PowerShell

I was able to copy all records from a big list to another list but not able to copy specific records form source list to the destination list using PowerShell as below, Any Help Please. $web = Get-...
0
votes
1answer
21 views

Getting part of the value from a column title

Silly question. We have a Document library and basically we are saving emails in a *.msg format. where the title is the subject of the email. I would like to save part of the title as an additional ...
1
vote
1answer
68 views

SP List JSON Body Configure Layout - how to add Modified (date/time)

I am configuring the display of the body using JSON of a SP List with a number of single line of text fields. Now I want to make visible the Modified (read-only Date Time) field which I added as a ...
0
votes
1answer
193 views

JSON formatting to show field value that's hidden by default?

I have a number of "utility" columns in my SharePoint online list that are used by the JSON in other columns (for example, I need to check that the "Email1" column is populated ...
0
votes
0answers
39 views

Split text based on delimiter and create a new row in SharePoint list

I have a SharePoint list that tracks the Form result. If user selects > 1 item, the list will be shown as below. Is it possible to generate 2 separate rows of information in SharePoint instead of ...
0
votes
1answer
22 views

Sharepoint list, add users (listed in a form field) to permission automatically without giving access to other list items

I have a list with permission setup as to be able to only see/modify list items created by a user. In the form we collect more names who would be responsible for this item (PM/BAs etc) and i would ...
0
votes
1answer
22 views

Separating Emails Addresses

I created a column in a List called 'NotificationEmails'. The emails in the field are separated by a ',' (comma). is this appropriate/acceptable? Or, should each email address in the field by ...
0
votes
1answer
233 views

Making a lookup case insensitive in a SP List

I have a list column lookup with another list, however I noticed when I create a new item the lookup is case sensitive and very strict (for example Domain (DNS) won't appear if you type DNS or domain, ...
0
votes
2answers
52 views

Get-PnPView : Object reference not set to an instance of an object

I need PnP command to check if view exist on list before creating view. Get-PnPView -List "list1"-Identity "view1" However, I am getting below error if view doesn't exists. If ...