Shane Bartholomeusz

Geek and lover of all things tech related

Tag: Power Automate

Power Automate: Remove End of Line Characters

Problem

Parsing text can be somewhat tricky with Microsoft Power Automate or Azure Logic Apps. Recently I needed to strip out end-of-line characters (CR/LF) from a text string.

This task actually proved to be a bit more challenging than I had expected… However in this post I’ll share the solution that I found and ultimately ended up using.

Power Automate Logo
Continue reading

Solved: Set SharePoint Person Field to Null in Power Automate

Problem

Whilst trying to update a SharePoint Online List Item through Power Automate I noticed that I was unable to clear a Person field within a given List Item.

After some research it turns out that the Power Automate SharePoint Online connector currently does not support this operation when performing an ‘update’ operation.

In this post I’ll explain the solution that I found, and ultimately ended up using.

Power Automate Logo
Continue reading

How To: Create PDF Email With Power Automate

Overview

Do you have a need to generate emails with PDF attachments using the Power Automate (aka Microsoft Flow) workflow engine?

Guess what! You’re in luck because in this post I’ll show you how to do exactly that. I’ll show you how to generate a PDF document and send it via email.

Power Automate Logo
Continue reading

Solved: Excel 256 Row Limit in MS Power Automate

Problem

Whilst reading Excel files within Microsoft Power Automate (or Azure Logic Apps), you might notice that only the first 256 rows will be imported …

Hmmm …. What is Going On Here?

Microsoft Flow and Excel Logos
Continue reading

Handling Excel Dates in Microsoft Power Automate

Problem

Dealing with dates can be a real pain in the proverbial sometimes … and Microsoft Power Automate (aka Microsoft Flow) is no exception.

I recently had to bulk load some records from an Excel file into SharePoint Online using Microsoft Power Automate … you’d be forgiven to think that this would be a trivial task … WRONG!

Microsoft Flow and Excel Logos
Continue reading

© 2024 Shane Bartholomeusz

Theme by Anders NorenUp ↑