Posts

Using OAuth Support for HTTP Request Triggers in Power Automate

Image
Using OAuth Support for HTTP Request Triggers in Power Automate Introduction In this blog post, we will explore how to use OAuth support for HTTP request triggers in Power Automate. This feature allows you to securely connect to APIs that require OAuth authentication, expanding the possibilities for automation and integration with various services. What is OAuth? OAuth (Open Authorization) is an open standard for token-based authentication and authorization. It allows an individual's account information to be used by third-party services, such as Facebook, without exposing the user's password. Why Use OAuth Support for HTTP Request Triggers? Before the introduction of OAuth support for HTTP request triggers, connecting to APIs that required OAuth was a complex process. Now, Power Automate simplifies this process, making it easier to connect and automate tasks with services that use OAuth for authentication. How to Use OAuth Support for HTTP Request Triggers Here are the steps t

Transitioning from Nintex to Power Apps and Power Automate: Embracing the Future of Workflows

Image
Introduction: Recently, Nintex announced the deprecation of their Nintex Workflow for Office 365 product due to Microsoft's decision to retire SharePoint 2013 workflows by April 2026. This announcement has left organizations relying on Nintex for their workflow automation needs in search of alternative solutions. Fortunately, Microsoft offers powerful alternatives in the form of Power Apps and Power Automate. In this article, we will explore the benefits of transitioning from Nintex to Power Apps and Power Automate, and provide guidance on making a smooth and successful transition. Understanding Power Apps and Power Automate In today's rapidly evolving digital landscape, organizations are increasingly seeking low-code or no-code solutions to streamline their business processes. Power Apps and Power Automate are two key offerings from Microsoft that enable organizations to create custom applications and automated workflows without extensive coding knowledge. Let's delve deep

Disable list view selection for users on SharePoint Online using SPFx Application Extension

Image
 Recently we ran into an issue on SharePoint Online that user should be able to see only their records in a list and not otehrs. So we had updated the default list view filter with Employee equal to [Me].  We have also created a view "Admin" with no filter so admins can see all records. However, the view selection is still enabled as they have View permission and hence the users can switch to Admin views and see all records, see below screenshot: So to solve this issue, we created a very simple SPFx Application customizer extension such that it hides the entire list comand bar for normal users, and shows it for only site admins. See the end result for Site admins and Normal users: Open the node.js command prompt and start eith the yeoman scaffolding: Select the type of client-side component as Exension Select the type of extension to be Application Customizer Open the solution in VS Code Create a new CSS file in this path: src > extensions > appExtensionDemo > mysty

SharePoint Custom Access Denied Page

Creating a custom Access Denied page to match the site branding and client requirement is one of the requirement in most of the projects. In Microsoft SharePoint, it has a default Acess denied page. To customize and build our own Acess Denied page, follow the below steps. On the SharePoint server, navigate to : C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\TEMPLATE\LAYOUTS Create new folder: UserCustomPages From the /Layouts folder, copy AccessSenied.aspx file paste into the new folder(UserCustomPages). Rename the file to customAccessDenied.aspx and modify it as per the requirement, save it. Open SharePoint management shell Execute below scripts: get-spcustomlayoutspage -webapplication "http://your-site-url" This will show the default Access denied page used. set-spcustomlayoutspage -Identity "AccessDenied" -RelativePath "/_layouts/15/UserCustomPages/customAccessDenied.aspx" -webapplication "http://your-site-url" Thi

Create SharePoint Site Collection in a specific Content DB In SharePoint using PowerShell

As the SharePoint Central Administration doesn’t provide any interface to create a site collection with a nominated content database, we need to use PowerShell commands to create a site collection in a new content database for SharePoint on-premise. #Create a SharePoint New Content Database New-SPContentDatabase -name <<WSS_Content_DB_Name>> -webapplication <<http://Web_App_URL>> Create Site Collection in the previously created Content DB #Create a Site collection in the specific content database New-SPSite -Name "<<Site_Collection_name>>" -ContentDatabase <<WSS_Content_DB_Name>> -url <<Site_Collection_URL>> -OwnerAlias "domain\primary_Admin" -SecondaryOwnerAlias "domain\Secondary_admin" -Template "BLANKINTERNET#0" Here the template is the required site collection template. Some of the common template codes are below: Team Site: STS#0 Blank Site: STS#1 Wiki Site: WIKI#0 Blog: BLOG#0 App

SharePoint Get list items from List view- REST API

In the below code snippet, call the  getListViewItems method by passing the weburl, list title and the viewname. function   executeJson ( url ,  method ,  headers ,  payload ) {      method  =  method  ||  'GET' ;      headers  =  headers  || {};      headers [ "Accept" ] =  "application/json;odata=verbose" ;      if  ( method  ==  "POST" ) {          headers [ "X-RequestDigest" ] =  $ ( "#__REQUESTDIGEST" ). val ();     }      var   ajaxOptions  = {          url :   url ,          type :   method ,          contentType :   "application/json;odata=verbose" ,          headers :   headers     };      if  ( typeof   payload  !=  'undefined' ) {          ajaxOptions . data  =  JSON . stringify ( payload );     }      return   $ . ajax ( ajaxOptions ); } function   getListItemsByCAML ( webUrl ,  listTitle ,  queryText ) {      var   viewXml  =  '<View><Query>'  +  queryText  +  '</Query>

SharePoint Get list items by CAML query - REST API

 Below is the javascript code for getting list items by CAML Query. function   executeJson ( url ,  method ,  headers ,  payload ) {      method  =  method  ||  'GET' ;      headers  =  headers  || {};      headers [ "Accept" ] =  "application/json;odata=verbose" ;      if  ( method  ==  "POST" ) {          headers [ "X-RequestDigest" ] =  $ ( "#__REQUESTDIGEST" ). val ();     }      var   ajaxOptions  = {          url :   url ,          type :   method ,          contentType :   "application/json;odata=verbose" ,          headers :   headers     };      if  ( typeof   payload  !=  'undefined' ) {          ajaxOptions . data  =  JSON . stringify ( payload );     }      return   $ . ajax ( ajaxOptions ); } function   getListItemsByCAML ( webUrl ,  listTitle ,  queryText ) {      var   viewXml  =  '<View><Query>'  +  queryText  +  '</Query></View>' ;      var   url  =  webU