Power Automate: How to display the day of the week in your language?
by Having correct data to show to your users is super important, so today, let’s look at how to display the day of the week in …
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.
Power Automate: How to limit the Flow’s trigger?
Did you know that you can limit the Flow’s trigger based on any criteria? For example, let’s say that you’re catching a Microsoft Forms reply, …
Power Automate: When an Excel file is created update SharePoint
Today’s question comes from Echo and asks me the following: Problem Scenario: When file is created in SharePoint folder named “Attachment”, extract the file and …
Power Automate: Convert Excel Number to Date (to the second)
I already wrote about how to “Convert Excel Number to Date” in the past, but I got a good question. How about the minutes and …
Power Automate: How to send the Form’s answers by email?
I was contacted recently by Laura with the following question: I am using Forms to create an exam, and would like the responder’s answers to …
PowerShell: How to create or associate a HubSite
There are two ways to make a site a “HubSite”. The first is to go to the administration console in your tenant and create it. …
Power Automate: How to convert a string to formatted currency?
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 …
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, …