Questions tagged [list]

Rows of items containing columns of information.

Filter by
Sorted by
Tagged with
1 vote
0 answers
7 views

Fetch the targeted content from a SharePoint list using Rest API

I have a SharePoint list on which Target Audience is enabled. There is a custom list SPFx webpart which shows the list items using the Rest API. I want to display the content based on the targeted ...
  • 1,467
0 votes
2 answers
16 views

How to save "Site Address" and "List Name" to variable and use it in power automate .I want multiple list to use one power automate

I have several lists with the same fields names. I'm working on a flow that I need to re-use. I want to be able to pass the site name and the list name dynamically to the flow. So basically I would ...
  • 4,162
0 votes
0 answers
14 views

Update a sharepoint list if condition met

I have been trying to create a flow which will update sharepoint list, when a user added or removed. Flow as followed: [![enter image description here][1]][1] I'm trying to achieve: When a group ...
1 vote
1 answer
16 views

Format View with AdditionalRows in Modern List

I set up column color coding based on the Due Date, but I want to extend that to the entire row. If the due date is within 30 days, the color is red. If the due date is within 60 days, the color is ...
0 votes
0 answers
9 views

Sharepoint List Calculated Column gives different results in Classic View

I have a Sharepoint List. One of the columns (called "Assessment Date/Date Re-Joined") is a date, and another column is a calculation based on that date column: =DATEDIF([Assessment Date/...
  • 101
0 votes
0 answers
7 views

How to implement save/cancel button in SPFx edit form customizer?

I built a Form Customizer for a SharePoint list, the UI and the logic works fine, but I don't know, how can I implement the Save/Cancel Method. I need only the Editform. How can I call from the ...
0 votes
1 answer
14 views

Allow users to mark or flag an item that its has been opened/read - SharePoint Online

I have got several lists and I would like to have a flag that users can use e.g yes/no to say they have read the content or not. Any ideas or resources would be appreciated. Thanks in Advance.
  • 4,162
0 votes
1 answer
9 views

I'm creating a permit tracker list, I want an automated flow to populate a column with a number based on another columns permit choice

Essentially all the permits will have specific days before to submit. I have a choice column which chooses what type of permit it is. I want to auto populate a column with how many days before the ...
0 votes
0 answers
22 views

Power Automate and Sharepoint / Microsoft 365 help

I am new to power automate and used to be good with nintex and the old sharepoint, but now i'm a little lost. I have attempted to watch youtube videos and browse these forums, but not finding exactly ...
  • 1
0 votes
1 answer
20 views

Click on Image to follow Link (JSON Custom Formatting)

I'm trying to set up custom JSON formatting with an image that is clickable to follow a link. I can display the image OK (using "elmType": "img"), and I can set up text that links ...
  • 35
0 votes
0 answers
15 views

How to show count of SharePoint list column in Power BI Table Rows?

How we can show SharePoint list column count in power BI Table Rows as shown below: SharePoint List Columns: Power BI Table Count: ( we need to create this table of counts)
  • 49
1 vote
1 answer
12 views

Validation on a list if date is not blank and Monday - Thursday

I have a form with about 10 fields. One of them is Start Date. I am trying to create a formula that will validate if a Start Date is selected and if the Start Date is Monday - Thursday. In other words,...
  • 13
0 votes
0 answers
16 views

Getting list of all users that are currently co-editing document

I have some enquires on getting all the users that currently co-editing the document, I am aware of a column in documents page called "Modified By", which I can get it by using SPList. ...
  • 3
1 vote
1 answer
16 views

Used JSON to format list view: why is my tile view in web part rendering wider than in the list?

I am using JSON to format list view in SharePoint online list. Why is my tile view in web part on site pages rendering wider than in the default list page? A related question: How can I change the ...
  • 17
1 vote
1 answer
13 views

Link to a list item from a document library

I have a SharePoint list "A" which each record has a unique number called "enq no"., when the list record is created it also creates folders in a document library. This document ...
0 votes
1 answer
17 views

SPFX provisioning list, how to index column?

I need to provision a list with my SPFX app. How do I set column indexes on some of these list fields as part of the provisioning? Is that even possible? **The fields I need to index will be part ...
  • 21
1 vote
1 answer
20 views

JSON Code to Display Different Background Colors

I've been reading a lot of questions and answers, and I still can't figure out how to get this to work, so I'll ask here. I have a Microsoft Form that I've connected to my SharePoint list. One of the ...
1 vote
1 answer
13 views

Can I use a calculated column to show whether a vehicle check submission has already been completed on any given day

I am creating a list which will be used for daily forklift checks that need to be completed via a power app. What I would like is a column that can calculate whether there has already been a check ...
  • 11
1 vote
1 answer
25 views

List item approval with conditional column

I have a list where I put a value on a date column: =Date>=TODAY()+20 so the item created must have a date more than 20 days after today. Those items must be approved by some users. But the problem ...
0 votes
1 answer
14 views

SharePoint Online List - Can Calendar View Show Images?

This list has a Flag column which is of Image column type. I created a "Flag only" calendar view to display only this image column. However on load, the views show the image filename ...
0 votes
0 answers
5 views

Deleted Designer Workflow is still showing in SharePoint

I have created a custom workflow in SharePoint Designer (Designer 2010 workflow) and added in SharePoint 2013. After testing, I have deleted it from Workflow settings. But still I can see the same ...
  • 101
2 votes
1 answer
18 views

Color coding Modified Date

I'm looking to color code the Modified column in Microsoft Lists. I know I need to use JSON but unsure of the code. I would like it to be green if less than or equal to 30 days, orange/Amber if ...
  • 23
0 votes
0 answers
22 views

Create a view with data from different lists

i have 3 different lists at work. one is about to do lists(contanis start date,end date,activity,ID) one is about avalability (last name,start date ,end date,job,id) one is about trains on focus (...
  • 13
1 vote
1 answer
20 views

Is there an alternative to "_api/web/siteusers" or "_api/web/sitegroups" that is able to return both groups and users?

Is there an alternative to _api/web/siteusers or _api/web/sitegroups that is able to return both groups and users? I'm looking for a way to return the person OR group title from a SharePoint item ...
1 vote
2 answers
19 views

Birthday List View

Using Modern SharePoint. I would like to create a SharePoint view that only displays the birthdays that fall within the current month. My list has a name(TEXT) column and birthday(DATE) column. I ...
  • 13
0 votes
1 answer
21 views

Automatically delete the selective items from columns

I have a list which I use as a means for people to answer questions that I ask (think of an audit). I have 87 rows and the first column is the criteria question which I have already filled. Then the ...
0 votes
1 answer
24 views

Json formatting - How to use the Moderation Status field

I have activated content approval on my list and I would like to format my form using the configure layout option to have a header that changes color based on the Approval Status Column. But the no ...
  • 4,162
0 votes
2 answers
18 views

Timeline / Gantt chart for Sharepoint Online

I want to create a timeline / gantt chart for tasks in Sharepoint Online. I am coming from working in a SP 2013 environment, where there was a standard Task list which had a gantt functionality. Does ...
  • 2,323
0 votes
1 answer
37 views

Power Automate selected item trigger for multiple selected items

I want to trigger a flow for the selected item in the SharePoint Online list, I have developed a flow for the selected item trigger and I could see my flow appears in the Automate section from the ...
  • 3,943
0 votes
1 answer
23 views

How to create a column in SharePoint list that reflects a previous value?

I am using an InfoPath form that has a field which changes value. How do I create a column that only reflects the very first value despite all the changes done. I am on SharePoint Online by the way.
  • 1
0 votes
0 answers
10 views

Deleting label off SharePoint list item

Morning all I have a SharePoint list for colleagues to raise adjustments on. One colleague raised an incomplete adjustment item and duplicated it, so I need to remove the duplicates and edit the main ...
1 vote
1 answer
13 views

Updating SharePoint Filters in Specific Views

I created and saved a view within SharePoint that had filters applied on a specific column. I now want to add additional values into the filtered view, however it appears to still only show the ...
0 votes
2 answers
51 views

SharePoint Date column - Format as dd/mm/yyyy hh:MM:ss

How can I format the SharePoint Date column to show value in this format: dd/mm/yyyy hh:MM:ss I know that this can be done with JSON formatting but not sure what the right formatting is required?
  • 105
1 vote
1 answer
22 views

Cannot pull image (url) with JSON

I have a lookup (choice) column - Work Location - I would like another column - logo - to pull from an image library depending on what choice was given in Work Location. After some research, I came up ...
1 vote
1 answer
23 views

List description between list name and items

Is it somehow possible to add a description between list name and items? Maybe with JSON?
  • 27
0 votes
0 answers
6 views

Attachments don't save in my custom list

Sharepoint newby here! I created a customised interface for displaying list's attachments. I need to see three attachments tabs (each tab for a different type) and save them in three different ...
  • 1
0 votes
0 answers
12 views

Create a list with a external data column

Is there a way to create a column in a list that make references to Dynamics365 data? I want to do this, because I want to make the Dynamics365 data be the reference for everything, so if I change ...
  • 1
1 vote
2 answers
49 views

SharePoint List Column Calculation formular with conditional Calculation

I am working on a fuel issuance list in SharePoint online with 3 different vehicle engines. Using the columns given below: Requester Name: (Name Field) Vehicle Location (Dropdown List) Vehicle ...
0 votes
0 answers
12 views

Consolidate link items in Sharepoint list and place in separate variables

I have gotten assistance on some code I have been work on. The assistance got me so far but I can figure this one error, Data is not a function. I'm trying to consolidate like string names loaded on ...
  • 101
0 votes
0 answers
10 views

Powerhellscript for powershell 5.1 sharepoint

How to create a script in powershell 5.1 that gets list of site collections , Url, admin, size in MB, Title, number of Share Point Lists, number of share Point document libraries, number of SharePoint ...
  • 1
1 vote
1 answer
37 views

How to get value of Calculated field in Header using JSON?

I have a calculated field based on other multiple columns. How can I print the value of it in Header?
  • 11
1 vote
1 answer
22 views

Multiple sharepoint list date column validation in list settings

I am trying to add validation on multiple dates in SharePoint list. Example: If end date is added by user the start date shall be mandatory. The start date shall not be greater than end date. =IF(...
1 vote
1 answer
23 views

Get Items returns no data

I just had a question about an issue I am facing: I am attempting to return some items from a SharePoint list for a flow on Power Automate. Currently, I'm attempting to retrieve the data for a ...
0 votes
0 answers
38 views

SharePoint list view filter by time

I have a lists of colleagues working in time shifts, with start date/time column and end date/time column. I want to create a gallery view, that shows ONLY colleagues ON DUTY based on current date and ...
  • 13
0 votes
0 answers
13 views

Change List ID to Text

I have a SharePoint list and when I export to Excel, one of the drop downs (which is a reference to another list on the same site), the ID is imported, not what that ID represents. Example: I created ...
0 votes
1 answer
31 views

Colorful Modern Calendar Not Working

I have 8 projects total in the calendar view. For some reason, only Projects A-E are colorful while F-H stay gray. Is there something wrong with the code below? { "$schema": "https://...
  • 37
0 votes
1 answer
22 views

How can I active QuickEdit with Javascript?

we're customizing a lot of customers sharepoint sites and we need to turn on/off QuickEdit multiple times, I want to create a Bookmarklet to achieve this, but the setting can't be found. I've tried by ...
  • 1
0 votes
1 answer
12 views

how to export display column name in sharepoint online export to excel instead of internal column name?

how to SharePoint online export to excel shows internal name instead of display name? how to export display column name in sharepoint online export to excel instead of internal column name
0 votes
1 answer
21 views

How do I feed responses from a multilingual Microsoft Form (English/French) into a single SharePoint list using Power Automate?

I am having a hard time trying to feed responses from a multilingual Microsoft Form into a single SharePoint list using Power Automate. How would I approach this ? Thank you.
0 votes
1 answer
22 views

How to check for a date/nulls and compare to the current date?

=IF(ISBLANK[Version-created];"";[Version-created]+365) =IF([Version-created]="";"";[Version-created]+365) I created these formulas to first detect if there is a date in ...

1
2 3 4 5
129