Questions tagged [sharepoint-list]

Lists are a key, underlying feature of a SharePoint site. They enable teams to gather, track, and share information by using a Web browser.

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

Power Automate - Export people picker data from a list

We have a sharepoint list that we want to export to excel weekly. However we also want to capture the user information that's in the people picker. See screen shot below. Is this possible?
0
votes
1answer
8 views

SharePoint List and/or Calendar Custom Email

I have been tasked to create an email for a SharePoint list as well as a leave Calendar and the way that it was described is that SharePoint generates it ? I cannot find anything related to that, ...
0
votes
1answer
31 views

Creating a pretty table from a SharePoint list

I have a small list (7 items and 8 columns) which I Want to display on another public facing page. Ideally I want the end result to look similar to this table Nothing needs to be added or editable by ...
0
votes
0answers
26 views

Query sharepoint list data in sql server [duplicate]

I am trying to query sharepoint lists data with sql server,for performance reasons. Is there any tool to help me do this? I heard about spud and SPViews but i am searching for something open source or ...
1
vote
1answer
24 views

Lists: Show image overlay on mouse over

I'm customizing a gallery view in a SharePoint list containing employee photos. Now I want to overlay a magnifier icon (via the Fluent Icon library) when visitors hover over the image with the mouse. ...
0
votes
0answers
18 views

Round image in list with overlayed div

My goal is to have a list in gallery view showing employee photos with an colored overlay containing their name. The image should be rounded, has a shadow and the textbox inherites the roundness too. ...
0
votes
1answer
26 views

Unable to auto fetch MS Form Id in power automate MS Forms response submitted trigger

I am working on creating a power automate which will create a list item each time new MS form response is submitted by user. The MS form title 'Employee Survey' has been created by another user has ...
0
votes
1answer
7 views

calculated column Isnumber search

I'm trying to create an if search function so that column B displays a specific "text" when it detects a specific "text" in column A So in my formula if column A has the word "...
1
vote
2answers
46 views

Convert text to fluent icons in multi-value field

I have SPO list with a multi-value field, which is filled by a lookup list (other list on the same SharePoint). The values are the names of MS Fluent Icons. Now I want the names in that field to be ...
0
votes
1answer
32 views

Dynamic drop down Sharepoint online

I am trying to create a data capture using a Sharepoint list and I've run into an issue. I'd like users to be able to select high level queries, then based on those high level queries in an other drop ...
0
votes
1answer
18 views

Triggering an email from MS flow when a particular field of sharepoint list item is modified - Check below condition?

Original question: I am trying to build a flow to trigger a custom email sent once a SharePoint list item is created or modified, condition is to only send it if a choice value in a certain column is ...
0
votes
1answer
24 views

SharePoint List: squared image thumbnail

In my SPO list I can display images contained in the data set. Now depending on the image size (by setting the width to a fixed value) the height differes depending on the image. Can I display a ...
0
votes
1answer
26 views

SharePoint Threshold Limit

We have a sharepoint list with 6.5k items. we have created 4 separate views using indexed columns as filters. All 4 separate views have less than 2k items each. One of the 4 views can be exported to ...
1
vote
1answer
21 views

JSON column HyperText where @currentField needs to be in the Middle of the URL

I am trying to use Microsoft's Sharepoint List Dev document to do a "Turn field values into hyperlinks (basic). My code looks like this: { "$schema": "https://developer....
0
votes
2answers
53 views

Sharepoint List Threshold Limit Causing the sharepoint designer workflow to Suspend

One of the task lists which was used in designer workflow reached the threshold limit and because of which the workflows are suspending with the below error. RequestorId: f307e5c6-0c50-b022-0000-...
0
votes
0answers
17 views

Can't open an attached html file in a sharepoint list using browser

Every time I try to open an uploaded html file in one of my sharepoint lists it gets downloaded instead of opening the browsers. I found some solutions that were not optimal/doesn't work for me. ...
0
votes
1answer
87 views

Copy whole column content into array (Power Automate)

