Power Automate: Send emails using your corporate branded email templates

In Microsoft 365, Power Automate is the go to solution for all kind of workflow based notification emails. In this blog, I will explain technique to send emails using your corporate branded email templates. If you do not have a corporate branding for your internal emails, maybe it is the right moment to plan for … Continue reading Power Automate: Send emails using your corporate branded email templates

Power Apps : Clear Date, Person, Choice, Managed Metadata field values in edit form of SharePoint List/Library

SharePoint sometimes surprisingly lacks very basic operations like clearing up a choice, date and other lookup fields in the edit form. By default, when you edit an item using a power apps customised form, the values of the special fields like date, choice , managed metadata, person or group field etc cannot be cleared. If you remove the value from the input control and save the item, the old value will still persist. This post is about a simple technique using powerapps to clear the values of any special field in SharePoint.

Azure AD: Migrate from Federated Authentication to Cloud Authentication

In this blog, I want to share my recent experience of migration of Azure AD Authentication from Federated authentication using Okta as the Identity Provider to Cloud Authentication (Pass through in my case, but similar process & principles to be followed for Password Hash Authentication). Scenario This post is helpful if you have below current … Continue reading Azure AD: Migrate from Federated Authentication to Cloud Authentication

SharePoint 2013/2016/2019: Use CSOM in SharePoint Site with multiple authentication schemes

Scenario I have a SharePoint site collection which has multiple authentication schemes (say Windows NTLM, Azure AD, Okta, ADFS or any other 3rd party Identity provider) on same URL. Now when I try to connect to that site using CSOM, I will get below 403 forbidden error from SharePoint: The remote server returned an error: … Continue reading SharePoint 2013/2016/2019: Use CSOM in SharePoint Site with multiple authentication schemes

Connecting to Azure Analysis Services using ADOMD

Skip the blog and check the Github repo for full sample code Azure Analysis Services is a new service (Paas) in Azure where you can create semantic data models. It provides easier and faster way to query against massive amount of data using clients like Power BI, Excel and other reporting clients (Tableu etc). For … Continue reading Connecting to Azure Analysis Services using ADOMD

Single Sign On in Office 365-SharePoint Online by bypassing Home Realm Discovery page

This blog explains techniques to acheive single sign on in your office 365 tenant by bypassing Office 365 Home realm discovery(a.k.a HRD--> https://login.microsoftonline.com ) page.If your Office 365 setup does not have the following setup then this blog does not apply to you: AAD with Federated identity with third party Identity provider such as ADFS/CA … Continue reading Single Sign On in Office 365-SharePoint Online by bypassing Home Realm Discovery page