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 …
How To Convert An Object To An Array With Power Automate Read More »
You have data within an Excel sheet that needs to be stored into a SharePoint list. You might ask yourself if it is possible to easily import the Excel Sheet to a SharePoint list. Yes, it is possible, but it is not that obvious to do. My first approach was to look within SharePoint for …
How To Create A SharePoint List From Excel Easily Read More »
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 …
Power Automate Join Function And Action Explained Read More »
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. …
How To Change The Power Automate Language Step By Step Read More »
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 …
How To Get Start And End Of The Month In Power Automate Read More »
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 …
Power Automate Coalesce Function Explained Read More »
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 …
Power Automate Length Function Explained Read More »
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. …
Power Automate Trim Function Explained Read More »
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 …
Power Automate ParseDateTime Function Explained Read More »
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 …
Power Automate SubtractFromTime Function & Action Explained Read More »
