Tag: PowerApps
-
[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…
-
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 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…
-
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 34 – ‘PowerApps V2’
Use the “PowerApps V2” Trigger 👉 First, you can customize the connection used and run the flow with a service user, for example, making it more secure and manageable. 👉 Second, you can directly define the input type for the trigger, giving you even greater control over how your flow works. 👉 Third, you can…
-
PowerPlatformTip 32 – ‘GroupBy’
Do you create dropdown or combobox lists that depend on other lists, such as categories, subcategories, and additional subcategories? If so, check out this tip to keep your performance optimal! Instead of loading everything multiple times, load all the data only once and always reference it using GroupBy. This way, you’ll avoid using DISTINCT and…
Marcel Lehmann 