Questions tagged [list]
Rows of items containing columns of information.
6,421
questions
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 ...
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 ...
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/...
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.
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 ...
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 ...
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)
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,...
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. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 (...
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 ...
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 ...
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 ...
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 ...
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.
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?
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?
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 ...
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
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 ...
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
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?
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 ...
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://...
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 ...
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 ...