Posts

Showing posts from February, 2024

Create dependent drop-down lists in a canvas app

Image
When you create dependent (or cascading) drop-down lists, users select an option in a list to filter options in another list. Many organizations create dependent lists to help users fill out forms more efficiently. For example, users might select a country or region to filter a list of cities, or users might select a category to show only the codes in that category. As a best practice, create a data source for the values in the "parent" and "child" lists (for example, countries/regions and cities) that's separate from the data source that users update by using the app. If you take this approach, you can use the same parent and child data in more than one app, and you can update that data without republishing the app or apps that use them. You can accomplish the same outcome by using a collection or static data, but it isn't recommended for enterprise scenarios. For the scenario in this topic, store employees submit issues to an  Incidents  list through a for...

Applying Row Number to Gallery Items

Image
Creating a row number sequence within a Power Apps gallery is a powerful technique. It ensures consistent numbering even when items are dynamically added or removed. Let’s dive into the details: 1.  Set Up Your Data Source: Before creating the gallery, ensure you have a data source (such as a SharePoint list, Excel table, or custom collection) that contains the items you want to display. Each item should have a unique identifier (e.g., an “ID” field). 2.  Create a Custom Collection for Numbering: We’ll create a custom collection to store the numbered items. Here’s how: Set the screen’s OnVisible property : Clear(colNumberedItems); // colNumberedItems is a custom collection  ForAll(yourDataSource, Collect(colNumberedItems, Last(FirstN(AddColumns(yourDataSource, "RowNumber", CountRows(colNumberedItems) + 1), CountRows(colNumberedItems) + 1) ) ) ) Replace  yourDataSource  with the name of your...
Image
Send mobile notifications from Power Apps app📲 You can send a push notification from one app to another or to the same app. In canvas apps, you can send notifications by using the Power Apps Notification connector. In this article, the sample app used for notifications is built from the default  Case Management  app template. Before you begin, create push notifications for the Power Apps mobile app: Push notifications are used in Power Apps mobile to engage app users and help them prioritize key tasks. In Power Apps, you can create notifications for Power Apps mobile by using the Power Apps Notification connector. You can send notifications to any app that you create in Power Apps. Add a push notification to your app if: Your users need to know information immediately. Your users must complete important tasks by using your app, in a preloaded context. You want to engage your users on a specific interval, or you need users to enter the app in a specific context. Before you can...