Marcel Lehmann

PowerPlatformTip 48 – ‘Sharing of Flows & Power Apps’

🚀 Overview of The Sharing of Flows & Power Apps 🌐 1️⃣ Export Flows on make.powerautomate.com, but the import on this site is legacy for import. But you can use the import via make.powerapps.com. 2️⃣ Use a Flow to automate sharing (check out tip #PowerPlatformTip 8)🔄 3️⃣ Pack everything into a solution (Power Apps, Power…
Power Apps Dynamic Form Schema | Add Controls on the fly from Reza Dorrani

Mega exciting approach, how you can simply do without the forms control and instead build your own design form (dynamically) You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video was automatically posted using PowerAutomate.
PowerPlatformTip 47 – ‘Batch-Method within SharePoint’

🚀If you’re working with SharePoint items in Power Automate, definitely consider using the batch method to create up to 1,000 items at once! 📈 💡 Main benefits: ✅ Significantly enhanced performance ✅ Reduced Power Automate API action usage by a thousand times 🎯 Paul Murana has written an excellent blog post that explains this method…
Dynamic 10K+ Data Sync to SharePoint: Virtual Tables & Dataflow from Multiple Sources

A common need is to provide data from multiple sources for applications like PowerApps, Power Virtual Agents, or Power BI solutions, ensuring effective data use. In this post, we explore how to seamlessly synchronize data from various systems using Virtual Tables and Dataflow to SharePoint. Notably, these files can be stored in a folder, which…
PowerPlatformTip 46 – ‘PowerToys’

🚀 Want to boost your productivity while working with Power Platform? 🌐 Check out Microsoft PowerToys, for me an unofficial member of the Power Platform family! 💥 This desktop app is packed with tools that will help you work smarter, not harder: 🔗 Download and install PowerToys here: https://github.com/microsoft/PowerToys My Top 5 PowerToys tools for…
Sync Microsoft 365 Admin Centre Service Health and Message Centre via Power Automate! from Damien Bird

Sure, the topic is important for all admins and key users. But what’s really exciting is how Damien manipulates and queries the data here -> and then merges and syncronizes it. You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This…
PowerPlatformTip 45 – ‘Use Scopes’

🚀📈 Improve your #PowerAutomate skills with Scopes! Here are 7 reasons why you should be using them: 1️⃣ Group related actions to keep your flow organized and easy to read. 2️⃣ Prevent errors from affecting the entire flow by isolating them within a Scope. 3️⃣ Simplify error handling and troubleshoot problems more efficiently. 4️⃣ Save…
Create Dynamic Word Docs with Power Automate & Microsoft Forms from Damien Bird

Just stunning. Great tip how to dynamically fill variables from a text – WITHOUT Apply to each or other. But a clear and clean flow with filter array / select. You can see this video here on my blog because I have rated this video with 5 stars in my Youtube video library. This video…
[PowerApps] Finally connect to the REAL ChatGPT and EVEN GPT4 😮 from Robin Rosengrün

In addition to creating a custom connector, by the way, you can also take the logic and the structure of the API to OpenAi (ChatGPT) with you. It is also exciting that I have to return to an array to OpenAI, because then I can give any conversations from before – just like you know…
PowerPlatformTip 44 – ‘Calculate the distance’

Here’s a cool tip to calculate the distance between two places without relying on premium services like Google or Bing maps. We’ll be using the Haversine formula for this, and the best part is, you can find a ready-to-use code snippet right here: https://github.com/MarceLehmann/CodeSnippets/blob/main/CalculateDistance.json 🌐 📍 To make it work for you, all you have…