SharePoint List Column Styling 102

Column Styling 101 only shows you a single option for colour formatting.

For this example, I want it to only be red if the date is past AND the item is not competed.

So like before you need to open the column formatting properties.

• Click the drop-down arrow next to the column you want to see.
• Select “Column settings”
• Click “Format this column”

• This opens the column formatting properties
• Untick “Format dates” and Select “Conditional formatting”

• Then click “Manage rules”

• Now we add our new Rules:
• Click “Show all values as”

• Then add the new rules:

• Click “Save”, and back
• Add all 3 conditional rules

• The view will now not show the colour if the task is completed

SharePoint List Column Styling 101

 If you want to see the format:

1. Click the drop-down arrow next to the column you want to see.
2. Select “Column settings”
3. Click “Format this column”

4. This opens the column formatting properties
5. The “Edit styles”

6. This shows you the format

 

 

SharePoint Classic Video Player

SharePoint Classic Video Player taken directly off backend SharePoint Classic, so it just works.

Add this to a script editor web part

Here is the code:

The yellow is the link location to the video

The pink in the link location to the preview image of the video

<div class="mediaPlayerContainer"><video class="mediaPlayerVideoObject" id="FilePreviewID-1-MediaPlayer" onloadstart="" poster="/_layouts/15/images/videopreview.png" width="350px" height="197px" data-init="1" controls=""><source src=https://mysite.sharepoint.com/SiteAssets/video.mp4 data-label="undefined" type="video/mp4"><a href="javascript:Silverlight.getSilverlight(&quot;2.0&quot;);" style="text-decoration: none;"><img src=http://go2.microsoft.com/fwlink/?LinkID=108181 alt="Get Microsoft Silverlight" style="border-style: none" data-themekey="#"></a></video><div class="mediaPlayerFullScreenEsc"><span></span></div><div class="mediaPlayerInitialPlayButton" style="display: none;"><a href="javascript:;" title="Play"><span></span></a></div><img src="/_layouts/15/images/hig_progcircle_loading24.gif" class="mediaPlayerLoadingIndicator" title="Buffering... Please wait" alt="Buffering... Please wait" data-themekey="#" style="display: none;"></div>

2019 Modern SharePoint sites

I finally found the link (and the time) to create the new Modern SharePoint site templates. Woohoo! I just wanted to share with you the options and how they look.

There are 2 options:

• Communication Site
• Team Site

1.       The Communication Site has 3 options:

1.       Topic

2.       Showcase

3.       Blank

Looks funky and the first two option look quick different from each other. You can't create Communication subsite, so if you do create some kind of team site, the look and feel (and especially the navigation) doesn't match. 

2.       The Teams Site has only 1 options

This Team site is not to be confuse the Team site (OG), this is the Modern Team site. “Modern” being the new styling word to describe this new look and feel.

I personally don’t like this one so much, the global navigation menu isn’t there, and if you force it on, it looks bad. Have a look, and you decide. You are welcome to make changes, these are just for use to play with.

Screenshots

Communication Topic Site

Communication Showcase Site

Communication Blank Site

Team Site

Enjoy J

Mapped crawled properties for "URL"

Getting the right URL information from the "URL" column within your SharePoint Content Search Web Part (CSWP). This would be the OOTB (Out of the Box) SharePoint "URL" column.

Mapped crawled properties for "URL"

ows_URL

results = {URL}
example = http://www.google.com

ows_q_URLH_URL

results = {URL}, {Description}
example = http://www.google.com, Google

RefinableString for Title

Just had some fun and games with the SharePoint Content Search Web Part (CSWP). I create some content, list and pages, all with there own content type. I was able to view the column "Title" content in the CSWP display, but not able to Sort by "Title" or have it as a Refiner.

So...
I used one of the RefinableString Managed Property. It was tricky to figured out which Mapped crawled property was the correct "Title". These are the ones that worked for me, for my current project.

Mapped crawled property for:
List - Basic:displaytitle
Page - ows_Title

Happy Halloween nerd style: https://auz.github.io/Bug