Search Content

Welcome to your one-stop Power Platform updates blog from PowerApps911! This update covers important changes over the month of April 2024 for Power Apps, Power Automate and Power BI. Power Apps New consent dialog . When accessing an app, users will have a dialog display that will specify the permissions granted them via the app, per the data source, and then will ask them to “Allow” the connections necessary to run the app. If there is any requirement to sign in for a data connection, the user will be able to do this in the dialog actions. The significant difference in what users saw before and now are the specific actions the app will do with that connection, such as “Read records” for a SharePoint list. This feature  rolled out the week of April 15th. Power Platform Advisor . In the Power Platform admin center, you’ll notice the Advisor in the navigation panel on the left side of your navigation menu. What is it? Advisor will scan your environments once a week and provide recommendations for enhancing security, reliability, and the overall health of your tenant. The functionality is somewhat like the App checker within Power Apps, but on a Tenant level. It will provide stats, insights, and recommendations. It can inform you of apps, for example, which do not have valid owners, apps that haven’t been used in the last 60 days, apps that are not in a solution, and apps that are shared with “Everyone” in your tenant, including guest users. Recommendations can be assigned or shared for action. Column names losing their “quotes”.  Previously, when you referred to a column in certain functions (AddColumns/DropColumns/RenameColumns/ShowColumns, Search, GroupBy, Ungroup, and DataSourceInfo) you had to wrap the column name in double quotes, like a text string. Microsoft is phasing in a Power Fx version that will not require the quotes anymore (just like you currently refer to column names in a formula). Microsoft assures us that this will not “break” old apps that still include the double quotes. This functionality is already included in the Power Fx 1.0  update that is forthcoming, but it is a “pre-release” update to the Power Fx version we currently use. Microsoft also plans to add this “no-quote” functionality to the SortByColumns and Validate functions in the months ahead. Enhanced theming for modern controls . First touted in February, custom theming is now available for modern controls. When you select your Themes  icon from the left side navigation rail, you now have the choice to “Add a theme” which allows you to define your own theme to match organizational branding. Theming changes will automatically apply to any modern controls that are part of your app. There are more modern controls customizations coming, but this is one that we can use right now. Import SharePoint lists into Dataverse during app creation . You can now use the Copilot app creation feature for SharePoint lists. Access this feature by selecting Start with data  from the home page in Power Apps. If you select SharePoint as the source, you can choose the site and the list to begin your app with. Power Apps presents your data in a Power Query preview experience where you can edit your SharePoint lists columns and data before importing it into your app (and creating the Dataverse table). Copilot helps with this by selecting proper columns from SharePoint and defining their data type for Dataverse. You can still edit the proposed columns before creating the app/Dataverse table, but this new feature quickens app/data creation from SharePoint data. Copilot answer  control in public preview . We have seen the Copilot component in preview for some time now, but Microsoft has just given us the opportunity to use the new Copilot answer  control. You can enable it in your app Settings > Upcoming features. You can insert it into your app and assign it to a data source. The default setting gives you a summary of your data by selecting the control. If you add a text input control, you can adjust the Question property to use the value of the text input as your question. You can also adjust the Title  property to prompt your users what types of questions to ask, like this example: Intelligent Recommendations for premium licensing . This AI feature is now available in public preview, and it provides recommendations on premium licensing for app users. You can find this feature in the Power Platform admin center   > Licenses and capacity  > Intelligent recommendations . This feature analyzes app usage within your organization every 30 days, and then it provides recommendations for users with Basic Power Apps licenses, active trials, or those who’ve already requested licensing. Think of it as an easy way to quickly see your app users and assign them the licensing/permissions (including security groups) they need to make the most out of the available apps. Recent Power Apps UI Updates 1- Automatically remove data not currently in use You may have noticed a new tool to remove unused data sources from your app. When you select the Data tab, there’s a small broom icon in the top right corner of the panel that quickly and painlessly removes any data sources from your app. See the image below for where to find that. 2 - New context menu When you click on controls in a canvas app, you may have noticed the purple menu of commands that appears just above the control. The idea is to simplify options to modify the control without searching for them. The most common options are available by simply selecting the option. For example, our image below shows a gallery with the context menu option of “Data” selected. Updated and new functions for Power Apps In case you missed it, Shane has done a new video of two new and two improved functions  in Power Apps. He covers the brand-new functions EncodeHTML and UniChar, as well as updates to the Table and JSON functions. New Functions : • EncodeHTML - encodes a string to make it safe for rendering in HTML. • UniChar - generates a Unicode character based on its code value. Updated Functions : • Merge Tables  - combines two or more tables into a single table, an improvement for the existing Table  function. • Flatten JSON  - converts nested JSON structures into a flat table format via the JSON  function formatting option: JSONFormat.FlattenValuesTables . Be sure and check out the video ! Power Automate Relative to Power Apps, Power Automate has been relatively quiet with new features this past month, however, there is a new SAP Connector in preview that works with OData, and Microsoft has included some good resources for helping you understand how Process Mining with Copilot can help your organization monitor, analyze and improve your processes. The SAP OData connector  is a “premium” connector and is still in development, but Microsoft is seeking your feedback to improve it. This new connector supports Basic, Anonymous, and API key authentication. It also can use the on-premises data gateway to connect to SAP. If you’ve not worked with the on-premises data gateway before, you can learn more about installing them here . The new actions available with this connector include create, read, update, delete and query functions for SAP OData. A blog post on Hyperautomation  appears this month in the Power Automate blog. A key part of this blog showcases how process mining is now enhanced by Copilot. If you’ve not used process mining previously, this enhancement really makes it easy to use. Process mining takes advantage of accessing data that’s already available, and Copilot helps you zero in on your most meaningful data and processes. The series of videos in the blog post help you see these companions in action, plus they introduce the Center of Excellence tools available for your organization. Power BI There were a bunch of new features for Power BI released in April including the new 100% Stacked Area Chart, more configuration options for Line Charts, and enhancements to Power BI mobile. See the whole list here . Keep reading for a few more highlights. You can now deliver Power BI paginated report subscriptions to a OneDrive or SharePoint location . Where previously, you were restricted by size limits for emails, this is no longer the case (however, there is a 250Mb limit on the size of the attachment). If your user has access to the OneDrive or SharePoint location, they can view the reports. Licensing requirements are still the same, but instead of receiving a large report in their inbox, report users can simply receive a link to one of these locations. If you’ve not used them before, subscriptions can be fully automated. Another new subscription feature added in April is the ability to add dynamic per recipient subscriptions for Power BI reports for up to 1000 recipients, up from the previous limit of 50. You can now add a Copilot pane to your Power BI workspace . This feature is currently in preview and is a “premium” option (available in a paid Fabric or Power BI Premium capacity with copilot enabled), but it is available to answer questions about your data and even create new report pages based on your prompts to copilot. Copilot is already available to help you write DAX queries, and there’s a great walk-through added this month showing how copilot enhances the DAX query view  in Power BI Desktop. If your organization has a continuously playing PowerPoint slide show that includes Power BI data, you can now refresh to the latest in-slide Power BI data without stopping the slide show to refresh data manually. Within the Power BI Add-in options, you can enable the Automatic refresh in slide show  option and even define the frequency of it. Additionally, the Power BI add-in can help you add a slide title to an empty slide. In Summary… Let’s recap some updates for the Power Platform in April 2024. Power Apps introduced a new consent dialog for app permissions and enhanced theming for modern controls. Plus, importing SharePoint lists into Dataverse just got easier with Copilot. Power Automate introduced a new SAP Connector in preview and we can now use Copilot in Process Mining to better understand our processes and where to improve. Power BI brought more cool features like the 100% Stacked Area Chart and enhanced subscription options. Now, you can even add a Copilot pane to your Power BI workspace for smarter data insights. Stay in the loop with PowerApps911 as we continue to provide information on these game-changing updates!

