Getting sick is never fun, especially with small kids at home. This is why it’s important that we take our meds quickly to avoid prolonging our recovery. In the past, I would stack up each on some common meds to be ready just in case I needed them. However, I would still find myself either … Continue reading Staying Healthy with Flow and PowerApps
Creating PDF documents with images using Flow
One of the nice document generation features of Flow is to create PDF documents from structured data, such as HTML. However, if you want to integrate images, you may not see the expected result. For demonstration purposes, suppose you want to have a PDF image that only includes. The flow may look something like the … Continue reading Creating PDF documents with images using Flow
Bypassing Connector Authentication in PowerApps
Have you ever had a PowerApp request your permission to access various services before it would load? If so, then that PowerApp is leveraging these connectors in some way. But what if you don't want each user to have to do that? What if some of the services require permissions that the end user doesn't … Continue reading Bypassing Connector Authentication in PowerApps
Avoiding never-ending Flow triggering
When Microsoft created the Do Until control action, fortunately they took care to avoid situations where loops would run forever by adding control limits that terminate the loop even if the logic condition is not met. By default, a Do Until loop will terminate after 60 iterations or 1 hour (PT1H in ISO8601 notation). Using … Continue reading Avoiding never-ending Flow triggering
Conditions, Loops, and Switches have moved
If you've been using Flow recently, you may have noticed that the location of the Condition, Do Until, Apply to each, Switches, and Scopes have moved. Previously they used to be available as part of the ...More button next to the + New step button or as part of the popup menu. No more. You will notice … Continue reading Conditions, Loops, and Switches have moved
Sending Custom Emails with Flow
About a year ago, I wrote an article on how you can use Flow to Mail Merge using Flow using a couple of SharePoint lists. This works great for sending the same email to all recipients or even structuring the email in different ways based on metadata captured in the Flow. However, I have faced … Continue reading Sending Custom Emails with Flow
Triggering a single Flow from multiple SharePoint Lists or Libraries
One of the many great uses for Flow is to perform certain actions when an item is added to a SharePoint List or Library. This is easy to achieve using the When a File is created or When an Item is created triggers. However, what if you want to run the same Flow for triggers … Continue reading Triggering a single Flow from multiple SharePoint Lists or Libraries
Workaround to update SharePoint document metadata custom columns
Microsoft has been making great strides in improving PowerApps functionality over the past year. In late 2017, the product team announced the ability to set values for Managed Metadata (aka Taxonomy) columns in PowerApps and Flow. This is great if you are using managed metadata fields in a SharePoint List, but does not work for … Continue reading Workaround to update SharePoint document metadata custom columns
How to easily store email attachments in SharePoint Online and extract data using Parserr
One of my past time hobbies is renovating my home. I find it quite relaxing to be able to step away from the screen and engage in an activity that lets me use my mind and hands in a creative way. This is all good, except when it comes time to submit all my receipts … Continue reading How to easily store email attachments in SharePoint Online and extract data using Parserr
Using Webhooks to keep up with your Flows
Workflow is something I use frequently in my work. Emails, on the other hand, I try to avoid as much as possible. So what's the best way to stay informed about the progress of your Flows? I was looking for some innovative ways to stay informed without having to check in on the Flow status … Continue reading Using Webhooks to keep up with your Flows