I had the pleasure of presenting at the UK’s and possibly Europe’s largest free business applications community event – Scottish Summit 2020! The event had over 1000 attended descend on Glasgow for a fantastic day of networking and learning.
I chose to present Power Automate and how to adopt it within your organization quickly.
As part of 2019 release wave 2,Microsoft has recently announced that Change Set feature has been added to the Power Automate designer so that users can replace classic Common Data Service workflows that previously needed atomic transactions.
Trigger Conditions in Power Automate were a great addition released in mid-2019. They are designed to stop your Flow (Automation) from running if the conditions are not met. But what is the easiest way to ensure that my condition is going work? Read to find out...
Since the Power Automate flow uses AI Builder's text recognition Predict action, it requires to be in a solution (since it's part of the CDS - Current environment connector). From that point on, the Canvas app that I use to capture the image to be analyzed cannot run that flow, because it's a known limitation that Canvas app triggered flows are not available in solutions.
That is why I've used a CDS entity and related trigger as a workaround to process the image via a flow and then display the result back in the app.
A little while ago I wrote an article about To-Do, it’s had a massive response so I thought I'd follow up and delve a little deeper into the current Power Automate (formerly Flow) relationship that is there today and where I see this going.
In this blog, I will show how to create a flow that can be used as a service. We will create a customer request management service using Flow, SharePoint and a Web app. A user can create a new request through the page by entering the details and upload an attachment. A unique code is generated once the request is processed and the customer can track their request by entering this code and their email address.
In this article, I will show you how to setup the flow configuration to delete files older than ‘X’ days from OneDrive. This looks like an easy task by simply listing the entire folder and set a condition to check the modified date and delete the older files. The catch here is, the List Folder action on OneDrive gets you 20 items only. There is no way (pagination settings are not working either) to get more than 20 items.
In this article, I will highlight 10 interesting flow hacks/ workarounds that might help you in building your flows. This article is inspired by a couple of questions that I have been repetitively seeing on the community forums. Being documented at one place, it could be a good cheat sheet for all levels of users (beginners/ mid/ pros) while building flows.
The Common Data Model has a lot of benefits for Small Business Owners. However Small Business Owners do not have the time to "reinvent the wheel" when it comes to establishing apps, data relationships and automations which Microsoft Common Data Service would require. As a result Small Business Owners are forced to choose from marketplace of already established Apps. Luckily Microsoft Flow can provide the benefits of both worlds but enabling a Common Data Model approach to existing Apps in the marketplace.
In this post, I will show you how to detect duplicate records/ items in Dynamics 365 CRM/ CDS/ SharePoint, delete the record/ item and send a list of deleted records/ items as an email attachment. We will look at finding duplicate entries based on specific fields/ columns (specific values on these fields/ columns), deleting those and sending an email with the list of deleted records/ items.
Are you just getting into using Microsoft Flow and need a thorough overview of the product and what it offers? Are you feeling behind with all of the many updates Microsoft Flow has undergone? Are you struggling to come up with use cases to get your organization excited about business process automation? If so, you need to check out this webinar recording featuring Flow experts Jon Levesque, Melissa Hubbard, and Hunter Willis.
Check out the recording and Q&A from the webinar "The Four M's of Microsoft Flow" with speakers Audrie Gordon and Melissa Hubbard! Watch demos and learn best practices that will ensure successful, efficient, and performant Flows in your organization.
Because of my background as System Engineer and now Azure administrator. I have created an example thats combining Microsoft Flow with Azure Log Analytics and Powerapps. Creating an alert dashboard in Power App, has never been easier.
Did you ever create an awesome flow only to realize you could not get it to stop triggering? If so, don't worry it wasn't just you. This is called the infinite loop and it is a pretty common mistake flow makers deal with when building flows. Read more about the infinite loop and how to avoid it here!
We've been helping lots of folk recently to build Flow's which extract SharePoint list item attachments and perform some form of processing, typically to convert to a single PDF document and share with a third party, or add to a records repository.
The following tutorial is built around a very simple scenario but should serve as a good guide for:
How to extract ‘X’ number of SharePoint list item attachments and process
How to use Flow variables to iteratively build a JSON array
How to merge 'X' number of documents (any format) into a single PDF document
How to dynamically create a HTML fragment and insert into a PDF document
One Size Fits All? Not when it comes to IT.We’ve worked with a select group of Microsoft MVPs to put together a new blog series covering the biggest industry talking points and tribulations. The below article comes straight from MVP and Triad Senior Consultant, Pieter Veenstra. Before you get started, we’d like to extend our gratitude to you, our tech community members, for your ongoing insights. Keep feeding back to our MVPs and keep checking back on our Tech Implementer homepage to stay up to date with the latest news and developments. Over to Pieter.
Once in a while, there are situations where the OOTB features of Dynamics 365's first-party apps simply run out. While Field Service can be a powerful tool to create additional value in a service/maintenance business, it also has its limits. I have previously written about Time Entries in Field Service by using Flow and PSA so let's continue on that path and see how we can enable field technicians to sell more by leveraging the power of the Power Platform.
I am a Microsoft Business Applications MVP and a Senior Manager at EY.
I am a technology enthusiast and problem solver. I work/speak/blog/Vlog on Microsoft technology, including Office 365, Power Apps, Power Automate, SharePoint, and Teams Etc. I am helping global clients on Power Platform adoption and empowering them with Power Platform possibilities, capabilities, and easiness.
I am a leader of the Houston Power Platform User Group and Power Automate community superuser.
I love traveling , exploring new places, and meeting people from different cultures.
Founder of SKILLFUL SARDINE, a company focused on productivity and the Power Platform. Working on some cool stuff that you're going to enjoy. I also write at https://www.manueltgomes.com, so if you want some Power Automate, SharePoint or Power Apps content I'm your guy 🙂
I am the Owner/Principal Architect at Don't Pa..Panic Consulting. I've been working in the information technology industry for over 30 years, and have played key roles in several enterprise SharePoint architectural design review, Intranet deployment, application development, and migration projects. I've been a Microsoft Most Valuable Professional (MVP) 12 consecutive years and am also a Microsoft Certified SharePoint Masters (MCSM) since 2013.