Gaurav's Tech Blog

In the era of digital transformation, artificial intelligence (AI) is revolutionizing how businesses operate. Microsoft Power Automate, a robust automation tool, integrates AI capabilities to enhance workflows and drive efficiency. This blog explores how Power Automate AI Models can be leveraged to automate complex tasks and make data-driven decisions. What are Power Automate AI Models? Power Automate AI Models are pre-built and customizable AI solutions that can be integrated into your workflows. These models enable you to automate tasks that traditionally require human intelligence, such as recognizing text in images, analyzing sentiment in text, and predicting outcomes based on historical data. By incorporating AI models into your workflows, you can streamline processes, reduce manual effort, and improve accuracy.  Key AI Models in Power Automate 1. Form Processing: This model extracts information from structured documents like invoices, purchase orders, and surveys. It can iden...

In today's fast-paced digital world, efficiency and automation are key to staying competitive. Microsoft Power Automate, formerly known as Microsoft Flow, is a powerful tool that enables businesses and individuals to automate repetitive tasks and streamline workflows. Whether you're a seasoned professional or just starting out, Power Automate offers a range of features that can help you save time and increase productivity. What is Power Automate? Power Automate is a cloud-based service that allows users to create automated workflows between various applications and services. These workflows, known as "flows," can be triggered by specific events, such as receiving an email or updating a record in a database. With Power Automate, you can connect to a wide range of Microsoft and third-party applications, making it a versatile tool for automating tasks across different platforms. Key Features of Power Automate 1. Pre-built Templates: Power Automate offers a vast library o...

  How to call Dataverse REST Web Api from postman or power automate desktop. Note:  <Value>: Either custom value or value from previous steps. What do we need? - Postman:  Download Postman | Get Started for Free - PAD:  Install Power Automate - Power Automate | Microsoft Learn - D365 environment URL - O365 Entra/*Global admin.   ----X---- Let's get started. Register an app using MS Entra Platform:  Go to: https://entra.microsoft.com/ -> Identity -> Applications -> App registrations -> New registration Official link: https://learn.microsoft.com/en-us/entra/identity-platform/quickstart-register-app   Name: <Provide Name> Supported account types: Single tenant. Redirect URI: https://localhost Update Manifest file: Set oauth2AllowImplicitFlow to true. Grant Permission to access Dataverse (AKA Dynamic CRM) API Permissions -> "+ Add a permission" "User_impersonate" -> "Add permissions" Grant API Permissions (Note: Only...

How to call SharePoint online rest APIs using postman? Step 1: Install Postman:  https://www.getpostman.com Step 2: Generate Client ID and Client Secret               Use below URL (Update Initial part):               <SPO Site Collection URL>/_layouts/15/appregnew.aspx               Note :                You can visit below URL to see all registered apps.                 <SPO Site Collection URL>/_layouts/15/AppPrincipals.aspx Step 3: Grant correct permissions to app and authorize it.                Use below URL (Update Initial part) : <SPO Site Collection URL>/_layouts/15/appinv.aspx Example of  permissions XML : Full control on site collection (Please do not change site collection URL or any ...

Chrome Extension to auto refresh Power BI report. Requirement  :  Power BI report will be visible on monitor/projector and team will monitor it live. Report needs to refresh on it's own every 5 seconds. Power BI : We created report with SQL direct query so report shows current data when accessed or clicked refresh on report. https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery Solutions : #1 :  Refresh full page every x seconds https://chrome.google.com/webstore/detail/auto-refresh/ifooldnmmcmlbdennkpdnlnbgbmfalko?hl=en-US Issues with above solution : Extension refreshes full page (browser refresh) so screen becomes blank for second(s). If user want to click on report and see the data, it can cause issue if page refreshes at same time. #2 : Created new chrome plug in / Extension so it will click refresh button after N (seconds) interval, so it will only make AJAX call and refresh report data (not entire page). https://chrome.google.c...

How to update Site collection audit settings for SharePoint online with document library ? Prerequisite 1 : Install SharePoint Online Management Shell (Google term if below link breaks) https://www.microsoft.com/en-us/download/details.aspx?id=35588 FYI : AuditMaskType enumeration : https://docs.microsoft.com/en-us/previous-versions/office/sharepoint-server/mt125231(v=office.15) ID Microsoft.SharePoint. Client.AuditMaskType Enum Value UI Options 1 All -1 Not available from UI 2 CheckIn 2 Checking out or checking in items   3 CheckOut 1 Checking out or checking in items   4 ChildDelete 64 Not available from UI 5 Copy 2048 Moving or copying items to another location in the site   6 ObjectDelete 8 Deleting or restoring items   7 Move 4096 Moving or copying items to another location in the site   ...

Iterate through all SharePoint web-applications, site-collections, websites from PowerShell Please do not forget to comment if this helps. PS : $contentWebAppServices = (Get-SPFarm).services |  ? { $_.typename -eq "Microsoft SharePoint Foundation Web Application"} foreach($webApp in $contentWebAppServices.WebApplications) { try { if ($webApp.Url -ne "If you want to skip something") { write-host "Starting WebApplications : " + $webApp.Url foreach($siteColl in $webApp.Sites) { try { write-host "Starting SiteCollection : " + $siteColl.Url $site = Get-SPSite $siteColl.Url if ($site.Allwebs.Count -gt 0) { foreach($web in $site.Allwebs) { //Code for each web } } } catch [Exception] { write-host "Error in Code for : " $siteColl.Url } } } } catch [Exception] { write-host "Error in Code for : ...

How to open SharePoint online site in SharePoint Designer with MFA ? (Multi-factor authentication) Please do not forget to comment if this helps. Issue : SharePoint Designer does not support MFA Solution : While setting up MFA with O365, you must have received App password . Please use App password instead of regular network password/one time password. What if you don’t have/remember  App password  ? Please follow below steps to generate new  App password and use it for SPD. 1. Log into O365 from https://portal.office.com/ 2. Go to  https://account.activedirectory.windowsazure.com/r#/applications 3. Click of your name from right top -> "Profile" -> "Additional security verification" 4.   Go to tab “App Passwords” (Hidden tab : Follow screen shot) 5. Now you can create new  App password , just give a name and use it as you SPD password(you can also delete old if no longer required.) Keep...

Sharepoint : get all sites where feature is active at site or web level Please do not forget to comment if this helps. Get all Site Colletions where GUID matched to site colleation feature Get-SPSite -limit ALL | foreach{ $_.features["GUID"] } | select Parent Get all Webs where GUID matched to web feature Get-SPSite -limit ALL | Get-SPWeb -limit ALL | foreach{ $_.features["GUID"] } | select Parent

Scenario : Run JavaScript on page load but not on postback. Why : SharePoint does field validation on server side so it runs page load js again. Please do not forget to comment if this helps. Please use below script to avoid same : $(document).ready(function() { if((window.location.pathname).toLowerCase().indexOf("new.aspx") > 0) { if((document.referrer).toLowerCase().indexOf("new.aspx") < 0) { ExecuteOrDelayUntilScriptLoaded(functionToCall, "sp.js"); } } }); function functionToCall() { alert('Just on page load'); }