Often to get the most out of our business solutions we create with Power Apps we want to tell the user we need them to do something. The most common way is with an Outlook email or a Teams message. But did you know there is another way? You can send true Mobile style notifications for your Power Apps by creating a quick little flow. These notifications can be sent to your Mobile phone, your Tablet, or even your Smart Watch. Power Apps Send Notificationv2 To send these notifications you will use the action Power Apps Send Notificationv2 in a Power Automate Cloud flow. What is even cooler is not only can you send the notification, but you can control what it says, what app it opens, and you can even pass parameters so you could have it open to a specific item or screen through what is called Deep Linking . Practical Applications of Notifications The versatility of PowerApps notifications allows for a wide range of applications, from simple reminders to complete specific tasks, like filling out timesheets, to more targeted alerts directing users to particular work orders or tasks within the app. The goal is to streamline communications and ensure that critical information is delivered and acted upon promptly. Some Examples: Create a Power Automate cloud flow that runs every morning at 9 AM and checks for all past due approvals in your Expense Report app. For everyone it finds send a notification to the mobile devices of the approver. Add a button in your work order app for requesting a status update. Have the notification open the Power Apps app straight to the work order in question and display the message from the requestor. Every time a new document is uploaded to SharePoint notify the project team with a quick notification, keeping everyone up to date. To see a hands-on walk through, then check out my video on Setting up Power Apps notifications . Where you will see the App and Flow with all of the notifications working. If you would like help with adding this to your existing apps, we would be happy to help. 🤩 Just scroll down the page and fill out the Contact Us form. We can do everything from a 30-minute session to fix a minor issue to a 30-month project to build you the world's greatest Power Apps app.

Are you searching for real-world use cases of Microsoft 365 Copilot? Perhaps you're curious about how it can streamline your daily tasks. Here, I share the top five ways I personally use Microsoft 365 Copilot to enhance my productivity and efficiency across various Microsoft Office applications. Enhanced Communication with Copilot Chat One of my favorite features of Microsoft 365 Copilot is its intelligent chat functionality available through Chat . This feature acts as my personal assistant, helping me locate documents and emails quickly without manually searching through folders and files. Below you can see a real situation I encountered. I knew Daniel had shared something with me but I couldn't find it. I spent about 10 minutes on it before the 💡 went off and I asked Chat. Found it on the first try. Pretty cool! Recap Teams Meetings with Copilot Using Microsoft 365 Copilot within Microsoft Teams has transformed how I handle meeting recaps and follow-ups. The AI provides detailed recaps of meetings, identifying key points and assigning action items, ensuring that no critical information is missed. Here you can see a Teams recap of one of my Office Hour sessions that we run monthly for Training students. You can see who talked when, and a break down of what we discussed. I can even click into those notes and get more details and links to the portion of the meeting where talked about that. If you attend a lot of Teams meeting this is the best feature ever. Live Copilot Training If you are using Copilot with Bing, Microsoft 365 Copilot, or using it with Power Apps and Automate to enhance your apps we have a great Jumpstart training class. Copilot Jumpstart is a one-day LIVE class that takes you through all things Copilot with hands on labs, lecture and Q&A all taught by yours truly. Hope to see you there! Coaching by Copilot in Outlook Let's just be honest. I am known for writing short, to the point emails. Not mean, but often not empathetic enough for most people. Sorry. Coaching by Copilot is my life saver. I write my really short, to the point email and then I run the tool and bam, it smacks me in the face with everything I should do better. 🤩 It doesn't change any of my words, just nudges me in a nicer direction, so hopefully over time I just write better stuff. (doubtful 🤣) Simplifying Excel Tasks I am not as good at Excel as I should be. 🫤 While I can write simple formulas anything more is beyond me. And don't get me started with things like Pivot Charts. No. So for me, using Copilot for Excel to explain and write formulas for me is a big win. Below you will see a couple of screenshots of it in action. Very helpful. Automating Microsoft Forms Creation with Copilot Who doesn't struggle with a blank screen when trying to create a survey? Yes, you know some of the things you want to ask but not all of them. In steps Copilot to help. After teaching my live Training Class a couple of weeks ago I needed to generate a survey. So, I jumped to forms and used the below prompt as a jumping off spot. Yes, I fed it some of the questions, but it rounded out my survey to be more meaningful. There you have it. 5 ways I use Microsoft Copilot today to make my life easier. And isn't that the point. 🤩 Making my day better and it is worth its weight in gold. If you want to see these tips in action, check out the video My 5 favorite M365 Copilot features to see all of the fun in action. Or if you need help with rolling out AI in your company then reach out via the form below. We are already helping forward thinking companies train and plan for how AI will change their business.

