Johannes

It is quite common to get some JSON object data of an API that needs to be proceeded. But how do you handle this text wall of JSON in further actions? The trick is basically to use the Parse JSON action to make the values accessible. In this article, you will see step-by-step how to […]

The Power Automate Join function and action are the counterpart to the Power Automate split function. The Join function converts a text array to one string and separates the elements of the array by a delimiter. It is undoing the split function like split is undoing a join function. A very common use case is

I personally always change the language of Power Automate to English. Although I’m not a native speaker, it makes searching in case of any issues much easier. The setting for setting the language is a little hidden in the settings. Therefore, I wanted to help you find out, how to change the Power Automate language.

Sometimes you need to find out, if a certain date is within a certain month. To do this, you need to know the start and the end of the month to check if your date is between the start and the end. This article shows you, how to get the beginning and the end of

The Power Automate Coalesce function is a less known function in Power Automate, but it is worth knowing the function. It’s for example quite common to check if a value is null and in case it is null, you want to assign a certain value. So basically a fallback value or a default value. In

The Power Automate Length function helps you to check the length of a string or to check the length of an array. In this article, I’ll introduce you to the length function and will provide a step-by-step guide on how to use the function in a Microsoft flow. Power Automate Length Function The Power Automate

To trim spaces from string the Power Automate trim function is the right choice. The trim function removes all leading and trailing spaces from your text. It does not remove whitespace that is surrounded by characters. Power Automate Trim Function The Power Automate trim function returns a string, where leading and trailing whitespace is removed.

The Power Automate parseDateTime function lets you convert any string into date in ISO format. The benefit of converting the date string to ISO date is that you can use the date in other Power Automate date functions. So whenever you have an uncommon date format of some data source, just convert it to an

The Power Automate subtractFromTime function lets you travel to the past. Calculate the date of tomorrow, next week, next month or next year! Within your Power Automate subtractFromTime expressions, you simply provide what time interval you want to subtract and how often. There is also the Power Automate Subtract from time action, which is a