Tuesday, December 1, 2020

Difference between PowerApps and MS Flow?

 PowerApps:

  • Repeatable operation occurred frequently and it takes a lot of time in total of a user 
  • Integrate different components or platforms of your digital workplace 
  • Quick time by cutting down the overall implementation time
  • Task-oriented processes can be implemented on PowerPlatform.
  • Improve productivity in your Office365 environment
  • Security and contextual data trimming is important for us
  • Business process implemented in Excel 

MS flow

  • User friendly drag & drop
  • Not enough integrators
  • Requires developers
  • The designers were not browser based products

  • Not mobile friendly

  • Ability to export and import workflows

Get lists and libraries where throttling is disabled using powerShell

  •  how to disable throttling on single lists but if we don’t monitor this and keep disabling it can turn in to a nightmare for admins. 
  • When you disable throttling on a list basically you give it a pass to go and complete the operation no matter how long it takes.
  •  This is not a good idea especially when the number of items in the list/library is large.
  • This will block other operations /queries from execution and can cause a huge increase in the page load or overall performance of Sharepoint farm.
  • Also, there is a reason why MS has implemented this feature at the web application level at Manage web applications > Select web application > General Settings > Resource Throttling.
  • So back to the issue, I wanted to find out if there are more than one lists/libraries with throttling disabled.


$WA=Get-SPWebApplication http://str-emp.peakfinder/
$SCs=Get-SPSite -WebApplication $WA
Foreach($SC in $SCs.url)
{
$Webs=Get-SPWeb -Site $SC
foreach($web in $Webs)
    {
        $Lists=$web.Lists
    foreach ($list in $Lists)
        {
        if($list.EnableThrottling -eq $false)
           {
           Write-Host "Site Name = " $web.Title
           Write-Host "Site URL = " $web.Url
           Write-Host " Throttling is Disabled on " $list.Title 
           }
        }
    }
}

Saturday, November 28, 2020

sharepoint logo update new method

Sunday, November 8, 2020

PowerShell: How to update column with managed Metadata ?

Below PS script to update a manage metadata column. We can update columnby updating a managed-metadata column. Format of value is  "16;# Warriors" in groupType field.

$weburl="/sites/manager"
$web = Get-SPWeb $webUrl
$list = $web.Lists["department"]
$ct = "Deptgroup"
$f = "groupType" #Column Name      
$newTerm = "10;#test
 Agreement|1273c09f-4ar1-453e-8422-60601d61bd11"

foreach ($item in $list.items)
{
    try {
        If ($item.ContentType.Name -eq $ct)
        {           
            $field = $list.Fields[$f]
            $fieldValue = $item[$f]

            if($fieldValue -eq $null)
            {               
                $item[$field] = $newTerm                
                $item.Update();                     
            }
        } 
        }   
    catch{
        Write-Host $item.Name " error occured" 
        }   
#finally dispose the web
$web.dispose()
#updatelisitems #managedmetadata #columnname

Wednesday, November 4, 2020

Microsoft Teams Gets New Features Like Live Captions and reports etc.,

  •  Its video conferencing tool 
  • Live captions with speaker attribution
  • feature is applicable for all versions
  • Allow meeting organisers and presenters to prevent attendees from unmuting
  • Teams meetings and call recordings can now be stores in OneDrive or in SharePoint
  • Allow IP video policy to prevent both outgoign and incoming video as required
  • App spotlight