New answers tagged list
0
Currently there is No way to use target Audience in SharePoint Modern List view.
Check if below workaround works for you.
Workaround:
Go to your SharePoint list.
Click on Return to classic SharePoint (You can find it below left side navigation - bottom left corner of the page).
Click on Settings (Gear icon) --> Edit page.
Then select the list web part &...
0
Extending Choice column using lookup columns is not supported in SharePoint.
Supported Column Types:
Single line of text
Number
Date and Time
Unsupported Column Types:
Multiple lines of text
Currency
Person or Group
Calculated
Hyperlink or Picture
Custom Columns
Yes/No
Choice
Lookup
Microsoft official documentation: Create list relationships by using ...
0
In SharePoint REST API lists/GetByTitle() endpoint, you have to pass the Display name of list & not the name in list URL.
Example:
In below image, you can see the display name of list is "Logo Universe" while URL is like https://<tenant>.sharepoint.com/sites/SPConnect/Lists/ImageList/AllItems.aspx.
So, in REST endpoint you will use ...
0
This appears to be a know issue logged in GitHub. For me the problem seems to come and go and the errors appear to indicate attempts to re-establish the connection. There is a "disconnect" message when the errors start and a "connect" message when they stop. So I treat the "connect" message like a change notification and re-...
0
Export list item form footer, header and the body
$list = Get-PnPList SAMPLE_LIST-Includes ContentTypes
$contentType = $list.ContentTypes | Where-Object {$_.Name -eq "Item"}
$contentType.ClientFormCustomFormatter | Set-Content .\ClientFormCustomFormatter.json
Apply List Item formatting programmatically.
We need to to update the ...
0
If the selected column is a number column, you could use OOTB sum function.
As a workaround, you could open the list in the excel, then calculate in the excel.
Reference:
https://www.spguides.com/open-sharepoint-list-in-excel/
Update:
Display column sum in the other page by using scripts.
https://stackoverflow.com/questions/58890560/sum-of-sharepoint-list-...
1
You could use below JSON code.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"children": [
{
"elmType": "span",
"style": {
"padding": "12px"
},
"...
1
You can achieve this functionality by following 2 ways.
Create Flow which will trigger on click of button. Pass current item id to flow which will get all item properties. Button can be added to any list view column by JSON column formatting.
Refer below link to add Button on each row and trigger flow.
https://wonderlaura.com/2018/07/18/button-in-sharepoint-...
1
In SharePoint online modern experience, you can use column formatting to add mailto action in one of the column in your list view.
Try using below sample JSON:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "a",
"attributes": {
"href&...
0
I think you are looking for EnsureUser method.
Checks whether the specified login name belongs to a valid user in the site. If the user doesn't exist, adds the user to the site.
Request example:
$.ajax({
url: "http://<site url>/_api/web
/ensureuser",
type: "POST",
data: "{ 'logonName': 'i:0#.f|membership|user@domain....
0
SharePoint List is cutting off part of a column with text and an inserted image. How can I show all?
Per my test, I can reproduce your issue in my end and I have found a workaround, it worked for me, you can have a try:
Change column to single line of text, add formating:
{
"elmType": "div",
"txtContent": "@currentField",
"style": {
"padding": "4px"
}
}
and change back to multiple line ...
0
This is an expected behavior in SharePoint. If you are using the content type in a list, you cannot delete it directly from site.
First you have to remove the site content type from all lists & then you can delete it from site settings --> Site content types.
Alternatively, you can hide the content type from list instead of deleting it. Follow below ...
0
In SharePoint Online modern experience, you can connect two lists web parts based on common column & perform dynamic filtering.
For more information, check below documentation:
Connect web parts in SharePoint
Note:
This is a SharePoint out of the box (& easy) solution. So it will not give you a dropdown with list items.
You can edit the list web ...
1
Your formula seems fine to me.
=IF([Question 1] = "Italy", "1", "0")
Make sure you have below things correctly:
Set The data type returned from this formula is to Single line of text like:
Microsoft documentations:
Calculated Field Formulas
IF function
Note:
Sometimes comma(,) does not work in formula (It is based on ...
0
According to my research and testing, this is the correct search results
(*) as a wildcard, it means that as long as the file named with "btwaste" begins, it will be searched. Therefore, the BTWaste.RN_specsheet.pdf and BTWasteCI.RN_specsheet.pdf can be searched.
"BTWaste.RN_specsheet.pdf" is composed of "BTWaste", "...
0
You can sync two lists from different sites through Microsoft Flow.
Please following steps:
1.Create new list named "Sync1" in the SharePoint site
2.Create new list named "Sync2" in other SharePoint site and create same columns as the "Sync1" list
3.Create a Microsoft Flow
4.Save and Test this flow
======================== ...
0
For you requirements, you need to create a Calculate column in list.
Follow below articles for creating calculate column in SharePoint list:
Calculate data in lists or libraries
How to create a Calculated Column in a SharePoint list or library
Syntax for the formula in SharePoint is similar to what you are using in Excel currently.
Also, you are correct ...
0
Please try this which is based on your inputs.
=IF(OR(ISBLANK(B2), OR(ISBLANK(C2), OR(ISBLANK(D2), OR(ISBLANK(E2), OR(ISBLANK(F2), OR(ISBLANK(G2), OR(ISBLANK(H2), OR(ISBLANK(I2), ISBLANK(J2))))))))), "Incomplete", "Complete")
1
Currently the feature of pinning first column in list view is in development & it will be released to SharePoint with future updates.
Here are few details about the feature:
As you scroll left and right, the first column of your list remains in place; similar to the sticky header that is already a part of Lists.
Reference: Microsoft Lists: sticky first ...
1
You can filter SharePoint list views using URL parameters.
For your requirements, try this:
https://tenant.sharepoint.com/sites/siteName/Lists/YourListTitleHere/AllItems.aspx?FilterField1=ID&FilterValue1=1
0
Sorry all, I have no idea why this came up at the top of my list, just looked at the Date of the question, massive necro!
As others have mentioned if you go to List Settings > Validation Settings you can set a formula to validate the Item in the List which allows referencing multiple columns and in this case it works with a calculated column of Date3+...
0
You can show the column value conditionally based on another lookup column in list like:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"txtContent": "=if([$ParentLookup.lookupValue] == 'Parent 1', 'Child of Parent 1', '')"
}
...
3
As you are showing the image dynamically using JSON in column formatting, it is working fine in list view.
But, JSON formatting only displays the value/image in list view >> It does not store the actual value in list columns.
So, to show the image in Gallery view, you have to replicate the same logic (used in column formatting) in auto-generated JSON ...
1
For classic experience:
There is one option to set the permissions on view called "Target Audience".
Check my full answer given at: Limiting permission on all items and views
Microsoft documentation: Target navigation, news, and files to specific audiences
Form modern experience:
Currently there is no way to use target Audience in SharePoint ...
1
You can use the below JSON to update the Title field.
Updated the JSON to open Edit Form on Title column value click.
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "button",
"customRowAction": {
"action": "editProps"
...
1
You would need to store the file hash as a column for each document
Before you save the file you could check if the hash exists.
A hash is a unique identifier based on the contents of the file
Try PowerShell command Get-FileHash
1
Try settings UserDisplayOptions property to 'NamePhoto'
'UserDisplayOptions' = 'NamePhoto'
1
Follow below steps to set list view as the default view:
Go to SharePoint list & open "Rooster" view
Click on Switch view options dropdown at the top right corner.
Select Set current view as default.
Solution 2 - From classic view settings:
Click on Switch view options dropdown at the top right corner.
Select Edit current view.
Check Make ...
1
You can concatenate multiple responses (string) from Power automate flow itself using concat() function.
Syntax:
concat('<text1>', '<text2>', ...)
Example:
concat('Hello', ' ' , 'World')
Output:
"Hello World"
Documentation: concat function
Additional examples: These are just examples to demonstrate how to use concat function in ...
1
Use below PnP PowerShell command to check if E-Mail Notification is enabled on task list:
$list = Get-PnPList -Identity Tasks -Include EnableAssignToEmail
$list.EnableAssignToEmail
Where Tasks is name of list.
Output:
Documentation: Get-PnPList
Follow below article to export list items to CSV:
Export SharePoint Online List Items To CSV Using PnP ...
0
This is a default behavior in SharePoint online. You cannot wrap the column headers in two or three lines.
But you can manually increase the width of column header by dragging it to the right & save the list view.
For detailed steps, check: SharePoint Modern List - Increase column width with JSON Issue
Similar thread: SharePoint Modern Column Header ...
0
Service: SharePoint Online
You can add a hyperlink with description in grid view with copy/paste from Excel as follows:
In Excel you will need columns:
Desc = hyperlink text
URL = URL link
HTML = formula to create an HTML hyperlink anchor
A
B
C
1
Desc
URL
HTML
2
MyLink
https://link.to/blah
=concatenate("<a href=""",A2,""&...
0
Follow below steps:
Go to dispform.aspx page of list
Edit the page
Add content editor/script editor web part on page
Add below code in web part & Save/Stop editing the page.
<a id="redirectLink" href="">Click Here</a>
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/3.5....
1
The if expression requires 3 arguments:
Condition
TRUE result
FALSE result
When you are nesting if expressions you are providing the nested if expression as the FALSE result. Generally, the final FALSE result is the default result (when nothing else matches use this). So, with your nested conditions the last if is unnecessary and can just be replaced with ...
0
I made this PowerShell script for you
Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue
$listName = "CustomList1"
#Get the SPWeb object
$web = Get-SPWeb http://spwapp/
#Get the SPList
$list = $web.Lists[$listName]
#Get all items in this list
$items = $list.items
#Go through all items
foreach($item in $items)
{
$created = $...
1
Event web part is the OOB web part in SharePoint Online and we could not change it.
In short, we cannot automatically update the From and To dates in the date range, and must manually change it.
Or you’ll have to look into a custom event spfx webpart, specify this month date range and install it.
0
In SharePoint online list view, when you (single) click on SharePoint default Title column, it opens list form.
Possible Solutions:
Include/Show Title column in list view:
Maybe you (or someone else) removed/hide this column from list view. If you include/show this column in list view, it should work for you. If you can't find the column with name Title, it ...
Top 50 recent answers are included