In the world of Power Apps development, creating applications that are both efficient and user-friendly is paramount. A frequent requirement from users is the ability to save their progress in forms or multi-screen applications and return to it later. This is where the 'Save as Draft' functionality becomes essential. In this blog post, I will guide you through the process of implementing the 'Save as Draft' feature in your Power Apps, enhancing your app's usability and user satisfaction. Video: Save as Draft in Power Apps is available if you would like a walkthrough of all of the app functionality for saving as draft. The screenshots below are from the app built in the video. Why Implement 'Save as Draft'? Imagine your users are filling out an inspection form that spans multiple screens. Midway, they are called away for an urgent task. Without a 'Save as Draft' option, they would have to start over, leading to frustration and decreased productivity. Implementing 'Save as Draft' allows users to pause their work and resume later, exactly where they left off. The Basics: To begin, you need to understand the core concept behind 'Save as Draft.' It involves storing the user's progress in a table or collection, with a flag indicating the draft status. This allows the user to stop part way through the process and come back later to finish. When you implement it, you can make it as automatic or manual as you would like. Either just saving for them as they move from screen to screen or offering them a button to Save as Draft when they would like too manually do so. A lot of how you implement it depends on the size of your app and the use case. Step 1: Designing Your Inputs Design your inputs with user experience in mind. Use multiple screens to segment the data collection logically. Remember, each screen's progress needs to be savable as a draft. Step 2: Implementing 'Save as Draft' Here's where the magic happens: 1. Creating the Draft: Use the `Patch` function to create a new record in your data source, marking it as a draft. 2. Saving Progress: As users navigate through screens, use `Patch` to update the draft record with their inputs. 3. Resuming Work: Provide a gallery where they can see draft records, or some apps use OnStart to automatically return the user to where they left off. This requires you to load the draft record and set the defaults of your inputs to pull from that record. Step 4: User Interface Considerations Provide clear indicators and options for users to save their progress as a draft. A 'Save as Draft' button, visible on each screen, can make this functionality intuitive. Though if you want it seamless you may just make the next arrows do the saving for you. Best Practices: - Testing: Thoroughly test the 'Save as Draft' feature across different scenarios to ensure reliability. - Feedback: Implement user feedback mechanisms to refine the draft-saving experience. - Optimization: Regularly review and optimize the data structure and logic to handle drafts efficiently. Conclusion: Implementing a 'Save as Draft' feature in Power Apps can significantly enhance the user experience, making your app more robust and user-friendly. By following this guide, you're well on your way to mastering this essential functionality. Remember, the key to successful implementation is understanding your users' needs and testing thoroughly. If you need help implementing Save As Draft in your App then scroll down the page below and fill out the Contact form. We can help you with a 30-minute screenshare or with a 30-month project and everything between.

Diving into Power Apps development can be thrilling, yet the complexity of database concepts often acts as a stumbling block for many beginners. Understanding the intricacies of normalization, relationships, primary keys, and more is crucial for creating efficient, scalable, and robust applications. This blog post aims to demystify these database concepts, providing you with a solid foundation to enhance your Power Apps development journey. Let's break down these concepts into digestible pieces, ensuring you're well-equipped to structure your data optimally across various data sources like SharePoint, Excel, SQL, and Dataverse. Good database design isn't just about storing data; it's about doing so in a way that ensures your application runs smoothly, scales effortlessly, and remains robust over time. Good database design lies at the core of application performance, scalability, and long-term health. By correctly structuring your data, you not only enhance the user experience through faster load times and smoother interactions but also pave the way for future growth and adaptability of your app. This fundamental aspect of development safeguards your project against potential pitfalls, making it a critical area of focus for developers aiming for success in the Power Apps ecosystem. And if you want to see all of this in action then check out my YouTube video Intro to Database Concepts for Power Apps People where we continue the fun of breaking down these lessons. Understanding Tables, Rows, and Columns At the heart of any database are tables, rows, and columns. Tables store your data in a structured format, with rows representing individual records and columns depicting the attributes of those records. The Importance of Normalization in Power Apps Database Normalization is the process of organizing your data to reduce redundancy and improve data integrity. By dividing your data into related tables and establishing relationships between them, you enhance the database's efficiency and scalability. In the screenshot below, you see how our simple employees table becomes two tables through the process of normalization. Removing the redundancy. Grasping Primary Keys and Foreign Keys Primary keys are unique identifiers for each record in a table, crucial for ensuring that each record is unique. Foreign keys, on the other hand, are used to establish a link between two tables, acting as a bridge that connects related data across tables. In the above Example: ID is the primary key of the Employees Table DeptID is the primary key of the Department Table DepartmentID is the foreign key of the Employees Table Power Apps Relationships: One-to-Many and Many-to-One Understanding relationships between tables is key to structuring your data effectively. One-to-many relationships allow a single record in one table to be linked to multiple records in another, whereas many-to-one relationships are simply the inverse, with multiple records in one table linked to a single record in another. So in our example you would say Employees has a Many-to-One relationship to Departments. Departments has a One-to-Many relationship to Employees. It is the same relationship, just depending on which direction you are speaking from determines how you say it. In SharePoint and Dataverse when you create a Lookup column you are creating a Many-to-One relationship, you just didn't know it. That is because the data sources are doing the work for you. If you wanted to do it with SQL Server you would create your own. Many-to-Many relationships Imagine instead of choosing one Department you wanted the ability to choose multiple departments to associate with one employee? That is called a Many-to-Many relationship. In the example below we decided to add a new table called Charities. We also added a mapping table called Mapping Table. 🤣 If you look at the Mapping Table you will see that Nicola is associated with both Frog Friends and Pet People. You figure this out by looking at the Mapping table. EID is the primary key in the Employees Table. CID is the primary for the Charities Table. Connect the dots and you see Nicola is associated with 2 Charities, Chewy with 0, and Shane with 1, Super Snakes. In a Many-to-Many relationship instead of adding a foreign key column you will use a third table, called a mapping table. This table defines all of the data connections. SharePoint and Dataverse support both of these columns also. Join the Learning Community at Power Platform University If you're looking to dive deeper into these concepts and master Power Platform, consider joining our comprehensive six-month program at Power Platform University. With live sessions, hands-on projects, and personal mentorship, you'll be well on your way to becoming a PowerApps pro. More information on Power Platform University . Conclusion Database management is a fundamental skill for any PowerApps developer. By understanding and applying these database concepts, you can create more efficient, scalable, and maintainable apps. If you need help with Database design in your Power Apps just scroll down the page and fill out our Contact form. We would be happy to help!