I want to bring every value of a SharePoint List column to an array. At the moment I'm using an 'Apply to each' connector to iterate the whole column and then use the 'Add to Array' connector to fill ...
0
votes
0answers
16 views

Quick launch left menu disappeared for specific list

The Quick Launch menu that appears to the left suddenly disappeared for a single list in my SharePoint site. When I go to site settings, the Quick Launch is still enabled. It's simply disappeared from ...
1
vote
1answer
7 views

Column 1 and 2 are equal or the same then column 3 defaults to yes

I want to change a column to yes if two other columns are equal, so same title and report week. So if report week column and title are the same, then duplicate entry is yes. =IF[Report week][Title]<...
0
votes
1answer
64 views

Using Json to check if a column contains certain text

So I have this sharepoint list with a (for example) "Date" column, and I want to check if any of the rows contain certain text. For example, in the rows it will either say "The due date ...
0
votes
1answer
25 views

How to search “people and group” list items in an entire site collection for a particular user and replace that user in powershell?

There are lots of ways a person could be displayed in a list using a "people and groups" field. I have a script that will find and update a user if they are being displayed in a list as &...
0
votes
1answer
55 views

SharePoint Online List performance slow on new item

SharePoint Online List performance issue, when i click on new item or new form i face delay in opening new form. I was wondering how improve the performance of the list library. I have more than 1k ...
0
votes
0answers
13 views

Sharepoint list field 'Created by' shows username

I created a workflow that every form that is submitted gets recorded in sharepoint list. The flow works perfectly, but the 'created by' field does not show the user name of the person who submitted ...
0
votes
2answers
42 views

Sharepoint Calculated Column - Get last instance of substring

I need to get the last value after , from the string. e.g. 10%,90%,12% It should return 12% =RIGHT([Payment Term],LEN([Payment Term])-INT(FIND(",",[Payment Term]))) I used the formula above ...
1
vote
2answers
14 views

Calculated column using 4 different columns to derive an “approve” or “Decline” answer

I would like to use an IF function to obtain an answer to "Approve" or "Decline" within a SharePoint list. My formula works in Excel but not in SharePoint. I have 4 SharePoint ...
0
votes
1answer
39 views

Flow/SharePoint List limitations

I'm planning a company wide software rollout and wanted to control the communication with Lists and Power Automate. All employees (~9000) would be stored within a SharePoint List containing email, ...
1
vote
1answer
18 views

Return list values from column type 'User' and replace that user if they exist using PS in SP2016?

