Power Automate: Write an array into a multi-selection field
Our use case was two multi-selection fields from SharePoint, which were to be written to a new multi-selection field. When adding the values to the array variable, it is important…
Power Automate
What can Power Automate Desktop do? A brief overview.
Here we gather our experiences with the new workflow tool from Microsoft.
Power Automate: Retrieve more than 100 items from SharePoint
To retrieve more than 100 items from a SharePoint list, you can activate pagination. Click on the 3 dots on the right in the “Retrieve elements” element and select Settings…
Number of months between two date fields | PowerAutomate
Unfortunately, there is no Datediff function in PowerAutomate, so here is our solution to calculate the number of months between two dates. Our data: Date 1 = Current date, here…
Retrieve previous versions of SharePoint list items in Flow
There is no action in Flow yet to access the version history of SharePoint list items (or documents). So how can we get to older versions of a list item…
Power Automate – Save sent emails (attachment) in OneDrive or SharePoint
There is no direct option in Power Automate to process sent emails via flow. With a detour via the selection of the “Sent folder” in the Exchange mailbox, however, you…
Formatting numbers in a flow (Power Automate)
For a long time it was only possible to round values in a flow with an auxiliary column, but now, tada, it works directly in a flow! The integrated “Format…
Difference between two date fields in Flow (Power Automate)
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
If you receive a date as a STRING in a flow, the conversion process is not easy, but can be solved as follows: Create STRING variable (here as an example…
Create document set with Flow
To create a document folder automatically with a flow, proceed as follows: Send HTTP request to SharePoint Website address: Select from the list Method: POST URI:”/_vti_bin/listdata.svc/”+“Library name“ Header: Accept=”application/json;odata=verbose” Header:…
PowerAutomate – Flow condition – If a field is empty or not empty (null)
Unfortunately, this option is often missing in Power Automate when selecting the respective condition. To create a condition query depending on an empty field, proceed as follows:
Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!