Let's face it, users can use all of the help they can get responding to customers. While they may have the best of intentions, some days, they just aren't on their A game with those customer service or work order replies. Well, never fear AI doesn't have bad days and can come to the rescue with putting a bit of that much needed polish on response. In this blog post we look at two ways to enhance your existing Power Apps with AI to fix those user responses. AI prompts allow you to use your awesome prompting skills to craft the perfect response and the necessary inputs to get a response that not only follows your business pattern but also sounds like the user. While Draft with Copilot isn't as customizable but still a great option if you users are writing well and just need a bit of polish. If you want a deeper look at adding either of these to your app and see them in action, check out my latest video  Elevating PowerApps with AI: A Guide to Enhanced User Inputs Why Integrate AI into PowerApps? The integration of AI into PowerApps brings forth a myriad of benefits. It transforms mundane and often error-prone user inputs into polished, professional communications. This enhancement is crucial, especially in scenarios where user inputs directly influence customer perceptions and business outcomes. By leveraging AI, PowerApps can offer: - Improved Clarity and Professionalism : AI can refine user inputs, ensuring messages are clear, concise, and free of common errors. - Enhanced User Experience : Personalized and well-structured responses make interactions more enjoyable and engaging for users. - Increased Efficiency : Automated AI enhancements save time for both app users and recipients by reducing the need for manual corrections and follow-ups. Two Pathways to AI-Enhanced PowerApps 1. AI Prompts via Flow or Direct The first method employs AI Builder, a feature of AI Builder, and Power Automate (Flow) to enhance user inputs. This approach not only corrects grammar and syntax but also enables you to provide context, structure, and even personality into the responses tailored to your business needs. Technology : This method utilizes AI Builder's capabilities within Power Automate to create custom AI prompts. These prompts can analyze user inputs and generate improved outputs based on predefined criteria. Use Case : Consider a work order management app where technicians input updates on their tasks. Using AI prompts, a simple "Job done" can be expanded into a detailed update, informing the customer about the task completion, potential next steps, and a personalized thank-you note. Below is an example AI Prompt. As you can see, I used my prompting skills combined with inputs from the App to get a great response. I even allowed the tech to pass his or hers own personality in to really refine the outcome to sound like the tech. 2. Power Apps Draft with Copilot Feature For those seeking a more straightforward implementation, Power Apps recently introduced a built-in Copilot feature named, Draft with Copilot. This option provides AI-assisted text generation with minimal setup, making it an accessible tool for app developers at all levels. Technology : The Copilot feature is built directly into Power Apps, requiring no external flows or tools. It leverages AI to suggest enhancements to user inputs based on context and the initial input provided. Use Case : In a customer feedback app, users often leave comments or suggestions. The Copilot feature can help refine these inputs, encouraging more structured and constructive feedback, which can then be automatically formatted into a report for the management team. Below is an example of the Draft with Copilot interface in Power Apps. As you can see you can drive tone and length but you aren't able to add additional inputs other than the text to update. Implementing AI in Your PowerApps Whether you choose the flexibility and depth of AI prompts via Flow or the simplicity of the Co-Pilot feature, integrating AI into your PowerApps can significantly enhance user interactions. Here are a few tips for getting started: - Identify Key Areas for Improvement : Look for parts of your app where user input directly affects business outcomes or customer satisfaction. - Start Small : Implement AI enhancements in a single feature or app section to gauge user response and effectiveness. - Gather Feedback : Encourage users to provide feedback on the AI-enhanced inputs to further refine and improve the experience. Conclusion The integration of AI into PowerApps opens up new possibilities for app development, offering a pathway to more refined, personalized, and efficient user interactions. By choosing the method that best suits your needs, you can elevate your apps from simple tools to sophisticated solutions that anticipate and exceed user expectations. Dive into the world of AI-enhanced PowerApps and witness the transformation in your apps' effectiveness and user satisfaction. If you need help with adding AI to your Apps and Flows or are looking to roll out Copilot and don't know where to start then we are here to help. Scroll down the page and fill out the Contact Us form and we will get you connected with one of our AI experts.

