Category: Workflow & Automation
-
Transforming Collaboration During COVID-19
A blast from the past this one! During 2019 we stated rolling out Office 365 – putting Teams front-and-center. By the start of 2020 the roll-out was largely complete – but training wasn’t fully ramped up and staff were still getting to grips with things. Then COIVD hit, and office staff all suddenly had to…
Written by
-
Automate Contract Generation with SharePoint and Adobe Sign
I have previously written a couple of blog posts (1, 2) about elements of this system – but haven’t done an overview – so here it is! We issue data sharing contracts with third parties – sometimes several a month. The basics of these contracts are exactly the same with only a few details needing…
Written by
-
Improving Audience Surveys for Cultural Organisations
In the UK, many cultural organisations receive funding from Arts Council England (ACE). To help justify this funding ACE would like to know a bit about the audiences that these cultural organisations attract. And this data is also useful for the organisation itself – it can help the organisation understand their audiences and show how…
Written by
-
Hide Automate Button in SharePoint List CommandBar with JSON
A while ago I was playing with a Sharepoint list for generating data sharing contracts, and added a context-sensitive button in a column to trigger a flow. This would send the data to AdobeSign to fill into a template, and set off a signing process. Since then I’ve found a whole collection of JSON snippets…
Written by
-
Enhance SharePoint Lists with JSON Snippets for Advanced Formatting
This will be less of a blog post – and more of a place for me to save a useful resource so I can find it again: https://github.com/pnp/List-Formatting This is a collection of JSON snippets to add enhanced formatting for SharePoint lists. Why? Let me give you an example. Currently I’m moving our cyber risk…
Written by
-
Power Automate and the missing headers
I’ve been using Power Automate with a Custom Connector to our on-prem CRM to do various automation things. We recently ran a CRM update – which necessitated creating a new Power Automate custom connector as the API definition changed. Our CRM does provide a Swagger file – but it’s too large for Power Automate (around…
Written by
-
Disable “stale” user accounts for Office 365 and on-prem hybrid
We recently had a cyber audit at work – and one of the recommendations was to ensure that any user accounts not used within 90 days were disabled. Prior to us moving to Office 365 hybrid we did have an on-prem tool that would do this for us, checking on-prem domain controllers for last login…
Written by
-
Cancelling Flow runs – surely it should be easier than this?
I have a Microsoft Power Automate Flow that is triggered by a webhook – and for “reasons” it received thousands of triggers that I didn’t want: Thousands of Flows that are about to do something that I don’t want…. Thousands. Luckily time is on my side – Power Automate will only let a few Flows…
Written by
-
Button in SharePoint list to trigger PowerAutomate/Flow – a few tweaks
The situation I have a SharePoint list which holds information for generating data sharing contracts with external partners. I have a Flow linked to this that sends the data from the selected item over to Adobe Acrobat Sign to insert into a template, and then send out for electronic signature. Can it be improved? I’m…
Written by
Matt Kirby 