First off my code is this. foreach ($list in $web.lists) {​​ foreach ($field in $list.fields) { if ($field.type -eq 'User') { write-host $list.Title ...
0
votes
2answers
37 views

Adding a Microsoft List inside a sharepoint site will not have any site content type

Inside our modern team site i added some Microsoft lists as follow:- but i have noted something is that inside these lists >> their content types only contain list columns and there are not any ...
0
votes
1answer
32 views

Sharepoint List attachments migration to online Environment

I have been tasked with migrating a list from an Sharepoint 2013 environment to Sharepoint Online. Searching through the tools used to migrate such content, i have decided to use the SPMT in order to ...
0
votes
1answer
143 views

Get-PnPList cmdlet not returning anything

I'm trying to retrieve information from two columns on a sharepoint list in order to use them in powershell. Here's my code so far: $SiteURL = "https://xxxx.sharepoint.com/sites/xxxxx/" ...
0
votes
2answers
52 views

Generate Change/Audit log for a specific SharePoint list

I am new to SharePoint and unable to find a solution on Google. I want to be able to track changes done to any item on the SharePoint list. I have tried the audit log reports available but I am not ...
0
votes
1answer
117 views

How to set the SharePoint field value dynamically over a button click in edit form using PowerApps

I have a list with edit form has been customized using PowerApps. On edit form opening the fields have been rendering the selected item's respective values. Over the form I have a button which do some ...
0
votes
1answer
24 views

Hide unused time slots in a weekly view calendar

I have a calendar that I have placed on a site page that uses the weekly view. My organization uses GMT (Zulu) time and that is the regional time zone used. The calendar in the weekly view takes up ...
0
votes
1answer
28 views

Hide / Show column based on another column choice

I have a list for our helpdesk that has a column "Subject" and a column "Computer Issue". Our helpdesk team wants to hide the "Computer Issue" column from the new form ...
1
vote
1answer
38 views

Query Another List for All Data Containing Keyword

I have two lists, one is an asset tracer that contains computer names (table1). The other is a log that contains a description of all the work done on the asset (table2). It contains pc names, an ID, ...
0
votes
1answer
37 views

Copying data from one entry into a new entry in a sharepoint list

I wonder if you could help. I'm trying to create a log (of sorts) using a SharePoint list (i know it may not be the best option out there however its what i've been give lol). One of the things that ...
1
vote
2answers
22 views

I am trying to force three fields to be populated if the value of one field is a specific item

I can validate one field with no problem but everything I do to validate multiple fails. I need to add another two though so FIELD3 and FIELD4. =IF([FIELD1]="Specific Value",IF([FIELD2]<&...
0
votes
1answer
85 views

How to format toLocaleDateString([$MyDateTimeColumn]) to return YYYY-MM-DD?

I have JSON formatted a column with the following: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "...
1
vote
2answers
31 views

How to Create Calculate column using other Lists

I have a DB on my SharePoint site using several Lists. For one of the lists I need to count Total, Pending and Completed records from the other tables. There's one list for each department and on it ...
0
votes
1answer
22 views

Different user access to different sharepoint views

I have a sharepoint list with 10 columns. I want to give access to two different users. User 1- Can edit all 10 columns. User 2- Can only edit 6 columns.
2
votes
1answer
111 views

Multiple sharepoint list column validation in list settings

I am new to SharePoint and Power Automate. I have to put multiple conditions in SharePoint list validation settings. Example: =IF(ISBLANK([Unit Amount]),TRUE,[Unit Amount]=[PO Amount]) Which would ...
0
votes
1answer
72 views

Sharepoint list: How can I calculate difference between two dates without Fridays and Saturdays

I need a formula that can calculate difference between 2 dates without calculating Fridays and Saturdays. I need to use this formula to create a calculated column in list. Thank you
0
votes
1answer
65 views

Not able to change the column datatype in the SharePoint List

I have a SharePoint list created in the SharePoint Online. In the list I have few lookup columns besides normal ones. I'm trying to change the datatype of a column from Single Line of text to Number ...
0
votes
1answer
665 views

Comparing 2 Sharepoint lists using Power Automate

I wanted to compare two sharepoint lists. one is forecasted expense against each resource for a particular month and other sharepoint list is the actual expenses that has come. The two sharepoint ...
0
votes
1answer
62 views

Sharepoint list - Infopath form set default attachment documents

I have a Sharepoint list and need to add 2 documents as a default attachment to each user-created form on creation. The form is made with InfoPath 2013. I have an attachment field and it works fine, ...
0
votes
1answer
43 views

Sharepoint online list view threshold reached on execution of a caml query

I am having a hard time understanding how a caml query fetches data from a SPO list. Currently, i have set up a client context on an CSOM console application and i am trying to upload a csv file onto ...
0
votes
1answer
55 views

App which will user to upload an excel sheet and update the sharepoint list with the rows in the excel

trying to build a powerapp which would help user to upload an excel sheet via app and update a sharepoint list with the rows in the excel sheet. Request to help/suggest how can this be achieved.
0
votes
1answer
25 views

Submitting Data via Infopath form to a Sharepoint List

We have an infopath form that is used to submit data to a sharepoint list. This form allows a user to enter multiple selections using a people picker and also multiple selections using a repeating ...
0
votes
2answers
85 views

SharePoint delegation for powerapps [closed]

How to control the delegation to avoid the warning? It is limited to my subscribe 365 account.
1
vote
0answers
18 views

SharePoint 2016 List - Edit Form - Radio Buttons

I have a SharePoint List to collect some information. I have two radio buttons and based on which radio button is selected, only specific fields will be shown and the others hidden. This works great ...

1
2 3 4 5
7