Hello friends, here’s your one-stop summary of the new features for the Microsoft Power Platform introduced in February 2024. Power Apps Copilot is getting a new job description as a grammar editor for canvas apps. Draft with Copilot is a new premium feature releasing in Preview for the US region very soon. It enables an app user to use Copilot to assist them in text input. This is (initially) only available in English, but Microsoft touts that it will be especially useful for app users not working with an app in their native language. You can see a sneak peek here . Model-driven apps are also getting some Copilot love with form fill assistance. Since model-driven apps data entry is predominantly via forms, this seems to be a nice feature to speed data entry. It will also be an English language option with the “New Look” app enabled. See it in action here . Microsoft is including multi-language support from the “Create an app” Copilot feature available from the Power Apps homepage. Supported languages now include Dutch, French, German, Italian, Japanese, Portuguese, and Spanish. To get the full functionality, you still need to operate in a premium environment that includes Dataverse. You can learn about this here . In the Power Platform admin center, there’s a new preview feature to block unmanaged customizations  in Microsoft Dataverse environments. This setting keeps anyone from creating or importing any unmanaged solutions or customizations to the environment, helping organizations to enforce application lifecycle management. Did you know that you can now call SQL Server stored procedures in Power Fx? Just introduced on “Leap Day”, this preview feature eliminates the requirement to use Power Automate to assist you. This one is quite loved by our team SQL experts since it simplifies the process of bringing data into the app. You will have to enable this via the Settings > Upcoming features > Preview. You can learn more about this feature in the Connect to SQL Server from Power Apps documentation . Power Automate AI Builder models continue to improve to get you the ability to quickly customize a pre-configured model that extracts standard invoice fields. The invoice model gives you a starting point for that to speed you down the path of training the model to pull typical values from invoices, and then allowing you to customize it by continuing to train to recognize other fields in the invoice. By invoking the AI Builder steps into your flow you can pull invoice data from documents and use it wherever you need it. Power Automate for desktop got a new update in February that now allows Picture-in-Picture run mode. What this means is that a user can run desktop flows in a separate virtual window on their desktop without disrupting other work the user is trying to do. Additionally, if you’re into string interpolation, you can now input Power Fx expressions into text. Both features are preview features available now. Power BI There are a LOT of features tweaked in Power BI over the month of February. You can input DAX calculations directly on a visual. “Visual Calculations” can greatly simplify how you modify your visual to show the data you want, including some simplified automated calculations, without writing complex DAX logic. Another add-on is called “Dynamic Subscriptions”, allowing you to create customized emails to deliver dynamic Power BI reports with filtered data to designated people. The technique to do this resembles Dataflows and setting it up includes a similar interface. You can put the process on a schedule as well. The subscription process can deliver a customized email with the filtered report image and even a PDF attachment. The Power BI Desktop Home screen has changed to resemble something like you might encounter when you open OneDrive. You’ll see a quick link at the top to create a “New” report, a Recommended section that updates automatically, and then a list of recent reports. Copilot is getting more work in Power BI by offering help in writing descriptions for measures (in your data model view) based on text or code in the measure. Descriptions will appear when you hover over a measure in your report view, providing better feedback on the measure without having to open it up for a look. You can get a good preview this and all the new PBI features here . Copilot Studio If you missed the news, Power Virtual Agents has migrated over to Copilot Studio. The only significant update for February is that you can now publish a Copilot to directly to a SharePoint site. You can learn how to do shenanigans like that here . The link also introduces you to Copilot Studio, if you are not familiar with the transformation begun last November. In Summary I hope this summary whets your appetite to try out what's new the Microsoft Power Platform. Collectively, we're excited with some of these deployments that we've been waiting quite a while for and know that they're going to have an immediate impact on app development. Stay tuned to PowerApps911.com for more!

Are you ready to take your Power Apps and Power Automate projects to the next level? APIs (Application Programming Interfaces) are your secret weapon, seamlessly integrating with various services like SharePoint, Outlook, Dataverse, and more. But if you're new to the world of APIs, fear not! This beginner's guide is designed to demystify APIs and show you how to harness their power in your low-code applications. What is an API? At its core, an API is a structured way to communicate with a system. It's the bridge that allows your Power Apps and Power Automate flows to talk to external services, fetching data, sending commands, and performing a myriad of tasks that extend the functionality of your applications. Think of it as a common language that your app uses to interact with the world outside its boundaries. Why Should You Care About APIs? APIs are everywhere, integrated into almost every digital service we use. By understanding and utilizing APIs, you can significantly enhance the capabilities of your Power Apps and Power Automate projects. From automating routine tasks to pulling in real-time data from external sources, APIs open up a world of possibilities for your applications. Even if you look just a little under the covers in your Apps and flows today you will see they are using APIs to talk to your data sources like SharePoint. Look at the screenshot below where we use Monitor to look at the raw information that comes back when you Filter a Gallery. Thankfully Power Apps handles making this data useable but learning what it is doing opens a lot of doors to you doing bigger and badder things. If you have no idea what that says, then this video and blog post are for you. There is a video that has a much deeper look at working with APIs and Json here: Intro to APIs for Power Apps and Power Automate Getting Started with APIs The easiest ways to use APIs with Power Apps and Power Automate is to use the HTTP action in a Power Automate Cloud flow. Here you will fill in the blanks from the API Documentation. In the video I show using this documentation JSONPlaceholder - Guide ( typicode.com ) but you can use any API you want. After following the info in their Guide I get the following. Method Methods with APIs are how you communicate with APIs. The documentation will tell you which to use but understanding at a high level what each does makes the documentation easier to follow. The Methods are as follows: Get : Retrieves data from a server at the specified resource. Post : Sends data to a server to create a new resource. Put : Updates a specific resource completely with the data provided. Patch : Applies partial modifications to a resource. Delete : Removes the specified resource from the server. Headers and Queries The Headers and Queries are dependent on the API. Often here you will add things like the format you want the request to be sent in like JSON or XML. And sometimes you will need to include things like authentication. Once again, the documentation will guide you. It isn't unusual not to have headers or queries. Not sure I have ever had queries. Body When you are sending info to the API this is the meat of your request. It is often blank on Get requests but most of the other requests this is where you are saying do this thing. From the example above we are doing a Post to create a new item and the Body contains the details that we want for our new item written in JSON format. Working with JSON in APIs JSON (JavaScript Object Notation) is the lingua franca of APIs. It's a lightweight data-interchange format that's easy for humans to read and write and easy for machines to parse and generate. Understanding JSON is crucial for working with APIs, as it's the format you'll use to send requests and receive responses. JSON at its simplest is just text in curly brackets. Something like this { "title": "foo", "body": "bar", "userId": 1 } The {} signify that you are creating a record (item). In that record you then have a column called title and the value of that is foo. The body of your record is bar and the userID is set to 1. In the video we spend more time on this but if you ignore all of the {} and "" and : and just read it as fancy text then the info isn't that scary. When working with APIs you will use JSON both in the request, our POST and in the response you get back from the API. Above is the response we got back from performing the API POST in flow. At first glance it looks like chaos but is it really? If I asked you what was the Location can you figure it out? Take a second and just read the text.... isn't the location just https://jsonplaceholder.typicode.com/posts/101 See, JSON doesn't have to be that scary. Practical Examples Let's dive into some practical examples to see APIs in action within Power Apps and Power Automate: Fetching Data from SharePoint : Imagine you want to display a list of items from SharePoint in your Power App. By making an API request to SharePoint, you can retrieve the data and dynamically populate a gallery in your app. Sending Data to Outlook : Need to automate email notifications? Use an API to send data from your Power App to Outlook, creating and sending emails automatically based on your app's logic. Turning off my lights : What? Yeah, my light switch is an IOT device meaning it has an API. So I can write a flow to turn it on and off. This video shows it: Power Automate HTTP action, Rest API, and IOT Tips for Success Start Simple : Begin with straightforward API requests to get comfortable with the process. Use Documentation : Leverage the extensive documentation available for most APIs to understand the required request formats and available endpoints. Practice with Public APIs : Experiment with public APIs (like JSON Placeholder) to practice making requests and handling responses without worrying about authentication. Conclusion APIs are a powerful tool in the Power Apps and Power Automate ecosystem, offering endless possibilities for enhancing your applications. By understanding the basics of API communication and practicing with real-world examples, you'll be well on your way to unlocking the full potential of your low-code projects. Remember, the world of APIs is vast and varied, so never stop exploring and learning. Happy coding! If you need help working with APIs and JSON in Power Apps and Power Automate then scroll down the page and fill out our Contact Us form. We are happy to help. 😎

