Tag: 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…
-
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…
-
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…
-
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…
-
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…