Hot answers tagged

3

Simple: You want to filter the Created column using the following function [Today]-1 Step 1: Go to Library tab -> Modify View for your list Step 2: Go to the Filter section -> Select the Created column Select is greater than or equal to Enter [Today]-1 in the textbox Step 3: Click Ok Another Example: View filter settings: how to implement [TODAY] - 6 ...


2

ed, For SharePoint Online, a new view is not the best tool to do this. The workaround I think will work better in modern experience is the Highlighted content web part which dynamically display content from a document library, a site, a site collection, or all sites. By default, this web part shows your most recent documents. And you can change it to be ...


2

To add multiple items in the same invoice, create a column named "Invoice ID" , don't choose "Enforce unique values". To calculate the Items cost added to this invoice automatically, modify view, group by "Invoice ID", sum "Item Cost": It will calculate the Items cost added to this invoice automatically:


2

For that you have to create 3 Views. In first view filter Appliance by "Washing Machine" value. In the second view uncheck appliance column. For the third option you have to set Appliance column default value to 'Washing Machine', you can do this from Appliance column setting. now create the view and uncheck the Appliance column from view settings. select ...


2

When you create the view, in the view settings page, scroll down and expand the "folders" category, and select the "show all items without folders" option. Optionally, scroll back up and set the filter as desired to set the region.


2

Solution: Create SPFx Field Customizer so you could get the view id by this.context.pageContext.legacyPageContext


1

Modify your PnP PowerShell as below. $URL='https://tenant.sharepoint.com/sites/test' Connect-PnPOnline –Url $URL –Credentials (Get-Credential) $listTitle = "Test" $listUrl = "Test" Remove-PnPList -Identity $listTitle Write-Host -ForegroundColor Magenta "Creating list: " $listURL New-PnPList -Title $listTitle -Url $listUrl -Template GenericList $FieldXML= "&...


1

Solution 1: Try adding Viewable = "TRUE" in Field XML. Example: $xml = '<Field Type="Text" Name="PSCmdletTest" DisplayName="PSCmdletTest" ID="{27d81055-f208-41c9-a976-61c5473eed4a}" Group="Test" Required="FALSE" StaticName="PSCmdletTest" Viewable="TRUE" />' Add-...


1

We need to understand why users get three dots option - this is because of item level edit permission is enabled. We can achieve this in two ways: Approach 1: Create Two Views: One for normal user Another for admin user For normal user view: Select and display the "Title" column instead of Title (linked to item with edit menu) - and use Name (linked ...


1

You don't specify in you question what mechanism you are using to associate project document dependencies, but assuming you are using metadata of some sort on your document libraries to indicate which project(s) they are associated with, I think your best bet is to use the Highlighted Content WebPart: In the settings of your WebPart instance, under the "...


1

Short Answer to your question is No. Currently there is no variable/function available to get the current View ID/Name while using JSON formatting on column. For more information on column formatting, check below documentation: Use column formatting to customize SharePoint.


1

You need to create a calculated column which with formula as "MONTH([Due Date])". And data type select "Number". Then filter the list view as calculated column equal to 3(for march) or 4(for April). And in the Totals section, select Count for Due Date column (Mine is Modified column): The count will return under the header:


1

Yes. It is possible to create a list and add multiple filtered view of it on different SharePoint pages. The last point you mentioned is bit tricky which will not be possible using out of the box capabilities of SharePoint. You might need to write some client side code for that. Also note that the list forms will be same on all the list web parts added in ...


1

I am basically getting the content from another question here in this site - link here. Thanks Shashank Reddy K Below is the javascript for JSLink(display template) file which does the custom sorting. You just need to change the order in the viewNames array with the order you want to display in your list. (function () { SPClientTemplates....


1

Below how you can achieve in REST API. First you need to make call to your targeted view, /sites/mysc/_api/Web/Lists(@v0)/Views(@v1)?&@v0=guid'4fc236a-4364-4523e-a523a-abd90e0e0583'&@v1=guid'f0e92334-6c47-4223-9d1a-6b7ea5d239ada' Here above v0 should your list GUID and v1 should be your view guid. Once you make call to above service, you will get ...


1

Follow below steps: Go to List Settings. Click on the View you want to modify from Views section at the bottom. To Remove ellipses(three dots) --> Un-select checkbox before "Naam (linked to item with edit menu)" and select checkbox for Naam(linked to item). To Remove checkbox --> Scroll down on the same view settings page up to Tabular View Section and ...


1

Showing Total feature on Modern UI is still not available. Though it is under development as per this link. They started rolling out for some tenants and seems rolled back again due to some issue. Reference links having same issues https://techcommunity.microsoft.com/t5/SharePoint/2019-Modern-Sharepoint-List-Totals/td-p/357876 You would have to wait till ...


1

Add leading zeros: X01-05, X01-12, X02-01, X17-01 If you don't want to change the data, add a calculated column that inserts the leading zeros and sort on it, but don't display it.


1

I found what was happening here. This being an initial filling of this Sharepoint instance, I had not yet planned everything I wanted from the beginning. So, at first I created some folders, afterwards I noticed that I want a pinning funciton and added the IsPinned field, and afterwards made some new folders. I set the default for IsPinned to be FALSE, ...


1

No. This is not possible using SharePoint OOTB functionalities for Datasheet view. However you can add description to your fields from field/column settings. These descriptions will be shown on SharePoint list forms.


1

This might seem like overkill (for me it was not), but there is a chrome extension "CHECK ALL CHECKBOXES", you literally click the button and it unchecks all checked boxes and checks all unchecked boxes. So instead of unchecking hundreds of checkboxes, I was left with about 10. There are similar extensions, but this one worked for me. Then you can create ...


1

Thanks to Hugh Wood answerm, I could made this quick and dirty solution. You can copy and past you wanted order in $order (even from excel sheet) and so get simply the requested order. Please be aware there is no logical check: Add-PsSnapin Microsoft.SharePoint.PowerShell $web = get-spweb https://sharepoint/sites/site $list = $web.lists["yourListName"] $...


Only top voted, non community-wiki answers of a minimum length are eligible