Welcome to a comprehensive guide on how to filter Power Apps galleries using various techniques. Whether you're working with Dataverse, SQL, SharePoint, Excel, or other data sources, understanding how to effectively filter data is crucial for creating dynamic and user-friendly applications. In this post, we'll explore different methods to filter your Power Apps gallery, complete with code snippets for each technique. Let's dive in! Before we start, if you are looking for a guided approach to Filtering Galleries then you can also check out my video Do you know 10 ways you can filter a Power Apps gallery? This 10-minute video shows all of the techniques shown below in action. I grabbed a screenshot from the video of each so you can see the examples different ways. Filter Power Apps Gallery By Date and Date Range Filtering by date allows users to view records from specific time periods. Here's how you can filter a gallery to show items based on a date or a date range: // Filter by a specific date Filter(YourDataSource, ProjectDate = Today()) // Filter by a date range Filter(YourDataSource, ProjectDate >= DateValue("12/25/2024) && ProjectDate <= DateValue("12/31/2024")) Video screenshot: Filter Power Apps Gallery By User Personalize your app by showing data relevant to the currently logged-in user. This method is particularly useful for task or project management apps: // Filter by the current user's email Filter(YourDataSource, ProjectManagerEmail = User().Email) In the video we show other things including using the Entra ID. Video screenshot: Filter Power Apps Gallery By Text Input and StartsWith Allow users to search your gallery using text input. This can be refined using the StartsWith  function for more dynamic searches: // Filter by text input Filter(YourDataSource, TextColumn = TextInput1.Text) // Use StartsWith for partial matches Filter(YourDataSource, StartsWith(TextColumn, TextInput1.Text)) Video screenshot: Filter Power Apps Gallery By Dropdown and Radio Controls Dropdowns and radio buttons are great for filtering galleries based on predefined criteria. They work exactly the same so you can replace Dropdown1 below with the name of your Radio control and get the same result: // Filter by dropdown Filter(YourDataSource, StatusColumn = Dropdown1.Selected.Value) // Filter by radio button Filter(YourDataSource, CategoryColumn = Radio1.Selected.Value) Video screenshot: Filter Power Apps Gallery By Combobox Combo boxes allow for multi-selection, enabling users to filter based on multiple criteria simultaneously. Remember this can cause delegation challenges depending on your data source: // Filter by combobox selections Filter(YourDataSource, StatusColumn in ComboBox1.SelectedItems.Value) Filter Power Apps Gallery By Another Gallery Use one gallery to filter another, creating a linked interactive experience: // Filter based on selection in another gallery Filter(YourDataSource, CategoryColumn = Gallery1.Selected.Category) Filter Power Apps Gallery By Button Buttons can dynamically set variables that can then be used to filter based on user interaction, offering a flexible way to manipulate gallery data: // Set a variable on button press Button.OnSelect = Set(varFilterValue, "SpecificValue") // Use the variable to filter Filter(YourDataSource, ColumnName = varFilterValue) Button: Gallery: Filter Power Apps Gallery By Checkbox Checkboxes offer a straightforward way to toggle filters for boolean (true/false) values. There are other chaotic filtering ideas with Checkboxes but they all end poorly. Also, remember Dataverse doesn't have a Boolean column, so this example is more SharePoint or SQL specific: // Filter based on a checkbox Filter(YourDataSource, BooleanColumn = Checkbox1.Value) Video screenshot from a different data souce: Understanding Data Sources: Dataverse, SQL, SharePoint, Excel, and More When filtering data in Power Apps, it's important to consider the data source you're working with. Each data source, be it Dataverse, SQL, SharePoint, or Excel, has its nuances. For instance, Dataverse provides a robust platform with complex data types and relationships, making it ideal for enterprise-level applications. SQL databases offer powerful querying capabilities for apps requiring complex data operations. SharePoint is perfect for integrating with Microsoft 365 services, while Excel suits simpler applications with static data. Remember, the syntax for filtering can vary slightly depending on the data source, especially when dealing with specific data types or when addressing delegation limits. Always test your filters to ensure they work as expected across different data sources. By mastering these filtering techniques, you can significantly enhance the user experience and functionality of your Power Apps. If you need help with your Power Apps, we are here for you. We offer everything from quick free help, to mentoring, all the way to full scale Power Platform projects. Just scroll down below and let us know how we can help you!

