Microsoft

Microsoft

212 bookmarks
Custom sorting
Disable App Insights Instrument key for Canvas Apps
Disable App Insights Instrument key for Canvas Apps
Application insights is a great product that lets you get some really cool details about how your apps and flows are working in your environments. We have App insights in Canvas Apps, Model-driven Apps and Power Automate flows in the Power Platform. Canvas app is a little different to the other two though, as Canvas Apps requires an Instrument Key to be inserted into the app to start the telemetry. With the Instrument key comes a problem though. App insights is designed to work across tenants, m
Toggling this to off will prevent Canvas Apps sending data to App Insights, either inside the tenant or outside the tenant.
Disable App Insights Instrument key for Canvas Apps
Power Apps With Function - Eric Gregorich
Power Apps With Function - Eric Gregorich
The Microsoft Power Apps With function is a powerful way to divide complex formulas into smaller pieces. It is useful when used within a ForAll, since we can’t …
Power Apps With Function - Eric Gregorich
Power Apps Host Property - Eric Gregorich
Power Apps Host Property - Eric Gregorich
The Power Apps Host property provides helpful information about the application, including the BrowserUserAgent, OSType, SessionID, and TenantID. In the formula …
Power Apps Host Property - Eric Gregorich
Converting from UTC in Power Apps - Eric Gregorich
Converting from UTC in Power Apps - Eric Gregorich
We can use the TimeZoneOffset function in Power Apps to adjust for the current time zone from UTC time. We would typically want to save our Dates as UTC time in …
Converting from UTC in Power Apps - Eric Gregorich
Format a number in Power Apps - Eric Gregorich
Format a number in Power Apps - Eric Gregorich
If we have a number value that we want to format to include a comma and decimal, we can use the following formula. Text( Value("2645.40"), …
Format a number in Power Apps - Eric Gregorich
Using Double Quotes in Power Apps - Eric Gregorich
Using Double Quotes in Power Apps - Eric Gregorich
When writing text in Microsoft Power Apps controls, you may need to add a double quote as part of your text. Power Apps uses the Power Fx language. It would be …
Using Double Quotes in Power Apps - Eric Gregorich
Power Apps Delegation - Eric Gregorich
Power Apps Delegation - Eric Gregorich
Power Apps can connect to many data sources and use the data in various ways. However, Power Apps will not be able to return all items at once. By default, …
Power Apps Delegation - Eric Gregorich
Copilot Cookbook
Copilot Cookbook
Looking for how to get started with Power Apps Copilot? Check out these samples, tips and tricks.
Copilot Cookbook
How to optimize passing a record to Patch
How to optimize passing a record to Patch
Patch is used to create new records or update existing records. Learn how to optimize patch when updating an existing record!
How to optimize passing a record to Patch
Duplicate Detection in Dynamics 365 using power apps
Duplicate Detection in Dynamics 365 using power apps
User Case: When setting up a contact in Dynamics 365, verify if a contact with the same email address already exists. If it does, prompt an error message indicating a duplicate email address. Step 1:  Navigate to make.powerapps.com, screen 1 àCreate a Blank Canvas App à Connect with Dynamics 365 Dat...
Duplicate Detection in Dynamics 365 using power apps
Power Apps text extraction functions made easy
Power Apps text extraction functions made easy
While working with strings in Power Apps, you may have come across the requirement to only display a specific part of the text value. These requirements can range from a certain sentence within a paragraph, a specific part of a QR code / unique id, the first occurrence of a certain text value and so...
Power Apps text extraction functions made easy
We Can Now Call SQL Stored Procedures from Power Apps!
We Can Now Call SQL Stored Procedures from Power Apps!
🎉 For years we have had to call SQL Server stored procedures by using a Power Automate flow. Not anymore! There is now a preview feature which we can turn on that allows us to do this. Finally❗ 🔍 In this video, we'll walk you through the step-by-step process of enabling and using this new feature to call SQL stored procedures directly from Power Apps. This is a game-changer for developers and business users alike, simplifying processes and enhancing efficiency in app development. 📺 Andrew's channel: https://www.youtube.com/@andrewhess123 🍬 Get my free video course, access to my free community https://www.skool.com/power-apps-community ⬅️ 📝Show Notes: https://powerplatformlinks.com/Power+Apps/Live+Streams/Stored+Procedures+From+Power+Apps 🔑 What You'll Learn: - How to enable the new feature in Power Apps for direct SQL stored procedure calls. - Detailed tutorial on setting up and calling SQL stored procedures from Power Apps. - Best practices for integrating SQL Server with Power Apps. Insights into how this feature can streamline your data processes and workflows. 🌟 Why This Matters: - Bypass the complexity of using Power Automate flows for simple SQL tasks. - Faster and more direct interaction with your SQL databases. - Unlock new capabilities and efficiencies in your Power Apps solutions. 💡 Who Should Watch: - Power Apps Developers - SQL Server Administrators - Business Analysts - IT Professionals - Anyone interested in app development and database management. #PowerApps #SQLServer #Microsoft #AppDevelopment #DatabaseManagement #TechTutorial #PowerAutomate #DataIntegration #ITProfessionals #BusinessSolutions
We Can Now Call SQL Stored Procedures from Power Apps!
Call SQL Server stored procedures directly in Power Fx (Preview)
Call SQL Server stored procedures directly in Power Fx (Preview)
Calling stored procedures directly in Power Fx. Speed up app development. Speeds up Power App performance.
This feature is an extension to the tabular model. We allow the ability to execute stored procedures, but we do not allow the ability to run arbitrary SQL. This helps provides an additional level of security.
You no longer need to call a Power Automate Flow to use a stored procedure. This feature is in preview and currently in all regions.  This makes development of Power Apps for SQL much easier. And your apps will be faster.  The ability to call stored procedures for the SQL connector directly is an extension to the existing tabular model and gives users access to tables, views, and stored procedures. This feature extends our ongoing support of SQL Server as a primary development target for Power Apps.
Call SQL Server stored procedures directly in Power Fx (Preview)
Better Performance with Less Effort! Use Power Apps Named Formulas
Better Performance with Less Effort! Use Power Apps Named Formulas
Whether you're caching data, creating collections, or managing user information, this tutorial provides valuable insights and tips to optimize your Power Apps experience. The video also highlights the limitations of Name Formulas, such as their immutability, and compares them with the flexibility of Variables and OnStart. By the end of this tutorial, you'll have a clearer understanding of when and how to use these features to build more efficient and responsive apps.
Better Performance with Less Effort! Use Power Apps Named Formulas
Power Apps Release Notes
Power Apps Release Notes
A list of all versions released for Power Apps, and the current version in each of the regions.
Power Apps Release Notes
Power Apps Dataverse Offline
Power Apps Dataverse Offline
Have you ever wanted to use your Power Apps without an internet connection? Well, it's now possible with Dataverse Offline! In this video, I'll show you how ...
Power Apps Dataverse Offline
Introducing the data exploration agent
Introducing the data exploration agent
Microsoft introduced the Data Exploration Agent, a tool that simplifies finding records and complex filters in model-driven apps.
Introducing the data exploration agent
Microsoft Power Platform Blog
Microsoft Power Platform Blog
Microsoft Power Platform helps your business build end-to-end solutions rapidly. Get the latest insights about Power Automate, Power Apps, and Power Pages here.
Microsoft Power Platform Blog
Power Platform Well-Architected - Power Platform
Power Platform Well-Architected - Power Platform
Microsoft Power Platform Well-Architected is a set of best practices, architecture guidance, and review tools to help you make informed decisions about the design, planning, and implementation of modern application workloads with Microsoft Power Platform.
Power Platform Well-Architected - Power Platform