Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Blog

SharePoint Calendar Color Overlay (HEX DISPLAY)

Quick reference below for the 7 Microsoft calendar overlay colors available in SharePoint Online as of 1/19/2020.   User Voice community has requested ability to add custom colors, but not yet implemented.  Upvote if you like at https://sharepoint.uservoice.com/forums/601165-suggestion-archive/suggestions/11317953-select-own-hex-colors-for-calendar-overlay.   Notes on how to create Calendar overlay at https://blog.virtosoftware.com/how-to-color-code-sharepoint-calendars/.

Microsoft Color
Dark Teal, #00485b
Blue, #0078d4
Dark Green, #288054
Olive Green, #767956
Red, #ed0033
Dark Purple, #682a7a
Dark Teal, #006984
Dark Green, #134029
Brown, #3b3c2a

Cheers

shades_smile

What’s in that patch? January 2020

NOTE – PDF format updated to include both SharePoint 2013, 2016, and 2019 notes.

Ever wondered what fixes are inside of a given CU?   Please see attached PDF with full detail. I wanted a new format for easy reading.   Show management and make the business case for why downtime should be taken to apply CUs.  Also posted at https://sharepointupdates.com/

If you found this helpful, please leave a comment.   

shades_smile_thumb_thumb_thumb_thumb[2]

Download

What’s in that patch – Jan 2020.PDF

FIXED – MS Flow HTTP 400 – Managed Metadata

Wanted to share resolution for tagging Managed Metadata term in MS Flow and seeing error HTTP 400.  Managed Metadata terms are stored in SharePoint with GUID identifiers.   That enables us to rename terms while preserving all current tag usage.  However, it means that we must use GUID when adding and updating tag values to ensure lookup saves successful.  Cheers

shades_smile

Error

HTTP 400.  The data returned from the tagging UI was not formatted correctly.

Resolution

Format text for Managed Metadata tag as “VALUE | GUID”.  For example, here we have “JavaScript|6f634666-d2a6-4367-9b65-4bb4ab33afc6” in the MS Flow Set Variable set.  Publish, run flow, and confirm SPListItem successfully added to demo list.

Video

Screenshots

image
image
image
image
image
image

VIDEO – Azure Function running F5 on localhost

Wanted to share brief for creating a new Azure Function 2.0 on localhost.  Followed quick start wizard within Azure for steps.  Initially received error message pressing F5 but able to resolve by navigate down three folders and run command manually.  Root cause was local PowerShell configuration.   Updating “$profile” to remove Change Directory commands (“CD C:\CODE”) resolved the F5 error with Azure function not starting.

Thank you to @nthonyChu and @fiveisprime for help troubleshooting.   Cheers. 

shades_smile

Error

Unable to find project root. Expecting to find one of host.json, local.settings.json in project root.

Resolution

  1. Launch PowerShell
  2. Run “notepad $profile”
  3. Remove any “CD” commands with modify working directory
  4. Save and restart

Workaround (Temporary)

  1. Navigate down 3 folders with cd “bin\debug\netcoreapp2.1\”
  2. Run “func start host”

Video

Screenshots

image
image
image
image
image

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