Expressions Archives

Power Automate Functions – Slice (Cut up strings!)

This is a video to show you how to use the Slice function within Power Automate (and Logic Apps!). This function allows you to slice(cut) a string by providing a start number (index) and an end number (index) to return the contents of the string between the two numbers.

Power Automate Functions – Sort (Sort arrays by default or by column!)

This is a video to show you how to use the Sort function within Power Automate (and Logic Apps!). This function allows you to sort an array by default or by a specific column, I use Star Wars characters to explain the more complex column approach.

Power Automate – Increase the size of the Expression Editor

Are you tired of not being able to see the functions you’re writing? Are you getting sick of trying to work out where exactly you missed that comma that you can’t see? Then take a look at this video to see how you can get a BIGGER and BETTER expression box on Power Automate in under 4 minutes!

Power Automate Functions: ConvertFromUTC (No Need For Multiple Actions To Convert Date & Times)

This is a video to show you how to use the convertFromUtc function within Power Automate (and Logic Apps!). This function allows you to convert a UTC date and time, even the time and date right now, to your desired timezone.

Power Automate Functions: Rand (Randomly Generated Number)

This is a video to show you how to use the rand function within Power Automate (and Logic Apps!). This function allows you to randomly select and return a number between two sets of integers. We use an example by randomly generating a number between 0 and 9999.

Power Automate Functions: FormatDateTime (Change the Format of your Date and Time)

This is a video to show you how to use the formatDateTime function within Power Automate (and Logic Apps!). This function allows you to change the format of your date and time. You can even get the full day and month names.

Power Automate Functions: URIQuery (Get Query Parameters from a URL)

This is a video to show you how to use the uriQuery function within Power Automate (and Logic Apps!). This function allows you to get the query parameters after the host (and path parameters). You can then, for example, change URL host and path parameters easily between environments while keeping a query structure!

Power Automate Functions: URIHost (Maintain Host Websites and Change Paths)

This is a video to show you how to use the uriHost function within Power Automate (and Logic Apps!). This function allows you to get the host (such as www.flowjoe.io) from a link. You can then, for example, change URLs and maintain the host easily between environments while editing the paths!

Power Automate Functions: URIPath (Change URLs Between Environments)

This is a video to show you how to use the uriPath function within Power Automate (and Logic Apps!). This function allows you to get the path after the host. You can then, for example, change URL hosts easily between environments while keeping a path structure!

Power Automate Functions: Workflow (Current Flow Information)

This is a video to show you how to use the workflow function within Power Automate (and Logic Apps!). This function allows you to get information about the Flow that is currently running, including the display name, the environment and more! This video uses an example of emailing the Flow name and environment if an error occurred during the run of the Flow.