Corporate Programming

This post is to help you, how to get rid of delegation warnings in the Browse Gallery while filtering out the items from a SharePoint list without using any collection.  There are multiple ways to overcome the 5000 records limit in power apps(will cover them in coming posts). Script : use the below script in the Items action of  Browse Gallery. SortByColumns( Filter( [@Test],Department="HR" Or Department="IT",       StartsWith( Title, TextSearchBox1.Text ) ), "Title", If( SortDescending1,       Descending, Ascending ) )   For reference: Dry Run: The SortByColumns () function is to sort records alphabetically.  Filter() this function is to retrieve only required items from an SP list. e.g. employees belong to IT or HR. After retrieving the required data, we are using the StartsWith() to Search records. Final Result: Use case Or Where I used it? I'm working on

In this post, I will explain the process to extract hyperlinks from a text/hyperlinked text using VBA/macros.  Video : Click here to Watch Video. Follow the below steps: Open the Excel file and paste the hyperlinked text in the column first. Open view code window by holding alt+F11 . Paste the below code. Run the macro by using the "execute button" or by pressing F5 . In column B you will get the desired result. Code : Sub   ExtractHL ()      Dim   HL   As   Hyperlink      For   Each   HL   In   ActiveSheet.Hyperlinks          HL.Range. Offset ( 0 ,   1 ).Value   =   HL.Address      Next End   Sub  Thank you for reading the post!

  This post is to explain the process of deleting all items from a list on the basis of the status (e.g. status= completed) using PowerShell script in Sharepoint. To use the below script add your list/library name e.g. $docName=”<your list/library name>” and your SharePoint site/web address e.g.  $web = Get-SPWeb <your site/web address> Script: Add-PSSnapin  Microsoft.SharePoint.PowerShell  $web   =   Get-SPWeb  <your site/web Url> $docName = " <list/library display name> " $list   =   $web.lists   |   where   {$ _ .title   -eq   $docName} for ($x = $list.ItemCount - 1 ;$x   -ge   0 ;   $x -- ) {           $item = $list.Items[$x];           if ($item[ " Status " ]   -eq   " COMPLETED " )      {       Write-Host   " Deleting item id "   $item.ID       $item.Delete();                       } } $list.Update();

This post highlights how to remove all sub-sites or pages  permanently  from a specific SharePoint site collection/web using a PowerShell script.  Prerequisite     Before using the below script user needs admin-level access .    Change the site collection name as per your requirements. NOTE: Use Below Script and kindly pass the valid URLs/List Name to execute the script. Script: Add-PSSnapin  Microsoft.SharePoint.PowerShell  $site =Get-SPSite   - identity  < Your URL > $subSiteColl = $site.RootWeb.Webs; $subSites =@ () for ($i =   0 ;$i   -le   $subSiteColl.Count - 1 ;$i ++ ) {     $subSites   += $subSiteColl[$i]; } foreach ($subSite   in   $subSites){          $targetWeb =get-spweb   - identity  $subSite.URL;      $targetListGeneral = $targetWeb.lists[ " <List Name> " ];             if ($targetListGeneral){                    for ($x = $targetListGeneral.ItemCount - 1 ;$x   -ge   0 ;   $x -- )          {                   $item = $targetListGeneral.Items[$x];  

In this post, I will highlight the process of customizing the look & feel of a Sharepoint/MS list, the purpose of this post is to showcase the customized look & feel, if you like it please feel free to drop a note in the comment section, I will create a separate post to explain the process in depth. Prerequisite : To customize the look & feel of MS list a person should have good hands-on experience in JSON. What is JSON? JSON stands for JavaScript Object Notation, it is a lightweight format for storing and transporting data and often used when data is sent from a server to a web page. Will not talk more about JSON in this post if you feel interested kindly drop a note in the comment section will create a separate post to explain JSON in-depth in terms of the MS list. Before starting the actual coding part, kindly have a look at what exactly we are trying to achieve here. NOTE : Script will customize the look & feel of the course tracker list on the basis of the s

This BOT can help you to find all the working and non-working links on a page and you can check the status of as many pages as you want with minimal human intervention.  Use cases: Migration Site Audit