How to remove duplicates efficiently?
by So you have a list of strings or integers and find duplicate items. It’s a common problem. You need to remove the duplicates to be …
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 download a file from a safe link?
Microsoft introduced a while ago the concept of safe links. Microsoft has something called “Microsoft Defender for Office 365” that protects your company from malicious …
How to fix when images don’t show in a Gallery View in SharePoint?
I like SharePoint‘s Gallery View a lot. With it, we can display the data nicely to the user, and it’s a great way to see …
Power Automate: xpath function
The “xpath function” is not the first function that comes to mind in Power Automate, and it’s not the most obvious; I’ll give you that, …
Power Automate: How to round a number?
It’s quite common to need to round a number, but when you go into Power Automate’s expression tab and search for something related to “round” …
Power Automate: How to add all email attachments to Planner?
Recently Nick commented on my “How to send an email and create a task in Microsoft Planner?” article, mentioning that I don’t have an article …
Power Automate: What is a Key Column in Excel?
If you’ve used the Office 365 connector for Power Automate, you’ve noticed that many of the actions require you to provide a “Key Column” to …
How to solve the JSON Invalid type error in Power Automate?
I get this question quite frequently in multiple variations, but the problem is always the same. You create a schema using a JSON that you …
How to get all document libraries or lists using Power Automate?
So let’s say you want to do an inventory of a SharePoint site and get the list of all document libraries. We can use an …
How to copy the same file into multiple folders using Power Automate?
I ran into this issue in the Power Automate Community and found it interesting. It has all the things that automation can do for us. …