Thursday 6 February 2020

Power Automate Limitations

Power Automate -- There are some Limit which you might not know.

1. No. of flow user can create -- 250

There is a limit of 250 flows that a single user can create. After this you simply get the error and you can’t save any more flows. If you hit the 250 limit you can raise a support ticket and then the limit will be raised.

2. Do Until Loops -- 60 runs by default

When running Do Until loops Flow will only run 60 times through the actions inside a Do until.  Luckily it is possible to change this limit within the flow editor.

Powershell script to update All Lists and Library to Modern Experience in SharePoint Online Site.

#This script uses PnPPowerShell commands, hence ensure you have already installed #SharePointPnPPowerShellOnline

#Import module
#Import-Module SharePointPnPPowerShellOnline -ErrorAction "stop"


#Specify tenant admin and site URL, credentials
$OlUser =  "adminaccountemail@domain.com"
$OlPassword = "password"
$securePassword = ConvertTo-SecureString $OlPassword -AsPlainText -Force
$OlSiteURL = "https://Online site url"

#Bind to site collection
$OlCreds = new-object -typename System.Management.Automation.PSCredential -argumentlist $OlUser, $securePassword
$SPOnlineConnection = Connect-PnPOnline -Url $OlSiteURL -Credentials $OlCreds
$OlContext = Get-PnPContext

#Disable feature at site collection level to enable modern experience at SC level
Disable-PnPFeature -Identity E3540C7D-6BEA-403C-A224-1A12EAFEE4C4 -Scope Site -Force

#Disable feature at web level to enable modern experience at web level
Disable-PnPFeature -Identity 52E14B6F-B1BB-4969-B89B-C4FAA56745EF -Scope Web -Force

#Enable new experience for all lists
$allLists = Get-PnPList
foreach($list in $allLists)
{
$OlContext.Load($list)
$OlContext.ExecuteQuery()
$list.ListExperienceOptions = "NewExperience"

$list.Update()
$OlContext.ExecuteQuery()
Write-host $list.Title -ForegroundColor Green     
}