Category: Article
-
PowerPlatformTip 24 – ‘Merge arrays or tables’
Sometimes you may want to merge two arrays, including duplicates. Using the union function will merge the arrays, but it will only keep unique values. A simple trick to accomplish this is by concatenating the arrays and then getting the duplicates. split( concat( join(outputs(‘Compose_-_2_arrays’)?’array1′],’||’), ‘||’, join(outputs(‘Compose_-_2_arrays’)?[‘array2’],’||’)), ‘||’) If you want to see the overview above […]
-
‘Merge Images in PowerApps without Flow or Code Components’ from Martin Lehmann
I am so proud to present you an amazing component for PowerApps from my talented brother Martin! Gone are the days of struggling with third-party tools or PowerAutomate to add notes or drawings to existing images. Martin’s component makes it all so simple. You can easily overlay multiple images, make notes, and save the final […]
-
PowerPlatformTip 23 – ‘Filter Blank’
If you filter a gallery in #PowerApps e.g. by textinput, dropdown or combobox, and you want to show ALL elements when the selection is empty, then just use this formula after your filtering: ‘ || isblank(YOUR FILTERINPUT) ‘ If you want to see the overview above all #PowerPlatformTip – click here
-
PowerPlatformTip 22 – ‘Change Fill & Color’
There are 2 ways to change the colors of an app if you haven’t used a modified template: ReplaceAll Theme If you want to see the overview above all #PowerPlatformTip – click here
-
PowerPlatformTip 21 – ‘Use Triggeroutput’
Inform flow starter of success/provide info/handle errors. Use trigger condition for the trigger-user-mail: triggerOutputs()?[‘headers’]?[‘x-ms-user-email’] If u want some extra info, just use (like in the pic) triggerOutputs()?[‘headers’] If you want to see the overview above all #PowerPlatformTip – click here
-
PowerPlatformTip 20 – ‘Change Flow-Owner’
PowerAutomate allows you to change the owner of your flow directly, but this feature is only available within a solution and can be accessed through a slightly hidden menu. If you want to see the overview above all #PowerPlatformTip – click here
-
Unlock Limitless Possibilities with Power Automate & Excel Scripts (Office Scripts): The Ultimate Guide by Damien Bird & Daniel Laskewitz
You think PowerAutomate is powerful, you’re right. However, it becomes even more powerful when you combine it with Office Scripts. There you can combine 2 worlds and use actions that are not possible in PowerAutomate via Office Scripts from Excel. This opens up completely new possibilities. Here is a small overview of the functions.
-
PowerPlatformTip 19 – ‘Resize files’
If you want to make large images smaller, you can use the ‘Upload file from URL’ action and the thumbnail output from the image file stored on SharePoint. If you want to see the overview above all #PowerPlatformTip – click here
-
JSON Objects as a Switch – Power Automate & Expressions from Damien Bird
Very exciting overview of how to easily use an object instead of a switch for the output of data. Also the idea to make the content dynamic in this way gives new suggestions for other use cases. You can see this video here on my blog because I have rated this video with 5 stars […]
-
PowerPlatformTip 18 – ‘Download & Save Files’
Use ‘Upload file from URL’ for public downloads and ‘HTTP Request & Create File’ for password-protected ones. If you want to see the overview above all #PowerPlatformTip – click here
Marcel Lehmann 