Thursday, May 09, 2019

How to clear SharePoint People Picker suggestion cache

How to clear SharePoint People Picker suggestion cache

If you have been SharePoint Site owner long enough, you would have definitely bumped into task like assigning document permission using SharePoint People Picker.
One of the out of the box SharePoint People Picker features is that it auto caches all previous user entry entered/selected by you.

This cached people picker entity is meant to help you to quickly find the user and assign the permission.
It would introduce invalid entry if there is cease of identity provider (for whatsoever reason that the decision made from the IT management needs us to swing the SharePoint identity provider to other platform).
Things could get messier for those who frequently accessing people picker, to be seeing the old cached user.
Another situation that introduce inconsistency is when there is change of user name/job title etc for which is cached and not reflecting the correct info to the end user.

SharePoint People Picker uses LocalStorage to cache the people picker entity. In order to flush the cache, you would need to run a JavaScript to clear the cache. What’s worst is that there is no expiration set.
If you fire up your browser development tool and type in “localStorage” (case sensitive) in the console. You would see the cache key/value for ClientPeoplePickerMRU.
hit F12: For Chrome, IE and Firefox (Note:You must be firing up the developer tool at the SharePoint Page)

Chrome – Resource tab

So what can we do?
If you are developer and techie, you can easily fire up the developer console of your browser and run the below JavaScript
If you are helping your end user to flush the cache, one possible way is to provide them a quick custom web part using javascript above to flush their cache. Alternatively, creating a custom JS with leveraging Cookie as expiration check, put it into your home page. Whenever user accessing to your home page, this JS will check from Cookies to see if it is time to Refresh (or clear) the local storage.
The other possible way is to get them clear the Local Storage from their Browser. I couldn’t find where the IE local storage is. If you know, I will be more than happy if you can tell me.
For IE Users who wish to clear the people picker. Here are the steps you may follow
1. Go to page with people picker
2. F12 Developer Tools
a. Console
b. localStorage.clear();
3. Close F12
4. Then refresh the web page to test it.
[Credit goes to Chris for the steps above]

Wednesday, May 01, 2019

GitHub --set-upstream

git push --set-upstream master

git pull

git commit -m 'Another commit'

git push

Wednesday, March 20, 2019

Nice AdSearch by LanID to populate a form

$('#Domain_ID').focusout(function () {
        type: 'GET',
        url: 'https://localhost:44364/api/v1/AdSearch?userId=rdanne1',
        dataType: 'json',
        error: function (xhr) {
            alert("An error occured: " + xhr.status + " " + xhr.statusCode);
        success: function (data) {
            if (data) {

Wednesday, February 27, 2019

SQL RAISEERROR and Log the error

Put all SQL Stored Procedures in BEGIN TRY > BEGIN TRANSACTION > IF  ELSE blocks and use the following as a TEMPLATE

Create an output parameter so the source code can log the error and you can check the DB table for the error.

@ELog_ID int = 0 OUTPUT 



            IF EXISTS (SELECT 'x' FROM People_tbl WHERE Email_Address = @Email_Address)
RAISERROR (N'Person is already in the database.',11,11, 'usr_Person_Add')
--PRINT 'Person is already in the database!'


-- CRUD work



--PRINT 'In the Catch Statement'
PRINT 'Process has reached the CATCH'

EXECUTE dbo.[usr_InsertErrorInfo];

SELECT @ELog_ID = max(ELog_ID)
FROM ErrorLog_tbl;


Monday, January 07, 2019

Azure Cost Learning from Experience after Free Trial Expires

Well, today I logged into my Bank account and I have I nice debit of "MSFT AZURE", although I thought I was very careful to turn off all the Apps/Slots I would not be charged.

Another lesson by experience, I was wrong if you have a Plan aka S1 you will be charged even if you do not have one service running.

Set-AzureRmAppServicePlan -ResourceGroupName $rg -Name $AppServicePlan -Tier Free


Robocopy command can be used to move data from one folder to another.
Go to cmd
Robocopy "C:\SourceDir" "C:\DestDir" /E

above command copies all folders, subfolders and files from source to destination folder.
Happy Learning!

Read more about this here:

/MIR option. It can intelligently mirror source and destination, copying ONLY changed files and deleting files on the destination that are no longer on the source. Very useful when you need to maintain a backup/standby system. rsync is the unix equivalent to this command. I used rsync at home just yesterday. Great stuff!

Wednesday, December 19, 2018

Microsoft Word Navigation Pane (Keep It Open - TOC)

To get to the Microsoft Word Navigation click ctrl+f then select navigation pane and leave it open while working on a very long document.   It will help you from pulling out your hair.