New answers tagged

0

You can do this by using a slightly different set of classes. Instead of the sp-css-backgroundColor-* classes you can use the ms-bgColor-* Fluent UI classes. The colors aren't exactly the same, but they do offer --hover equivalents. To "disable" the hover effect, you just need to apply both the ms-bgColor-* and ms-bgColor-*--hover classes using the ...


0

I don't think it is possible to remove SharePoint out of the box hover effect using SharePoint JSON formatting capabilities while using additionalRowClass row formatting. Unless you add any class (pre-loaded on page) in JSON which has CSS properties like: background-color: initial


1

There are syntax errors in your formula. Try using this instead: =IF(AND([Site_induction] = "UKI- Services- Chester TCC", OR([Site_induction] = "UKI- Services- Morden TCC", [Speed_limit] = "5mph")), "1", IF(AND([Site_induction] = "UKI- Services- Liverpool TCC", OR([Site_induction] = "UKI- Services- ...


1

Dialog box is showing old content/table again because you are "concatenating" the new content to previous content using: this.domElement.innerHTML += html; Instead of +=, use = like given in below code: this.domElement.innerHTML = html; This is an easier way than setting the innerHTML twice in render method.


0

To anyone facing similar issue- adding this.domElement.innerHTML = ""; in render() function fixed the issue.


1

The exact design (tabs & side panel) is not possible using SharePoint out of the box capabilites. You have to use the custom solution for this requirement. Possible solutions Form customization using Power Apps: You can customize SharePoint list forms using Power Apps & design tabs & fetch/filter child list items using Power Apps capabilities. ...


0

This is not possible using Power Apps capabilities. You cannot close the (newly opened) browser tab using Power Apps formulas as this is something specific to browser behavior/activity.


3

Well I have faced that situation months ago where I had to apply some branding things for SharePoint Online modern pages. So here is my results from my investigations (which I already applied and it's working fine) First of all, You need to know that Microsoft doesn't support injecting or adding alternate CSS or JS or any other OOTB way to apply some custom ...


0

You can achieve this in SharePoint online using below two ways: SharePoint site theming - recommended: You can create a custom theme for your SharePoint site & apply custom styles and colors to sites. Not sure if you will be able to achieve all your requirements (like specific font-size) using custom themes but this is the recommended solution by ...


1

HTML markup is not supported in SharePoint online. So, you cannot use HTML formatted calculated columns in modern experience. Source: Handling HTML markup in SharePoint calculated fields Few options to check: SPFx Field Customizer: Provides modified views to data for fields within a list. Sample solutions: Check these samples to get the idea of how to ...


0

I just checked all SPFx web part samples shared by community members on GitHub repository. But, there is no sample which exactly matches your requirements. You can also check all the samples at: SPFx web part samples But, I am sure that this can easily be achieved using SPFx capabilities. Check below samples to see how much configurable web parts you can ...


1

There is no SharePoint out the box web part which provides the exact same design as your requirements. But, this is what I have implemented using SharePoint out of the box sections & web parts: This is how I achieved above: Added a section with three columns layout on modern page Added a Call to action web part in first column Added call to action text ...


1

Quick chart web part in SharePoint can only show the simple data without allowing any grouping/calculation (for data as well as labels). So, you cannot achieve your above requirements using Quick chart web part. Possible solutions: Power BI: Using Power BI, you can quickly create reports using simple as well as complex calculations You can embed Power BI ...


1

When you select Get data from a SharePoint list on this site option in quick charts web part, SharePoint retrieves lists from current site using below endpoint: https://tenant.sharepoint.com/sites/SPConnect/_api/web/lists?$filter=(BaseTemplate ne 101) and (BaseTemplate ne 119) and (Hidden eq false)&$select=Id,Title,DefaultViewUrl That means all the list ...


0

Try below if it works: Rename Name column from modern experience document library view as:


0

Site Collection Admin is like a super admin having access to everything under the site.


0

According to Microsoft documentation, you would want to get the Role Definition ID by doing this for your URL: url = _spPageContextInfo.webAbsoluteUrl + "/_api/SP.AppContextSite(@target)/web/roledefinitions /getbyname('contribute')?@target='<host web url>'"; Where you would replace <host web url> with your site collection that is ...


1

Looks like there is syntax error in your conditions against background-color. Try using below JSON code, it should work for you: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "...


0

This is not possible in SharePoint. The SharePoint Site Collection Administrator cannot be locked out of any subsite, list, library, item, or page on the site. The permissions inheritance for any of these elements can be broken at any time, and permissions changed so that even users with Full Control rights have lesser permissions or even no permissions at ...


1

There is no direct SharePoint out of the box way like list's "Item-level Permissions" to achieve this. So, you have to achieve this by breaking permissions inheritance on individual site pages & then only grant necessary permissions. Now, there are two ways to achieve this: Manual: Any user who creates a new article/news has to manually break ...


2

You cannot get the type of list while using lists.getByTitle("<name>").items endpoint. You can identify the type of list based on it's BaseTemplate like below: let colsToSelect: string[] = []; const r = await sp.web.lists .getByTitle(listName).select("BaseTemplate")(); if (r.BaseTemplate === 101) { console.log("It's a ...


0

You can use column formatting to meet your needs in SharePoint Online. Please following steps: 1.Go to the list as a site admin 2.Select the "Date and time" column >> Column settings >> Format this column 3.On the Format Column windows, click on "Advanced mode" link 4.Please use the below JSON code { "$schema": &...


0

There are some notes when you temporarily disable the SharePoint app bar: It can take up to an hour for the app bar to be removed on a tenant where the app bar is already showing up. Running the command without the $false or $true value will cause it to fail. You must be using the latest version of PowerShell. If you are using previous versions, uninstall ...


1

For your requirements, you have to use the Column formatting in SharePoint. Follow steps given here in official documentation to open column formatting settings & add below JSON code. You can use simple JSON like below to format your date columns: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema....


0

This left tool bar in SharePoint is called as SharePoint app bar. There is no option under 'Site settings' to remove the SharePoint app bar as this is tenant level setting. How to disable the SharePoint app bar?: You cannot disable the SharePoint app bar permanently. However, you can temporarily disable the SharePoint app bar in your tenant using PowerShell ...


0

Try configuring column settings as below: Return data type as Number. Formula used: =IF(LEN([AZDP]) = 176, 1, 0) Output: Notes: Multiple lines of text column are not supported in calculated column formula Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case ...


1

Try as following: IF(LEN([AZDP])=176, "1", "0") More inforamtion: https://support.microsoft.com/en-us/office/if-function-7025be14-5665-43d0-af20-8293d1fe9d3a


0

According to my test, there is nothing wrong with the formula you provided. You can use the following formula instead: =IF([Completed Date]="","TBC",DATEDIF([Created Date],[Completed Date],"d")) ------------------------------------- OR ---------------------------------------- =IF([Completed Date]="","TBC",...


0

Syntax in your formula seems correct & it also works at my end. Example: Try below combinations & see which one works for you: =IF([Completed Date] = "", "TBC", [Completed Date]-[Created Date]) OR =IF(LEN([Completed Date])=0, "TBC", [Completed Date]-[Created Date]) Above two formula returns same results as shown in ...


0

The image field object has the following properties (with example values): { "fileName": "image.png", "id": "6bb1d843-0633-4c9a-9a16-90bc5abd1d8e", "serverRelativeUrl": "/teams/Discovery/SiteAssets/Lists/ad6ed939-0db2-4d85-8a39-8f3497f41eee/image.png", "serverUrl": "https://...


0

This is the code I used to make the card shown below. My example uses a people column to extract the user's name and image and their start date to display in the card, plus a little CSS magix mixed in (border-radius) for rounded corners and the class (ms-bgColor-neutralQuaternaryAlt) for matching the site’s theme. All in all, this answer has everything you ...


1

Try using below JSON code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "groupProps": { "hideFooter": true, "headerFormatter": { "elmType": "div", "style": { "...


1

SharePoint Server 2019 supports SharePoint Framework client-side web parts hosted on classic or modern SharePoint pages built by using the SharePoint Framework v1.4.1. SharePoint Server 2019 also supports SharePoint Framework extensions hosted on modern SharePoint pages built using SharePoint Framework v1.4.1. This means that when you're targeting the ...


1

Try using below formula: IF(AND([Site_induction] = "Chester TCC", [Speed_limit] = "5mph"), "1", IF(AND([Site_induction] = "Manchester TCC", [Speed_limit]= "10mph"), "1", IF(AND([Site_induction] = "Liverppol TCC", [Speed_limit] = "10mph"), "1", "0"))) Note: ...


0

If you go to Sharepoint admin area (not the sharepoint settings this is the administration centre for sharepoint) select settings and add your sharepoint URL in the Home Site area - poss few hours to update


0

Try using list validation formula like below: If([Activity] = "Walking", If([Category] = "Exercise", true, false), true) You have to add this formula under List Validation settings. Follow below steps: Go to SharePoint list Click on Settings icon and select List settings Select Validation settings Add formula & user message and ...


1

OOTB capabilities: You can setup header/footer navigation using OOTB settings. You can use different types of header layouts like minimal/compact/standard/extended, menu styles like Mega menu or Cascading menu. You can add links as well as labels in navigation References: New Site Header Options in SharePoint Online Customize the navigation on your ...


0

I found that links like this will open a document in its full client application. https://yoururl.sharepoint.com/sites/YourSite/Shared%20Documents/YourExcelDocument.xlsm?web=0 Unfortunately, if used in a QuickLinks link, SharePoint appears to override your web=0 value like this: https://yoururl.sharepoint.com/:p:/r/sites/YourSite/Shared%20Documents/...


2

I just tried reproducing this simple SVG example in JSON formatting & it is working perfectly: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "children": [ { "elmType": "svg", "style": { ...


2

Follow below steps to add picture library in SharePoint online modern experience (new add an app experience): Go to Site contents --> Select New --> Select App OR select Add an app from settings (gear) icon On "My Apps" page, select From my organization Select classic experience link It will open classic experience "Your Apps" ...


3

You have to use the internal name of SharePoint columns. Internal name of created by field is Author. So try using [$Author] instead. Check below URL to find out the internal name of SharePoint column: Find the internal name of SharePoint column


1

You can use SP PnP JS library to like/unlike list items/site pages. Example: import { sp, IItem } from "@pnp/sp/presets/all"; import "@pnp/sp/comments/item"; import { ILikeData, ILikedByInformation } from "@pnp/sp/comments"; // get a specific item by id. let item: IItem = await sp.web.lists.getByTitle("My List").items....


1

Microsoft is adding the ability to paste inline images into the Text web part so that images can be closer to text and so that text can wrap around images. Microsoft 365 Roadmap ID 85584 This feature is currently rolling out to Targeted release tenants & soon will be available for all tenants (standard release/GA) So, Either you have to set up targeted ...


0

You can center the icon by making it a child of a div using flexbox: { "elmType": "div", "style": { "display": "flex", "justify-content": "space-evenly", "align-items": "center" }, "children": [ { &...


0

You could go to SharePoint admin center -> Policies -> Sharing -> More external sharing settings -> Set "Guest access to a site or OneDrive will expire automatically after this many days". If your have set an expiration time for guest access, each guest that you invite to the site or with whom you share individual files and folders will ...


0

Yes, it is possible to set the automatic expiration after specific days. For more information, follow below documentations: Manage sharing settings Change the sharing settings for a site


0

There is no direct tenant settings to remove Sync icon from all sites or newly created site. PowerShell to Remove Sync Button in all sites of one Site Collection(you need to look through all site collections to meet your requirement): #Load SharePoint CSOM Assemblies Add-Type -Path "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\16\...


0

Hyperlink columns have data object/value in below format: { "Description": "Google Home", "Url": "www.google.com" } So, considering name of your column is HyperlinkCol, you can get description using: item.HyperlinkCol.Description; & URL using: item.HyperlinkCol.Url;


1

It is not possible to show the dialog/pop up on button click using out of the box functionality. If you are using text web part then you can create a hyperlink which will open a video/link in new browser tab Or you can use button web part to show button & open link in new tab (This is what you can achieve using out of the box web parts & not dialog/...


1

I think you can only use the classes from fluent UI which are loaded by default on SharePoint list view pages (unless you somehow injected the fluent UI CSS on modern pages, maybe using application customizer). I just inspected list view page in one of my tenants & observed that classes like ms-motion-slideUpIn & ms-motion-fadeIn are loaded by ...


Top 50 recent answers are included