Marcel Lehmann

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 […]
A PowerAddict PowerPlatform Gift 4 you

When I started my powerplatform journey, I was missing an environment where I could test and develop. In the beginning I used the default solution from my employer and since I was the only one in the whole organization using powerplatform in 2018/2019, this worked out fine. But one day I wanted to use […]
Return an array from a PowerAutomate to PowerApps (Split Method without Premium)

Basically, there are already some posts and videos on this topic. However, I would like to point out a great post incl. app for generating the function. (by Brian Dang) You can find the complete tutorial under this link:https://powerapps.microsoft.com/en-us/blog/return-an-array-from-a-sql-stored-procedure-to-powerapps-split-method/ Below you will find a shortened version.As already written, Brian Dang has not only provided a […]
The Big 5 (Variables / Parameters) in PowerApps

If you create a PowerApp and look around on the internet for solutions, you will come across the following functions from time to time. In the following, I will show you briefly what I use them for and why you should think about using them too. Set(varUser,user()) UpdateContext({locPopUp: true});UpdateContext({locPopUp: false}) With({locText: TextInput1.Text},If(IsBlank(locText),“noText,TextInput1.Text)) Navigate(Screen1,UnCover,{locVariableNextScreen: “Yes we […]
Power Apps change the app owner with PowerAutomate

In the post of 2020-12-09 I showed the video of Shane Young, where it is shown how to change the AppOwner using PowerShell. However, there is another, perhaps even easier way to change the AppOwner. Using PowerAutomate. Why should I change the owner of the app, which is the creator? One of the reasons that […]
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