Power Apps: 1900 is not a leap year
by As you know, PowerFx draws parallels from Microsoft Excel. In fact, Microsoft told us that they want full parity between Power Apps and Excel’s function …
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: Convert Date to Excel Number
As you may know, Excel stores the numbers internally in a number format and not a date. This topic was covered a while ago when …
Power Automate: How to embed an image into an email
I see this question a lot in the forums. How to embed an image into an email? The connector enables us to send attachments, but …
Power Apps: Assign values to variables
A few weeks ago, I got an amazing question from Jason about variables and buttons, specifically how to achieve what we get from other programming languages …
Power Automate: Add planner checklist items dynamically
While answering questions in the Power Automate forum, I’ve seen one that pops up once in a while. How to add checklist items dynamically to …
SharePoint: Publishing news in modern SharePoint sites from an RSS feed
SharePoint made great progress with the news feature, especially now in modern SharePoint sites. They look good both on the web and mobile, and it’s …
Microsoft Planner: No Templates? No worries.
If you use Microsoft Planner a lot, you come to a point where you create many repeated tasks each time you create a new Plan. …
Power Automate: Parse a CSV – New Template
My first article about how to parse a CSV file was on August 3rd, 2020, and this is by far the one that gets the …
Power Automate: What is a JSON Schema?
Although Power Automate is a low code application, there are some concepts that we should be aware of when building our Flows. This can be …
Power Automate: Save all attachments when an email arrives
One of the best ways to deal with email is not to deal with it at all. With Power Automate, you can check each email …