SharePoint Widgets

  What if the SharePoint list or library grew too big? This is a very common question when you are designing the SharePoint solution. So in this article, I will try to explain how you can do that. Impact of unhandled Large List So, the problem first, What is the impact if it grew too large..?? Will we lose data ... ?? NO Will, the data be deleted... ?? NO Is data not safe.. ?? NO What is the Threshold limit? So what is the impact of a large list?? yes, Threshold is the cause The impact is that you will get the threshold error if your view contains records greater than 5000. When any list or library view returns records of more than 5000 it displays the threshold error. This is the hard-line limit a view can show up the number of records. So, there are multiple ways you can handle this error Solution 1: Switch to Modern View, as the latest the best and will be continuously improved. For modern Microsoft is continuously evolving and more enhancement will be there in the future. Solution

  In many cases, we need to identify the versions of the SharePoint List Item. So here is the way to get all the versions of the item using PnP. function   Get-ItemVersion  {      param  ($spURL, $spListTitle)           $checked  =  ([ char ] 8730 )           Write-Host   " Creating connection to the SharePoint Online..... "   - ForegroundColor Yellow  - NoNewline     $spConnection  =   Connect-PnPOnline   - Url $spURL  - UseWebLogin  - ReturnConnection  - ErrorAction Stop      Write-Host  $checked  - ForegroundColor Green       Write-Host   " Reading list items from ' $listTitle '..... "   - ForegroundColor Yellow  - NoNewline      $listItems  =   Get-PnPListItem   - List $spListTitle  - PageSize  5000    - Connection $spConnection  - ErrorAction Stop           Write-Host  $checked "  ($( $listItems.Count ) in $((( Get-Date )  -   $start ).Seconds) sec) "   - ForegroundColor Green      $listItems |  ForEach-Object  {          $listIt

  While displaying reports it is very common to convert the units. So today I will be displaying the function that can be used in order to convert the Units Space  = VAR  total  =     SUM ( Table1[ Used   Space ] )  +   0 RETURN      IF  (         total  <   1024 ,         FORMAT ( total,  " #0.0# B "  ),          IF  (             total  <  POWER (  2 ,  20  ),             FORMAT ( total  /  POWER (  2 ,  10  ),  " #0.0# KB "  ),              IF  (                 total  <  POWER (  2 ,  30  ),                 FORMAT ( total  /  POWER (  2 ,  20  ),  " #0.0# MB "  ),                 FORMAT ( total  /  POWER (  2 ,  30  ),  " #0.0# GB "  )             )         )     ) So if you look into the function the core logic is      B  -->  KB then divide by POWER (  2 ,  10  )     B  -->  MB then divide by POWER (  2 ,  20  )     B  -->  GB then divide by POWER (  2 ,  30  )      And...      KB  -->  B then multiply by POWER (