Tag: MicrosoftFlow
95 posts.
-
AI Agents for Power Automate
We are seeing a very strong interest and response in our release of Flow Studio MCP . So we want to get the word out more. AI is rapidly moving beyond...
-
Flow - lightweight fast template engine using Split twice
Technique 2 — Building a Lightweight Template Engine (Using Split Twice) Take this example (using a handle-bar stil syntax) ABC {{def}} GHI {{jkl}} MN Using...
-
Mathematically Elegant way to Flatten an Array of Arrays in Power Automate
When working with data in Power Automate, you may encounter nested arrays (arrays within arrays) —especially when dealing with JSON responses, SharePoint...
-
A debug tip for complex conditions in Power Automate #FlowNinjaHack 126
This is #FlowNinjaHack 126 Sometimes, we have complex Condition blocks in Power Automate. And when we run the flow, it just shows “false”, which is a bit...
-
Updates to Flow Studio App in 2023 October
There’s been a series of updates to Flow Studio App on our development build, as I’m preparing to push this next stable build to production, I thought I’d...
-
Power Automate API changes - v2 Admin scope now needs user_impersonation
This blog post is about two major updates to Flow Studio App and Flow Studio for Enterprise. MSAL v2 Update First one, we finally updated Flow Studio to...
-
field notes using Power Automate with Power BI
I have been working at a client learning, testing and building Power BI reports, datasets, dataflows, datamart and dashboards for the last 8 months. With a...
-
Turning a new page
Wanted to write again, and let everyone know what I’ve been up to. I ended up taking a break through most of 2021 and 2022 simply resting, recovering, and...
-
Parse CSV through Code in Power Automate Custom Connection
I was inspired reading Alex Shlega and Hiroaki Nagao ’s posts on using code with custom connections. So I set out to give it a go and work on another common...
-
Self-service Microsoft Form for external guests to use Power App
This is a walk through of the steps to create a self-service guest user sign up using Microsoft Forms and redirects to the Power App. Steps Create a...
-
How to provision SharePoint list and resources with only standard Microsoft Flow using ExecuteSiteScriptAction
I wanted to blog about an interesting technique I was testing - how to call ExecuteSiteScriptAction from Microsoft Flow - and using that to provision...
-
Where to find John presenting in May 2020
We are living right now in a strange time. At home, and virtual events are replacing the traditional physical events. I’ve agreed to several events and will...
-
Flow JAM Stack Episode 1 - sending data back with Flow as API
In this follow on episde, we dive a fair way in to see how we can customize Flow’s Request trigger to build a web service (API endpoint) that can be called...
-
Building modern public sites (JAM Stack) with Microsoft Flow
Web technologies evolve, and we are on the edge of a new stack, it is called JAMStack. Javascript API Markup In the world of JAM Stack, we create serverless...
-
Using Flow to create Microsoft Teams online events via Microsoft Graph
I had a Flow hack a while back to have a Flow button that will instantly create an online teams meeting. Recently, I adapted it into a trigger event that...
-
Power Studio Update April 2020
I wanted to share our most recent newsletter for Power Studio (previous Flow Studio) and Power Clarity. It was supposed to be monthly, but everything’s gone...
-
Implementing a fast sort with Microsoft Flow using Parallel Compute
This is #FlowNinja hack 112. Parallel Compute Sort. I had written about how to sort with a variable (this is insertion sort) back in 2018 How to implement...
-
Flow - Format Number advanced tips and tricks
I put together a video to celebrate the new update in Microsoft Flow (Power Automate) and Logic Apps - formatNumber() The video explains 3 tips and 2...
-
True Governance of the Power Platform
It’s very early Sunday morning and I’ve just returned from an red-eye flight home from a week spent in Perth with Paul, Ashlee and Terrie Culmsee, meeting...
-
Presentations at the Digital Workplace Conference Australia 2019 I’m looking forward to
It’s really exciting for me to be back at the Digital Workplace Conference again in 2019, this is one of the first major conferences that I was very...
-
Presenting a roadmap to learning and mastery of Microsoft Flow at Collab365 Microsoft Flow Virtual Summit
All the Flow you can eat! https://events.collab365.community/microsoft-flow-virtual-summit-agenda/ I managed to squeeze in last minute with a session on “A...
-
100 Flow-jutsu of the FlowNinja
Upon reaching a numerical significant milestone of 100 FlowNinja flow-lifehacks. I wanted to review the full list and provide that list here for your...
-
The Flow Studio journey and July price increase
I wanted to write an update about Flow Studio, my personal journey so far as a single founder, and announce that there will be a price increase at the end...
-
Getting started, a roadmap and mastery of Microsoft Flow
In the last few years, Microsoft Flow has taken off like a storm. It is one of the most versatile product, but also quite tricky to completely cover because...
-
Release of Flow Studio: Deploy & future Price Increase
We have released Flow Studio v0.1.91 “Flow Studio: Deploy” This is a super productive feature that we’ve been working on for a while. You can think of it as...
-
Join us for a free full day Sydney Microsoft App in a Day - June 7
Join Microsoft MVPs John Liu and Paul Culmsee - two of Australia’s Power Platform MVPs in Microsoft’s App in a Day event on June 7 right here in Sydney. I’m...
-
One Flow to handle them all - Part 2 figuring out the changes
I had previously wrote a method of using Microsoft Flow to subscribe to all the lists in a SharePoint site - and how to have them all call a second Request...
-
Workarounds needed to use the Excel Connector in Microsoft Flow
There are two Excel Connectors in Microsoft Flow. There’s a quirk to work with them. Plan Two Connectors How do we use them? What’s the problem we need this...
-
Flow Studio 1K users - time for a roadmap update
In the past week - total number of Flow Studio users crossed over 1000. We have 1000 users! We want to thank you, Flow makers, for your support. When you...
-
Flow Studio features in April that will help us mitigate a disaster
In the best scenario, nothing ever fails. Your code and logic doesn’t fail, flows don’t fail, SharePoint doesn’t fail, Azure doesn’t fail. Some days like...
-
A Power User friendly method of connecting hundreds of sites, list and libraries to a single Flow
[caption id="" align="alignnone" width="800"] Photo by Sebastian Boring on Unsplash [/caption] We need to get this disclaimer out of the way first - this...
-
Azure Global Bootcamp Sydney - this Saturday!
[caption id="" align="alignnone" width="800"] Photo by James Ree on Unsplash [/caption] I’m presenting a talk on Azure Logic Apps (and Microsoft Flow) this...
-
Upload Image from PowerApps to Flow to SharePoint via an Unused Outlook connector
This is the simplest no code approach to the PowerApps image upload problem so far. Far simpler than with Azure Function, with custom connector, with hacked...
-
One Flow to handle them all - how to subscribe to multiple SharePoint lists with one Flow
One Flow to handle them all - how to subscribe to multiple SharePoint lists with one Flow At some point - we think hmm how do we save a Flow as a template...
-
On using Microsoft Flow as a pre-ETL step for Power BI
[caption id="" align="alignnone" width="2087"] Photo by WeRoad on Unsplash [/caption] A topic I’ve presented a few times to an Power BI crew is the concept...
-
#FlowNinja hack 78 - modifying Modified By and Modified time with Microsoft Flow
In this quick blog post - we talk about how we can tweak the “Modified By” user field and “Modified” datetime field in SharePoint list and document...
-
Difinity Conference 2019 Auckland - Hackathon Workshop, Flow and PowerApps
I’ll be presenting at Difinity Conference 2019 Auckland on several presentations. Difinity is the largest Microsoft Data Platform conference in New Zealand....
-
MS Ignite the Tour 2019 Sydney - MS Flow x2
I’ll be presenting at Microsoft Ignite the Tour 2019, Sydney on two Microsoft Flow presentations. Advancing the Flow - understand expressions in Microsoft...
-
How to implement Sort with Microsoft Flow in 3 actions within a loop
[caption id="" align="alignnone" width="800"] Photo by Sophie Elvis on Unsplash [/caption] For some reason, Flow (and LogicApps) doesn’t have a built in...
-
Sending email with inline images via MicrosoftGraph and MicrosoftFlow
I had previously written how we can use Send Email as Anyone in Microsoft Graph , and as a bonus wrote a section on how we can use it to send inline images....
-
Decode InfoPath attachments with a bit of JS AzureFunctions
Serge, April and me were discussing a problem with pulling out InfoPath Attachment from InfoPath form XML and writing them into a SharePoint document...
-
Hiding your Microsoft Flow valuables I mean variables out of sight
[caption id="" align="alignnone" width="530"] Photo by Annie Spratt on Unsplash [/caption] Today is a quick #FlowNinja post on a strange technique. Hiding...
-
Flow Studio has a new logo
Flow Studio https://flowstudio.app has a new logo! I don’t know why I’m so happy about this, but I am. Did you draw that John - yes on the back of an...
-
Microsoft Flow HTTP Trigger <> Request Trigger, and you probably don't want to use it
Microsoft Flow has a fairly good UI update today, and with this a few “hidden” built-in triggers appeared. The GeoFence Trigger is not available yet. But...
-
Two free tickets to great Office 365 and SharePoint events in Sydney in the next month
[caption id="" align="alignnone" width="2500"] Photo by Fancycrave on Unsplash [/caption] I wanted to write about two free upcoming events regarding Office...
-
From Office 365 to Azure Event Grid, the events must Flow
[caption id="" align="alignnone" width="2500"] Photo by Archana More on Unsplash [/caption] In this blog post, we capture all the events across an Office...
-
The curious tale of the result() function in Flow and LogicApps
[caption id="" align="alignnone" width="2500"] Photo by Andrew Neel on Unsplash [/caption] I owe this blog post to several persons, so I will list their...
-
Make a wishing wand - why we need a MicrosoftFlow Custom Connector for MSGraph $Batch
[caption id="" align="alignnone" width="2500"] Photo by Jorigė Kuzmaitė on Unsplash [/caption] A question that has been in the back of my mind since my late...
-
Office 365 Saturday Adelaide - 2018 September 15
So it is said - there's always a SharePoint or Office 365 Saturday every Saturday around the world. O365 Saturday Adelaide / SPS Saturday Adelaide In less...
-
Microsoft Graph Community Call September 2018 - $Batch and Flow
I wanted to write a quick blog post letting everyone know I've put my hands up to present a 10 minute demo on using a Custom Connection for Microsoft Graph...
-
The simplest No-Code Solution to Save Picture Files from PowerApps to Flow
Today, we are going to talk about a new technique (hack) to send any pictures from PowerApps to Flow. We will do this with a modified Flow Button trigger....
-
Speaking and Hackathon at Digital Workplace Conference Australia - Melbourne
In a little less than a month on August 15-16, I'll be presenting in Melbourne at the Digital Workplace Conference Australia 2018. www.dwcau.com.au (I still...
-
Flow For-Selected-Item trigger and SharePoint Site Pages, in a detective story
This is a long blog post, there are two parts: How do you make a SharePoint For Selected Item in Flow, and have it appear on the SharePoint Site Pages...
-
10 Things in Microsoft Flow that isn't in Azure Logic Apps
Sorry about the catchy headline. I will start by saying I am perfectly ready to see a response post containing 20 things in Azure Logic Apps that we wish...
-
A Thesis on the Parse JSON action in Microsoft Flow
Parse JSON can be both intelligent and dumb. It can help you a lot and it can hinder you just as much. This blog post, we go deep and study the behaviour of...
-
How to get live FIFA Worldcup results via Microsoft Flow into your SharePoint Intranet WebPart
Github tweeted a link to a NPM NodeJS CLI project that uses data from http://football-data.org. Seeing that, I decided we need to build a SharePoint Modern...
-
Do bulk insert/update in Microsoft Flow with two simple elegant filter-arrays
This is a blog post of a pattern that I've brooded over for months and finally came to an elegant solution. Plan Scenario: Bulk Insert / Update Doing...
-
Do Group By in Microsoft Flow with two simple elegant loops
This is a problem I worked on with Fausto and is a common problem I see when working with rows of data in Microsoft Flow. Plan Scenario: Group By Doing...
-
Save all your Flows to VSTS via HTTP REST in 8 actions
I saw VSTS has " Send an HTTP Request to VSTS " a few days ago, and a quick test had me pulling back repo information in JSON. #FlowNinja new @MicrosoftFlow...
-
Building a tool to help everyone with Flows: Flow Studio
So, I've been head-down, deep building a tool to help everyone make better Microsoft Flows It doesn't have many bells and whistles, it is still in very...
-
Microsoft Flow: SharePoint Trigger on specific fields changed via SP HTTP Request
A very common request in Microsoft Flow for SharePoint is a trigger that only runs when a certain field has changed, or when it has changed to a certain...
-
How to use Select to simplify Create-HTML-Table and Create-CSV in MicrosoftFlow
This is a blog post about how using Data Operations - Select in Microsoft Flow can dramatically simplify Create HTML Table or Create CSV. This is mostly...
-
Run any PnP-PowerShell in one AzureFunction from Microsoft Flow
Are you missing a SharePoint connector in Flow? Do you need that one extra thing that's only in PnP-PowerShell (because there are 300 cmdlets in...
-
Test yourself. A MicrosoftFlow Expressions Quiz!
I had an idea a while ago that a Quiz built with Microsoft Form would be a great way to learn and improve our knowledge of Microsoft Flow expressions. For a...
-
Two complementary MicrosoftFlow podcasts in March, and Two Plateaus of MicrosoftFlow
I finished listening to the Hyperfish Microsoft Flow podcast from Jon Levesque and Jeremy Thake this morning, this was recorded around the same time where I...
-
Design a "Delay until SharePoint File Changed" HTTP+Webhook for MicrosoftFlow
I love challenges - I love hearing people say "We need a Delay until File Changed" action in Microsoft Flow. I agree. But those are the same questions that...
-
How to automatically enter MVP timesheets with Microsoft Flow
The Microsoft MVP Summit is next week. I'm here at 6AM slaving away cracking on this Swagger API file so that we can all have the awesomeness of...
-
Send mail as anyone - #MicrosoftGraph and #MicrosoftFlow (bonus: inline image attachments)
Sometimes while browsing MS Graph permissions, you come across something like this: This is an Application Permission, it says "Send mail as any user" The...
-
Serverless Parallelism in Microsoft Flow and SharePoint
This is a short post about running things in parallel. There are two angles to this: "Sometimes you fan-out to 50 parallels and want to run them as quickly...
-
Setting up MSGraph Webhook with HTTP Action in MicrosoftFlow
I've tweeted out several small tidbits of using Microsoft Flow's HTTP action to call the Microsoft Graph. Hundreds of Graph APIs, dozens of Graph webhooks,...
-
Betting on 2018 - level up our Serverless in Azure
A recent conversation got me thinking about making some predictions for 2018. This isn't so much a "ha look I'm right in 2019" post. This is more about...
-
Office 365 Groups Management As A Service: Episode II: Know your groups with Flow, MSGraph
This is the second post on building a group management tool with Flow and MSGraph. In this post we talk about how to get a list of all your groups and copy...
-
Office 365 Groups management as a service - Flow, Functions and MSGraph
Because Office 365 Groups is a key component of group membership in Office 365, there will always be an evolving story on how to manage it, extend it,...
-
Taking PDF snapshot of any SharePoint list item for approvals with Flow
This is a post about combining two steps I've blogged recently. Combined they form a technique that can be used with approval workflows to provide a point...
-
You must copy all your Flows to SharePoint - simple ideas are the most brilliant
Another crazy idea while travelling on the train home. This one is so simple, in hindsight, I reckon others will come up with this soon. So I'm writing this...
-
ForEach Property in #MicrosoftFlow JSON. With XPath? #microblog
I can't think of a way to do "ForEach Property Of JSON" in MicrosoftFlow or LogicApps - so I came up with this method that involves XPath. Take example this...
-
Microsoft Flow makes everything Awesome. Yes, including InfoPath #microblog
This is a write up of various ideas and thoughts that I've shared over Twitter separately, but needed to be linked together and the example steps needs to...
-
Sending Custom Actionable Messages via Flow
Actionable Messages is a way that we can send a small bit of JSON within an email message, it gets picked up by Outlook (Web, App, Desktop, Mobile) and...
-
I'm speaking about Serverless Flow and Azure Functions at Collab365 Free Online Conference
Have you heard about the virtual Collab365 Global Conference 2017 that’s streaming online November 1st – 2nd? Join me and 120 other speakers from around the...
-
From Office 365 to Azure to Minecraft, connected with Flow
"John, what's this headline." This is just a love serenade to Microsoft's many engineers and teams. Thank you, for making these products that makes these...
-
Flow Admin Center - Do a spring cleaning of your Flows
I spewed coffee all over my screen. Each user in Office 365 gets 2000 Flow runs pooled. This is my personal playground tenant, I've got 10 users licenses...
-
Serverless connect-the-dots: MP3 to WAV via ffmpeg.exe in AzureFunctions, for PowerApps and Flow
There's no good title to this post, there's just too many pieces we are connecting. So, a problem was in my todo list for a while - I'll try to describe the...
-
Generate Any PDF Documents from HTML with Flow
This is a crazy one, and if you have read ALL my Microsoft Flow blog posts, you'll be familiar with all these pieces. We are going to connect them a...
-
Two ways to convert SharePoint files to PDF via Flow
This blog post is divided into three sections: The easy, The Auth and The Complete parts. Microsoft Flow released a new power to Convert Files to PDF. This...
-
Gaps between PowerBI streaming tiles and SharePoint
So I spend an evening playing (I actually have a lot of fun exploring these things) and figuring out how the pieces of SharePoint, PowerBI and Flow are...
-
Auto-Classify Images in SharePoint Online library via Flow for Free
Microsoft Flow's most recent update added ability to query and update SharePoint File property . This is actually really timely, as I wanted to combine this...
-
Flow to MS-Todo, then all your tasks to Flow
I'm in a celebrating mood - Flow released Export and Import. This is a great day. https://flow.microsoft.com/en-us/blog/grow-up-to-logic-apps/ So I'm going...
-
Building Binary output service with Cognitive Services and Microsoft Flow
We covered how to do binary webservices with Microsoft Flow. A question then lingers in my mind. If you can push binary data into a Flow, and within the...
-
One Connection to Proxy Them All - Microsoft Flow with Azure Functions Proxies
Office 365 licensed PowerApps and Microsoft Flow lets you have 1 custom connection. I think that's cute. I also think that limitation is absurd, considering...
-
Building binary (non-JSON) webservices with Flow
This is a short(er) blog post, as I'm packing to get ready to sleep and then wake up early and fly to Brisbane for this weekend's Office 365 Saturday. We...
-
Nested Flow (Reusable-Function) cheatsheet for Microsof Flow
To build complex, but maintainable Flows, it is important to be familiar with this next step. The Flow blog calls this Nested Flows , so I will stick with...
-
JSON cheatsheet for Microsoft Flow
I have a big blog post in the works for a significant dive in Microsoft Flow functionality. But I realized that before we get there, we need to GET GOOD at...
-
Are you Cloud-Curious or Cloud-Serious? Azure Functions in DWCNZ 2017
I had a fantastic time at Digital Workplace Conference in NZ. Highlight Sessions Keynote by Sarah Bowden on Digital Transformation And Christian Buckley 's...
-
Taking a picture with PowerApps and sending to SharePoint with just Flow
Less than one day after I wrote about Taking a picture with PowerApps and sending to SharePoint with help of Azure Functions - I was looking at Flow to do...
-
Taking a picture with PowerApps and sending to SharePoint with help of Azure Functions
Sometimes, after having written a selfie app in Silverlight (SharePoint 2010) , JavaScript (SharePoint 2013), even an Add-in (SharePoint Online) , you want...