Marcel Lehmann

Discover the #PowerAddicts Secret Weapon: Some Tips and Tricks that Simplify Your Life! (in progress)

In December 2022, I started sharing valuable tips and tricks as part of the #PowerPlatformTip series. My original plan was to post 15 tips in 15 days, but I found so much useful information that I plan to regularly update the list for Power Platform enthusiasts. #PowerApps = #PowerAutomate = Topics PowerPlatformTip – ‘Community’ PowerPlatformTip…
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…
PowerAutomateTip – ‘Mastering PATCH’

We often use the PATCH function to modify individual records, but did you know it can PATCH an entire table at once? 🎯📊 Patching a table instead of individual rows offers several compelling benefits: 🔹 Efficiency: PATCH lets you update or insert multiple records simultaneously, turbocharging your app’s speed and responsiveness. 🚀💨 🔹 Data Integrity:…
PowerPlatformTip 56 – ‘Empowering Tools in CoE’

Let’s delve into the little tools that pack a punch in the Center of Excellence (CoE) 🚀 If you’ve ever used the Center of Excellence (CoE) Kit, you’ll know that it comes bundled with a multitude of nifty tools. A couple of my favorites are the ‘Set Flow Permissions’ and ‘Set Apps Permissions’ tools. 🛠️🔑…
PowerPlatformTip 55 – ‘Picking colors’

We all know how vital it is to maintain a consistent corporate design in our PowerApps. 📱 This especially rings true for colors! 🌈 You might wonder, how do you quickly get those colors from a webpage? The answer lies in Edge’s developer tools. Here’s a quick tip! 💡 1️⃣ Open up the webpage in…
PowerPlatformTip 54 – ‘Use Galleries’

🌟 In Power Apps, I’ve come to appreciate the power of using a Gallery instead of individual buttons when designing menus. Here’s why: 1️⃣ Consistency: A Gallery helps maintain a uniform look and feel across all menu items, making the UI more visually appealing and easier to navigate. 2️⃣ Flexibility: Galleries offer a more dynamic…
Power Automate Join or Merge Arrays with Speed from Damien Bird

I love this approach, which I use more and more often, especially after this video. Before that, I always used a filter array and first to get to this data. By changing the search text as a key, I can directly access the underlying data without any major detours. For example, if you have a…
PowerPlatformTip 53 – ‘Launch function’

Have you thought about the LaunchFunction in #PowerApps?🤔 Here are 3 reasons why you should definitely be using it: 1️⃣ Easy Access: Provide your users with instant access to essential websites, emails, or phone numbers directly from your app! 🌐 Example: Launch(“https://www.example.com“) 📧 Example: Launch(“mailto:info@example.com“) 📞 Example: Launch(“tel:+1234567890”) 2️⃣ Seamless Integration: Connect your PowerApps app…
PowerPlatformTip 52 – ‘DV4T: Budget-Friendly Choice’

🔥 When building Power Apps and Power Automate solutions, choosing the right data storage is crucial. If you’re looking to avoid premium licensing costs but still want a robust option, consider using Dataverse for Teams instead of SharePoint. Here’s why: 1️⃣ Integration: Dataverse for Teams is built directly into Microsoft Teams, offering seamless integration and…
PowerPlatformTip 51 – ‘Which Flow Calls Which Flow’

🚀 Discover the “Which Flow Calls Which Flow” utility by Doctor Flow (Serge Luca) and Isabelle Van Campenhoudt! 🌟 This amazing utility is designed to help you navigate the complex web of Microsoft Power Automate flows that call each other, especially in large applications like the BPM Toolkit on Github. With hundreds of flows interacting,…
PowerPlatformTip 50 – ‘Use TemplateApp’

🌟 Use the ultimate #PowerApps Material Design Template App! 📱 Elevate your app-building experience with this versatile template app, which offers: 16+ Material Design components Proper documentation 5000 SVGs for stunning, user-friendly UIs 🚀 Quickly customize app styles using the OnStart Property and enjoy the benefits of a consistent, accessible design. Get started by downloading…
PowerPlatformTip 49 – ‘Do-Until’

You don’t always need a true/false variable to check within a “Do Until” loop. Instead, directly evaluate the action that might fail! (Note: Some scenarios may still require a variable) Why do I love this? 🤔 It’s perfect for handling situations like locked or unavailable files. The loop keeps trying (based on your settings) until…