Year: 2018

Office365 Trusted sites for Single Sign On(SSO)

For Single Sign On(SSO) to work on all Office365 services, we need to setup a bunch of URL’s as Trusted Sites in Browser. These URL’s are all over the place and list keeps on growing. I am trying to document all of them in one place for future reference. I will try to keep this […]

Read More

Create a custom connector for PowerApps/Flow

If you have a need to connect with data from another line of business systems using PowerApps, you can create a custom connector. If you are trying to connect to any on premises systems, you need to setup an on premises data gateway to start with. I will leave on setting up and configuration of […]

Read More

SharePoint Designer cannot display the item

You run into ‘SharePoint Designer cannot display the item’ error when you are trying to edit an existing workflow setup in Designer quite often when there is a windows update or update to .NET framework installed in your computer. In some cases it may also not allow you to create new workflows. Resolution: Clearing Designer […]

Read More

Access denied while processing pending access requests in SharePoint online for users with full control

Site owner or a user with full control gets access denied while processing pending access requests in SharePoint online. Even if the user is part of Owners group for the site and Owners group is set to receive & process access requests. Issue : This issue arises if we do not properly assign default access […]

Read More

The underlying connection was closed: An unexpected error occurred on a send

PowerShell error - The underlying connection was closed: An unexpected error occurred on a send, while trying to run CSOM PowerShell code on SharePoint online sites. Same error while trying to use PnP cmdltes From network trace we are able to figure out that server is closing the TCP connection forcefully. Reason being a mismatch […]

Read More

Windows security prompt. Connecting to SharePoint….

Users often run into this issue. Windows security prompt pops up every 15 minutes or so repeatedly trying to connect to SharePoint. No matter you enter credentials or cancel, user will be prompted for credentials again and again. SharePoint may not be the culprit all the time. List of things I check whenever I run […]

Read More

View cannot be displayed because the number of lookup columns exceeds the threshold

If you work with large lists there is a good chance you might have run into this threshold error message in Office 365. A Lookup column in a list view will cause a join with another table in the back-end. More lookup columns implies more joins in the back-end resulting in performance hit. That is […]

Read More