Tag: Marcel Lehmann
-
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 […]
-
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
-
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
-
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
-
PowerPlatformTip 17 – ‘Format data by example’
Use ‘Format data by example’ for more complex expression creation and get the correct expression in a few seconds. This is currently possible with ‘dates’, ‘strings’ and ‘numbers’. If you want to see the overview above all #PowerPlatformTip – click here
-
PowerPlatformTip 16 – ‘PowerApps – Collections Cookbook’
There are sometimes things that are not usable with simple functions. For this, you need workarounds. But then you usually either haven’t worked them out yet or don’t have them at hand. I like to use the PowerApps “Collections Cookbook” by Matthew Devaney ⇾ I love to use this function: ‘Add A Row Number Column […]
-
Discover the #PowerAddicts Secret Weapon: Some Tips and Tricks that Simplify Your Life! (in progress)
In December 2022, I embarked on a journey to share valuable tips and tricks as part of the #powerplatformtip series. My initial goal was to post 15 tips in 15 days, but as I delved deeper into the vast world of Power Platform, I discovered an abundance of useful information that I couldn’t wait to […]