FlowJoe.io

Power Fx Now Function

Learn about the Now function in Power Fx. It’s a function that returns the current date and time as a date/time value. It works with the local time of the current user however, while you can use it to perform calculations or comparisons with other date/time values you can use Now to get the current time in UTC by adding the TimeZoneOffset for the given time

Power Fx Today Function

Learn how to use the TODAY function on Power FX. If you’ve ever found yourself wrestling with manual date entries or wasting time trying to mess around with users location and their ‘today’s’ date, this tutorial is for you. I’ll walk you through the easy steps to use the function and show you how it requires updating alongside that it’s based on user location, saving you time and eliminating date-related headaches.

Power Fx Concatenate Function

Learn how to use the Concatenate function in Power Fx, the low-code programming language created by Microsoft. The Concatenate function allows you to join together multiple strings of text and strings in tables, but only in certain scenarios! You will see some examples of how to use the Concatenate function with individual strings, single-column tables, and mixed arguments.

Cancel Flow Runs in Bulk | Power Automate

Are you drowning in a sea of Power Automate flow runs that need to be canceled? This solution will save you a huge amount of time and frustration. Learn how to effortlessly cancel hundreds of Power Automate flow runs with just one straightforward flow.

Power Fx Contains Function (IN Operator)

In this video, I’m going to go into how to use the Contains function! Whenever we’re working with data, be it strings or a data source, we always want to check if something is contained IN it. This is the video shows you how to write your own contains statements using the IN operator in Power Fx!

Power Fx IF Function

Learn how to use the Power Fx If Function in Power Apps, Power Virtual Agents (PVA) and more! So what is it? It’s like a detective that checks conditions until it stumbles upon the truth, except it can also find the false outcomes too with multiple-layers of checking. This is the video for you if you’re looking to refresh your memory on the Power Fx If function or you’re a beginner to low code/no code and haven’t ever seen anything like this before!

Arrange Rows from Dataverse using any Column (even Lookups) in Power Automate

I’ll show you how to efficiently arrange rows in Dataverse using any column, including Lookup columns! Stop using the SortBy in the List Rows action and start using this, it offers you so much more in terms of sorting options, without all those pesky limitations!

Days Between Dates in Power Automate

Have you ever wanted to calculate the days or days and time between two dates on Power Automate? Then watch just how easy it is, once you understand the logic, with this video tutorial. I will walk you through step-by-step instructions explaining the complexity and the benefits and negatives of both methods.

Easily Avoid Apply to Each Loops in Power Automate

This video is to show you just how easy it is to avoid Apply to Each loops in Power Automate. You no longer have to cycle through time-consuming processes that you can simply avoid and speed up your flows. I’ll show you just how simple it is to get the first and/or subsequent rows without needing the apply to each action.

Add the Fantasy Premier League (FPL) 2023 – 2024 Season to your Microsoft Teams Chat

Fantasy Premier League (FPL) is starting again in less than a week! Now, picture having all your league updates delivered to your Microsoft Teams chat or channel every Monday morning. In the tutorial video, I’m super excited to show you how you can achieve this integration using the Microsoft Power Automate.