Microsoft has a plan to continue to evolve the Power Platform in 2024 and has provided a 219-page PDF  that is way too long to read in 5-10 minutes. But don’t worry, we have the highlights right here! This summary includes key features and enhancements planned for release from April 2024 to September 2024. Microsoft tells us that these features are subject to change and may not be available in all regions or environments (hence “plan”). Microsoft will update the document currently stored on their dedicated web page . If you’re unfamiliar with the Power Platform, each section below includes a summary of what each particular part is about. Then we’ll summarize some of the key features and enhancements. That’s enough intro, let’s get into it! Power Apps Power Apps is the part of Power Platform that enables users to create custom applications for web and mobile devices, using a low-code approach and a rich set of controls and components. Power Apps also includes Microsoft Dataverse, a robust and secure data platform that stores and manages data for Power Apps and other Power Platform components. Some of the key features and enhancements planned for Power Apps in 2024 wave 1 are: Copilot for Power Apps makers and users : Copilot is a new feature that uses artificial intelligence (AI) and natural language to aid users in building and using Power Apps. We gained a little experience with Copilot in 2023, but we’ll now see higher integration within the editor. Makers will be able use Copilot to create and modify apps, work with data, and enhance overall functionality. There will be more of the natural language prompting to explore data and navigate apps. Building modern apps : Power Apps is rolling out a range of updates that will modernize app creation and make it easier to produce apps with features that app users expect. The updates for developers include more (and refined) modern controls, responsive templates, and offline apps. Makers can expect a refreshed and modernized interface, simpler sharing options, and better collaboration tools (where more than one person can work on an app at a time). Enable enterprise scale : Microsoft promises enhanced features for makers and administrators, helping the implementation of solutions at an enterprise (company or organization-wide) level. Power Apps Studio will see upgrades to the monitoring and code management tools, to better assist makers working on larger and complex apps. The goal is to provide makers and administrators with improved visibility and control of their solutions and environment routing (or moving solutions between environments). Power Automate Power Automate is the part of Power Platform that enables users to create automated workflows that connect various apps and services, without writing code. Power Automate also includes Power Automate Desktop, a tool that allows users to automate tasks on their Windows desktops, and Copilot for Process Mining, a feature that analyzes business processes to supply insights and recommendations. Some of the key features and enhancements planned for Power Automate in 2024 wave 1 are: Get quick insights and recommendations in Copilot for Process Mining : As we mentioned in the intro above, Copilot for Process Mining is a feature that analyzes business processes and provides insights and recommendations to improve them. Using natural language a user can ask Copilot questions, such as how to perfect a process, find bottlenecks, or even find performance enhancements. Copilot will generate reports and dashboards to help visualize processes and share findings with others. Use generative AI testing for canvas apps : Testing canvas apps, especially when deploying large-scale production applications, has been challenging in the past. We never truly know when an application is deployed for broader consumption that the application will work at scale. This new feature will automate the creation of automated tests for canvas apps. Copilot will be able to help users as they’re building their canvas apps to build appropriate test cases and scripts that will go into app testing. Users will be able to create and automate their tests, starting with canvas applications and eventually expanding to include copilot, Test Studio, and Test Engine. Power BI Power BI is the part of the Power Platform that enables users to create and share interactive reports and dashboards that supply insights from data. Power BI also includes Power BI Desktop, a tool that allows users to connect to various data sources, transform and model data, and create visualizations. Some of the key features and enhancements planned for Power BI in 2024 wave 1 are: Power BI Premium Gen3 : Power BI Premium Gen3 is the next generation of Power BI Premium, which offers improved performance, scalability, and flexibility for enterprise-scale deployments. Power BI Premium Gen3 introduces new capabilities such as “autoscale”, which automatically adjusts the capacity based on the workload demand, and user-based pricing, which allows users to buy Premium licenses per user instead of per capacity. So, your organization will be able to tailor a package that fits you best. Power BI Copilot : Power BI Copilot is a new feature that uses AI and natural language to help in creating and exploring Power BI reports and dashboards. Users can ask questions such as how to create a chart, filter data, or calculate a measure. Copilot will also provide suggestions and insights to help users discover new patterns and trends in their data. Other significant changes In addition to the features and enhancements mentioned above, there are a few other significant changes planned for Power Platform 2024 wave 1 that we’ll mention. Power Virtual Agents and Power Pages are both elements of the Microsoft Power Platform. So here is a quick summary of updates for them: Power Virtual Agents : Power Virtual Agents is the part of Power Platform that enables users to create chatbots that can interact with customers and employees, without writing code. Power Virtual Agents is introducing new features such as adaptive cards, which allow users to create interactive cards that can be displayed in chat windows, and copilot, which allows users to use natural language to create and modify chatbots. Power Pages : Power Pages is the newest part of the Power Platform. It helps users to create web pages that can be embedded into Power Apps or other websites, using a low-code approach and pre-made components. Power Pages can be used to create landing pages, blogs, wikis, and other types of customer-facing web content, and it can use data. A few of the enhancements for Power Pages include enhanced administrative and governance capabilities and an enhanced design studio, as well as the ability to use advanced customizations and configurations (pro-dev capabilities through Power Platform CLI (command line interface)). Hopefully this post gives you a taste for what’s coming up from April 2024 to September 2024 for the Microsoft Power Platform. Microsoft is doubling down on Copilot to aid makers and administrators both. We’ll be following along closely and trying out the new features to let you know how to best take advantage of the new tools. So, stay tuned to PowerApps911.com !

