Power Automate

Expand your knowledge of Microsoft Power Automate, a service that lets you create automated workflows.

Power Automate: Retrieve more than 100 items from SharePoint 026

To retrieve more than 100 items from a SharePoint list, you can activate pagination. Click on the 3 dots on...

Number of months between two date fields | PowerAutomate 032

Unfortunately, there is no Datediff function in PowerAutomate, so here is our solution to calculate the number of months between...

Retrieve previous versions of SharePoint list items in Flow 027

There is no action in Flow yet to access the version history of SharePoint list items (or documents). So how...

Approval workflow in Microsoft Teams with Adaptive Cards 025

If you want to trigger an approval in teams via PowerAutomate, these tips will help you to customize the Adaptive...

Power Automate – Save sent emails (attachment) in OneDrive or SharePoint 023

There is no direct option in Power Automate to process sent emails via flow. With a detour via the selection...

Formatting numbers in a flow (Power Automate) 024

For a long time it was only possible to round values in a flow with an auxiliary column, but now,...

Difference between two date fields in Flow (Power Automate) 028

Here is an example for the number of days between two dates: div(sub(ticks('2019-05-13'),ticks('2019-05-04')),864000000000)

Change a date as text (STRING) to a date format (DATE) with Power Automate 028

If you receive a date as a STRING in a flow, the conversion process is not easy, but can be...

Create document set with Flow 023

To create a document folder automatically with a flow, proceed as follows: Send HTTP request to SharePoint Website address: Select...

Power Automate: Write an array into a multi-selection field 031

Our use case was two multi-selection fields from SharePoint, which were to be written to a new multi-selection field. When...

PowerAutomate – Flow condition – If a field is empty or not empty (null) 028

Unfortunately, this option is often missing in Power Automate when selecting the respective condition. To create a condition query depending...

What can Power Automate Desktop do? A brief overview. 032

Here we gather our experiences with the new workflow tool from Microsoft.

SharePoint ODATA Filter 023

OData query operators supported by the SharePoint REST service Supported Not supported Numerical comparisons Lt Le Gt Ge Eq Ne...

Dein Experte

Andreas Olbricht