Power Automate: How to convert a string to formatted currency?
by Not all numbers (or strings that are numbers) are the same so we should not treat them as such. Some could be a simple number …
Tag: Problem Solved
Problem Solved is one of my favorite sections, or at least the articles I have the most fun writing. Here is where I solve a problem that bugged me for a while and shared the solution to you, so you don’t have to spend time looking for it. All posts will be within the theme of the website, so don’t expect programming solutions, for example.
I call it “Problem Solved” since it’s my way of saying “Fixed, let’s move ahead.”
These posts will be somewhat sporadic since there’s not always things to publish. Depending on the subject I’ll either post them on the Tuesday and Friday schedule if they fit the theme or, I’ll give you an extra article(s) that week for your enjoyment. There’s no defined schedule or plans to write new posts, so I’ll write as soon as I have current information to share.
SharePoint: How to create hyperlink column with more than 255 characters?
The short answer is you can’t, but that wouldn’t make a very useful article, wouldn’t it? First, let’s identify the issue. You have a SharePoint …
PowerShell: How to replace accents in strings?
Working with text is quite hard, especially when you need “clean” text to create a resource or something that doesn’t support special characters. Let’s think, for …
Excel: Import data from any website
Have you found a site with a lot of data and want to parse it in Excel? Simple enough, we can copy and paste it, …
Power Automate: How to generate an URL to an email?
I got this question on my “Microsoft Planner: Send an email and create task” from Kristen McCarty (thanks for the excellent question) regarding how to …
Power Automate: Long-running Flows
Today I want to answer the common question about long-running Flows. “How can I configure Flow to run for more than 30 days”. But as …
Microsoft / Office 365 / Power Automate / Power Automate Action Reference / Power Platform / Reference / SharePoint
Power Automate: SharePoint – Add attachment action
Many people don’t know this, but you can add attachments to a SharePoint list row. It’s convenient and much better than having a folder with …
Power Automate: How to get the response date of any action?
Most actions don’t provide a response date for a good reason. We don’t need it. They run as fast as possible, and the difference between …
SharePoint: Check if a Document Library Exists
Document Libraries are an integral part of SharePoint sites and are super helpful, so today, we will explore how to check if a document library …
Power Automate: When Excel can make things easier
The idea for this article came from a comment posted on the website where we were trying to figure out the solution to filter an …