Incident reporting is a critical aspect across all industries. Whether it's safety concerns, environmental issues, property damage, compliance breaches, data security, or product defects, efficiently managing these reports is crucial. If you are still using paper or a Word document to collect this information, then you are likely missing aspects of data integrity, speed of dissemination (notifications), and the ability to view historical trends.   Why Choose the Power Platform? This is where Microsoft Power Platform steps in as a game-changing solution. While there are numerous specialized tools in the market, the Power Platform stands out due to its customizability and integration capabilities. Here’s why it's an ideal choice for your incident reporting needs: Customization at Your Fingertips: Unlike off-the-shelf solutions, the Power Platform allows you to tailor your incident reporting app to meet your unique business requirements. This means you can design workflows and forms that align perfectly with your operational needs. Seamless Integration: The Power Platform excels in connectivity. Using its robust connectors, your incident reporting app can seamlessly integrate with other applications within your organization. This not only increases visibility but also reduces data duplication, ensuring that all relevant stakeholders have the latest information at their fingertips. Cross-Platform Accessibility: With the Power Platform, you can create a solution that is accessible on both mobile and desktop platforms. This ensures that incident reporting can be done on the go, which is crucial for capturing the data immediately! Enhanced Data Analytics: With Power BI you can go beyond just collecting data. You can analyze trends to make data-driven decisions. Transitioning to the Microsoft Power Platform for your incident reporting needs is not just about digitalization; it's about transforming the way you manage critical information. It empowers your organization with efficiency, accuracy, and agility, turning incident reporting into a strategic asset rather than an administrative burden.   Here's an example our team has developed: a simple and effective workplace injury reporting app. This app is designed to make the reporting of workplace injuries as straightforward as possible. When an injury occurs, the app allows for quick documentation and notification to the relevant parties. The user-friendly interface ensures that essential information is captured efficiently and accurately. All data is stored in a centralized location, making it easy to access and analyze. This can help in identifying trends, such as common times for injuries or if certain departments are experiencing more incidents. The goal is to provide a practical tool that aids in both incident reporting and workplace safety analysis. If you are ready to move forward with an Incident Report app, or any app within the Power Platform, PowerApps911 is here to help. Want to build your own app but don’t know where to begin? Start with our training . Don’t know which tool is the best to use? Watch this video  from our own Shane Young. Want us to mentor you through the build or do the build for you? Fill out the contact form below!

Welcome to another exciting exploration in the world of Power Apps! Today, we're diving into five "fancy" functions that, while not traditionally fancy, are absolute game-changers for any Power Apps developer. These functions are not just about adding flair to your apps; they're about making your development process more efficient, your apps more powerful, and your user experience smoother. If you wish to see these 5 Power Apps functions in action, then check out this video 5 Fancy Functions in Power Apps from my Power Apps YouTube channel. I show each function and how to use it. Coalesce Function: The First Non-Blank Value Finder The Coalesce function is a hidden gem that returns the first non-blank value in a series of parameters. It's incredibly useful when dealing with optional inputs. Imagine a scenario where you have multiple text inputs, and you want to display the first one that the user fills out. Coalesce simplifies this by checking each input in order and returning the first non-empty one. This function shines in data lookups too, especially when you're checking for existing records before creating new ones. It eliminates redundant code, making your app more efficient. Coalesce(TextInput1.Text, TextInput2.Text, "NA") As you get more comfortable with it, you can make your Patch formulas a lot less complicated. Sequence Function: Generating Number Sequences Made Easy The Sequence function is all about generating a table of sequential numbers. It's perfect for scenarios where you need to create dynamic lists or slots based on user input. For instance, if you need to generate reservation slots or count items based on a number provided by the user, Sequence is your go-to function. It offers flexibility in starting numbers and increments, allowing you to tailor the sequence to your specific needs. The formula below makes a table of 6 numbers. Starting with 0 and increasing by 10 each time. Sequence(6, 0, 10) Below you can see Coalesce in action. Once you get comfortable with it there is a lot of dynamic tables you can build. AddColumns Function: Reshaping Your Data on the Fly AddColumns is part of the data shaping toolkit in Power Apps. It allows you to add new columns to an existing table. This function is particularly useful when you need to calculate or derive new data points from existing data. For example, if you have a table of dates and need to add a column that shows the day of the week for each date, AddColumns makes this task a breeze. It's about enhancing your data without altering the original source. This example takes Today's date returns it plus the next 9 days dynamically by taking Sequences output of 0 to 9 and then adding a column for Date which is Today's date + the Value from sequence. AddColumns(Sequence(10,0),"Date", Today() + Value) Now you have a handy table of today plus the next 9 days. Note for this example it is January 30th. Sequence and Coalesce combine for the win! Notify Function: User Notifications Simplified The Notify function is straightforward yet powerful. It's used to display brief messages to the user, like success or error notifications. The beauty of Notify lies in its simplicity and the ability to customize the duration and type of notification. It's an excellent alternative to more complex modal popups for simple messages. While I often use it for debugging and troubleshooting, it's equally effective for user interactions. Here you are setting Notify to say "Hi Mom!". The message will be red because you choose Error as the type, others are available. And finally 5000 represents the numbers of milliseconds before it disappears. Notify("Hi Mom!",NotificationType.Error,5000) With Function: Reducing Redundancy in Your Code Last but certainly not least, the With function holds a special place in my Power Apps toolkit. It's all about reducing redundancies and making your code cleaner. With allows you to perform calculations or operations on a data set and use the result throughout a block of code. It's particularly useful in scenarios where you need to perform the same calculation multiple times. By using With, you can do the calculation once and reference the result, making your code more readable and efficient. This example from the video shows 2 With functions nested together to calculate the days and weeks between two dates. With({xTotalDays: DateDiff(dpStart.SelectedDate, dpEnd.SelectedDate),xMessage: "Hi"}, With({xLeftOverDays: Mod(xTotalDays, 7)}, (xTotalDays - xLeftOverDays)/7 & " weeks and " & xLeftOverDays & " days between the two dates")) This example is a great illustration of the power without being too complicated. In conclusion, these five functions – Coalesce, Sequence, AddColumns, Notify, and With – are not just tools; they're your allies in creating more efficient, powerful, and user-friendly Power Apps. Whether you're streamlining data lookups, generating dynamic lists, reshaping data, notifying users, or simplifying your code, these functions have got you covered. Embrace them in your next Power Apps project and watch the magic happen! If you need help with your Power Apps projects we are here to help From 30 minute screenshares to fix that one nagging issue to full scale project implementation we have you covered. Just scroll down the page and fill out the Contact Us form and we will be happy to help. Thanks -Shane