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


Sunday, August 9, 2020

MOCA

Modern collaboration architecture for #microsoft365#SharePoint #microsoftteams #powerapps

Friday, July 24, 2020

powershell update Peoplepicker in List In SHarePoint

#Read the CSV file 
#stored local variable 
$delimitercsv = "|" 
$filePath = "C:\peakfinders.csv" 
$userid = "EmpID"
$useremailowner = "Owner"

#Get the SharePoint List
$tWeb = Get-SPWeb -identity "http://sharepoint.peakfinders.com" 
$list = $tWeb.Lists["Employee"]
$CSVData = Import-CSV -path $filepath | ForEach-Object {
    Write-Host "$($_.ID) ,$($_.'Email-Address')";
foreach($sitem in $items)
{

$userid = $sitem['EmpID']
if($userid.LookUPid -eq $($_.ID)){
$sitem["mail"] =$($_.'Email-Address');
$sitem.Update()
}
}
}

JavaScript : How to Convert UTC Date Time to local/EST Hours using JavaScript?

In this below script, Convert UTC Date Time to local/EST Hours

Convert UTC Date Time to local/EST Hours In SharePoint
In this article , we will use default java-script action

Type 1:

var localTime = new Date();
var localKolkata = moment.tz(localTime, "Asia/Kolkata").format("hh:mm:ss");

Javascript script provide date and time format.

Type 2:

function getLocalTime(i) {
    if (typeof i !== 'number') return;
    var d = new Date();
    var len = d.getTime();
    var offset = d.getTimezoneOffset() * 60000;
    var utcTime = len + offset;
    return new Date(utcTime + 3600000 * i);
}

#sharepoint #javascript #datetime #jquery #convertdatetime

Wednesday, March 11, 2020

New Visual studio code 1.43 version updated PowerShell 7 version

Visual Studio code 1.43

Big structural changes integrated for MS PowerShell users'. Hereafter Developer favorite tools in Visual Studio Code.


PowerShell user and a fan of the Integrated Scripting Environment (ISE), you now have the option to flick on ISE mode in Microsoft's Visual Studio Code (VS Code) cross-platform code-editing tool. 

The new PowerShell extension preview for VS Code includes a 'switch' that developers can flick on in VS Code to replicate the ISE experience in PowerShell version 6 and below. 

ISE is no longer supported in the PowerShell extension for VS Code even though Windows still ships with ISE. Now users need VS Code with the PowerShell extension and can type a simple editor command to enable or disable ISE Mode. The new PowerShell extension preview for VS Code includes a 'switch' that developers can flick on in VS Code to replicate the ISE experience in PowerShell version 6 and below. 




ISE is no longer supported in the PowerShell extension for VS Code even though Windows still ships with ISE. Now users need VS Code with the PowerShell extension and can type a simple editor command to enable or disable ISE Mode. 



The PSReadLine module with syntax highlighting, multi-line editing, and back search is also now part of the VS Code integrated console for Windows, macOS, and Linux, satisfying a top user request, according to Microsoft. 

Read more

https://code.visualstudio.com/updates/v1_43



Wednesday, June 13, 2018

Extending a Web Application in SharePoint 2010

The steps to extend a Web application using Windows-classic authentication in Windows PowerShell is as follows:
·         On the Start menu, click All Programs.

·         Click Microsoft SharePoint 2010 Products.

·         Click SharePoint 2010 Management Shell.

·         To extend a Web application to the same port, but with a different host header, at the Windows PowerShell command prompt, type the following command:

Get-SPWebApplication –Identity <Identity> | New-SPWebApplicationExtension -Name
<Name> -HostHeader <HostHeader> -Port <Port> -Zone <Zone> -URL <URL>

Where:
·         <Identity> is the Web application that you want to extend.
·         <Name> is the name of the new IIS Web site in the Web application.
·         <HostHeader> is the host name assigned to this zone of the Web application.
·         <Port> is the port on which this zone of the Web application can be accessed.
·         <Zone> is the zone with which this new extension is to be associated.
·         <URL> is the public URL for this Web application zone.