Marcel Lehmann

Create and Populate an Excel File Fast with Power Automate and Graph API from Damien Bird

So often I see someone want to enter hundreds or thousands of rows into an Excel with PowerAutomate. Most of the time I referred to the Office Scripts videos in connection with PowerAutomate by Damien Bird. Of course, this is a much better variant that everyone should know. Simply awesome. You can see this video…
PowerPlatformTip 43 – ‘With function’

🌍📏🚀 Let’s talk about the power of the with function in expressions! 🎉👩‍💻👨‍💻 🤔 Why should you use the with function? It helps you create cleaner, more readable code by allowing you to define multiple variables in a single block. 🙌💻📘 🧠 Let’s dive into an example to see how it works! 🌊📖 Imagine you…
PowerPlatformTip 42 – ‘Dataverse Views’

🔍 Use DataVerse Views for targeted filtering and better performance! ⚡️📈 In your #PowerApps Canvas App and #PowerAppsForTeams, combine Views with #Dataverse to filter data effectively & boost performance. 🚀 You could use “CurrentUser” or an existing “Date is older then X” for optimal filtering. 👤 🌟 Example: In an app, you want to display…
PowerPlatformTip 41 – ‘Standard tables in DataVerse’

If you use DataVerse (or DataVerse for Teams) 😎, it’s essential to utilize the standard tables for common business processes. This is a significant advantage of DataVerse, and you should employ these tables effectively. Consequently, other apps can interact seamlessly with this data too! Some important standard tables are: 📁 Account 🤝 Contact ✅ Task…
PowerPlatformTip 40 – ‘Delete Apps / Flows’

Are you struggling with a cluttered work environment filled with old test apps and flows? Fear not! In this blog post, we will share a practical, step-by-step guide on how to efficiently delete solutions and clean up your workspace. Step-by-Step Guide: First, ensure that there are no dependencies from other solutions, including connection references. Export…
PowerPlatformTip 39 – ‘FetchXML’

Have you heard of Fetchxml for Dataverse queries in Power Automate?🤖 Fetchxml is a 🚀powerful query language for complex Dataverse queries, and with the ModelDrivenApp or DataVerse Views, you can create it quickly!🛠️ One of the key advantages of Fetchxml is its ability to fetch data from related tables simultaneously. This means you can obtain…
PowerPlatformTip 38 – ‘Data Refresh’

📊🔄 The data in the PowerApp, e.g. in the gallery, updates automatically when changes are made, which are written directly from the PowerApp to the underlying data source. ⏰💻💪 🔍🔄⏰ Manually refreshing using the “Refresh” function can take forever and negatively impact performance, as all data is loaded into the app (not just the updated…
PowerPlatformTip 37 – ‘Table to JSON’

Are you a frequent user of Power Automate and often come across two-column tables, such as those with ‘Name’ and ‘Value’ columns? If you want a simple way to select individual entries within those tables, look no further! We’ve got a straightforward trick for you that’ll make your Power Automate experience even smoother. Follow these…
Upgrade Your Forms Experience: See Why This PowerApps and Power Automate Solution is the Ultimate MS Forms Alternative!

I’m delighted to present the MVP0 of our innovative project, which you can download here. (You can find the setup instructions for this there as well.) The While I’ve thoroughly tested it and resolved significant concerns, I kindly ask for your understanding if you encounter any bugs. Rest assured, ongoing improvements, adjustments, and expansions are…
PowerPlatformTip 36 – ‘Static Result’

👨‍💻💡 If you’re testing Power Automate Flows and want to avoid certain actions, check out the “Static Result” feature! This powerful tool ensures consistency in your workflow results by returning a static result without executing the action. 🚫⏰ 🙌 Whether you’re working with data that needs to remain unchanged or just want to save time…