Netrix acquires PSC Group, a provider of cloud-focused application development and modernization services. The acquisition scales Netrix’s cloud application development and data intelligence practices for Microsoft Azure.
Just Marky
Cancel all running flow runs for a flow in an environment
I am repeating a sample found within the CLI for Microsoft 365 examples which was insanely helpful for me.
I created a bulk update of about 2000 items within a SharePoint list – each one triggered a flow and with 2000 flows running at the same time, they started to time out, fail and just not complete – I needed to cancel all of them and start again
I found the code block on the M365 CLI site as i listed above.
You need the following
Install the M365 CLI in windows
npm i -g @pnp/cli-microsoft365Log into m365 through a browser using
m365 login
Then run the following
$flowEnvironment = 'YourEnvironmentId'
$flowGUID = 'TheFlowGUID'
$flowRuns = m365 flow run list --environment $flowEnvironment --flow $flowGUID --output json | ConvertFrom-Json
foreach ($run in $flowRuns) {
if ($run.status -eq "Running") {
Write-Output "Run details: " $run
# Cancel all the running flow runs
m365 flow run cancel --environment $flowEnvironment --flow $flowGUID --name $run.name --confirm
Write-Output "Run Cancelled successfully"
}
}The Environment and flow GUID can be found within the URL of your flow
Within the flow manage, open your flow – the references we are looking for are in the URL
The environment = ‘Default-8a47f942-xxxx-yyyy-a2c7-ced012b09a0a’
The flow GUID = ‘f0d07662-9ab2-bbbb-aaaa-dd11f2f47a47’
The flow runs and the flow is cancelled.
Removing the social bar (“Like and Views”) from a SharePoint Online page
I came across the simple tip and thought it worth sharing
When you have a “Social Bar” on your SharePoint Page and you want it removing – you can do so at the Site or Tenant Level.
I found the following tip on StackOverflow for removing from a site
#---Disable Social Bar on Site Pages
Connect-SPOService -Url https://yourdomain-admin.sharepoint.com
$site = "https://yourdomain.sharepoint.com/sites/sitecollection"
Set-SPOSite -Identity $site -SocialBarOnSitePagesDisabled $trueBefore
After
Power Automate – UI flows
Power Automate acts like the glue holding together the interconnected web of Microsoft 365 and the broader partner eco-system. With the ability to trigger a “Flow” from hundreds of events on the platform, to perform thousands of potential actions, Power Automate is a compelling investment for companies looking seriously at no/low-code application integration.
Microsoft have extended Power Automate beyond the platform and onto the desktop with the addition of the UI Flows capability. Robot Process Automation (RPA) is the new kid on the block for companies trying to squeeze even more automation and productivity out of what’s left of their business processes.
For companies who are automating their business processes on the Microsoft 365 platform, adding RPA to the mix makes a lot of sense. Automating modern API based platforms to work together has been the theme of cloud platform delivery for years now. But it has never been able to achieve full integration with the manual repetitive processes which can consume many companies.
UI Flows are only in preview, but already Microsoft has released a significant capability for building Robots, the Power Automate Desktop. Using this tool anyone can start to build automation into their daily business processes.
My hope it to be able to start to write about Power Automate Desktop, learn about it’s features and create some compelling examples for our customers so that when it is finally released we will be able to provide the quality consulting that I know our customers have come to love about working with PSC………
Robot Process Automation
Robot Process Automation (RPA) as a technology group enables the automation of repetitive manual human tasks.
Imagine how much easier Excel Macros make an accounting process whereby a multi-stage process can be automated with the push of a button. Now imagine a multi-stage process where a human has to take data from Excel, or worse a paper document, and move it to another application such as a web site. RPA can do that for you.
– RPA can do that –
In an idea world where every system has a beautifully architected API integration layer, every system would be able to easily and quickly talk to every other system. In reality this is far from the case and a sleek and effective integration is either impossible or prohibitively expensive. RPA can do that for you.
Examples
Many companies have to go through a process of converting paper based data to electronic format. Whether it is incoming invoices, logistics documentation or even waste disposal profiles, there are thousands of people who’s role is to type data from paper into a website.
Through a relatively simple process of connecting the dots, a Robot can be configured to be responsible for:
- Collecting the data from an Automated OCR process
- Open a web browser and log into the ERP system
- Map the data from the form to fields on a web form
- Submit the web form
Reducing Risk
RPA Robots aren’t error prone. Robots will do exactly what is expected of them. In an business, mistakes cost money and in especially heavily regulated environments the consequences of putting the wrong value in fields can be significant.
Increasing productivity for everyone
Robots are also quicker than people, reducing the time taken for process completion. This then also frees up the people to be able to work in other areas of a business and bring their experience to bear in other ways.
There are many vendors in the RPA space, and Microsoft has entered the foray by extending their Microsoft 365 Power Automate platform to include UI-Flows. https://flow.microsoft.com/en-us/ui-flows/ I am going to write about Power Automate and ui-flows specifically as I believe it will be a significant game changer for our client in the future.
Web development in Chrome with cache off – all the time
I can’t believe I didn’t know this sooner.
Chrome Developer Tools – Network Tab – Disable Cache
Brother printer keeps dropping from wi-fi? – turn on IPv6
My Brother color laser keep dropping from the wi-fi after 5 minutes for no good reason
I found this solution and it worked for me – hope it helps someone else
Speaking: The Microsoft Graph – The API to rule all APIs
I am speaking this coming week at the #NWCJS meetup @PSCGroup
The Microsoft Graph – The API to rule all APIs
The Microsoft Graph sits on top of the Office365 SAAS platform. Over many years Microsoft has been building up the capabilities of “The Graph” to make it insanely powerful and allow enterprises to programmatically manage their entire platform.
From the simplest tasks of sending an email, to accessing a table in excel from an API! From accessing the security logs of the SAAS platform to the fact that they made all this available to play with through Postman. There is nothing not to love about the Microsoft Graph and what it means to developers. Did I mention the Delta query capability for tracking changes since you last asked? Or the batching capability? 😲
Come and see how the Graph is arguably the API to rule all APIs.
Looking forward to SharePointFest Chicago Dec 2019
If you are considering going to SharePointfest Chicago 2019, hopefully this will make your decision a little easier 🙂
It’s a great conference and I always look forward to it coming around at the end of the year.
Speaking at Mar 2019 Office Add-Ins Community call
It’s this week !!
Office Add-ins community call, this Wednesday, March 13 at 8:00am PST
Join us for the March community call to connect with the folks who are building the Office JavaScript APIs.
Agenda:
- Doug Mahugh: High-level overview of Office (web) Add-ins
- Sohail Zafar: What’s new with Outlook JavaScript APIs
- Nitesh Golchha: Office Add-ins Single Sign-On (SSO)
- David Chestnut: Office Add-ins Patterns & Practices
- Sudheer Maremanda: Edge WebView control for the Office Add-ins platform
- Mark Roden of PSC Group: Office Add-in demo (Word & SharePoint integration)
- Q&A
Xomino 