By the Devs

In this post, I will show you how to setup up tab index for controls in Microsoft Dataverse for teams. We will first take a look at how the it works by default and then how it can be configured using Containers and Accept Focus property of the control on the canvas app. Let's Get Started! The scenario that we are trying to build here is for an app which is built using the "New" controls on a canvas App in Dataverse for Teams. The new controls does not have a Tab Index propert

In this #PowerShot, I will show you how to fix the issue when you are working with special characters and diacritical marks for different languages on Adaptive Cards in Outlook with Power Automate. The problem is, when you have a text string that contains any diacritical marks or characters, those get converted to "?". We will take a look at a simple fix to resolve this issue. Let's Get Started! You can create an adaptive card from the adaptive cards designer portal here. Onc

In this #PowerShot, I will share a flow setup that can be used to export tasks related data from a planner plan to Excel. This includes data like the categories applied to a task, notes on the task, completion percentage, assignments etc. Let's get started! If you have previously worked with the planner connector, you may have noticed that the Get Planner or the Get Tasks or the Get Task Details actions, do not return all the data associated to a task. Also, it is difficult t

In this #PowerShot, I will show you how to create partially filled Google Forms and send those to users using Power Automate. We will also look at a setup to receive the new/ edited responses from the users and update them in the data source. Let's Get Started One of the limitations we have come across setting Power Platform solutions is to send partially filled forms and get responses on those and further update the database where all the information is stored. In this post,

In this #PowerShot, I will show you how to use the Upload Excel PCF that @agarwal_ritika and I have recently created. You can use this control in Canvas Apps to directly import linear structured data and then perform further actions on it. Let's Get Started Step 1: In this step, we will look at creating the component. Follow the steps here to create a generic component structure of type field. Once the setup is complete, certain parts of the index.ts and ControlManifest.Input

In this #PowerShot, I will show you how to work with polymorphic data in canvas apps in Power Apps. We will take a look at different types of operations on Polymorphic lookup type columns in Microsoft Dataverse. If you are not familiar with the polymorphic lookup column, please refer to this article here. To work with Polymorphic lookup columns, we will require "AsType" and "IsType" functions that can be found on the Microsoft documentation here. Note: As Polymorphic lookup c

In this #PowerShot, I will show you how to setup a flow to force sync team members of a team to the Users table in the respective Dataverse for Teams environment. Let's get started! Initially, when you create an app and use the users table and then deploy it to a teams channel, you may not see all the members of the team appearing in the Users table. There are two ways you can resolve this issue. One by navigating to the Power Platform Admin Center -> Select the environment -

In this post, I will share about my experience and journey being a Microsoft MVP for Business Applications during the year 2020-2021! It was an overwhelming moment to first receive and open the email about the award and the program. I was “super excited”, “humbled and honored” to receive the award and had a great feeling of an accomplishment. The MVP credential outshone my profile and I had an opportunity to connect with the industry experts in Business Applications and make

In this #PowerShot, I will show you can make deep linking in Canvas App restrictive towards the data displayed to a user when they launch the app from a parameterized URL. Let's Get Started Let's take a look at an approval scenario where a manager is supposed to view the data of their reporters only and every time a user creates a request an email with a link to the app is sent to the manager. The manager can view the approval request related data by clicking the link in the

In this #PowerShot, I will show you how you can make more functions as delegable in Canvas Apps while working with Microsoft Dataverse as a data source. Let's Get Started We will take a look at the functions that are now delegable as per the latest release. The list of these functions include: 1. CountRows 2. CountIf 3. First 4. in Previously, these functions were not delegable and restricted the data access to upto first 2000 rows (based on the app settings) and now they can

In this #PowerShot, I will show you how to resolve issues that occur when you move a flow out of a solution and try importing it as an independent flow into a different environment or tenant. Let's Get Started We will take a look at the steps that can be followed to import a flow created in a solution as a regular flow to a different environment or tenant and resolve any issues that arise in the process. Flow config Below is what the details page looks like when you open a fl

In this #PowerShot, I will show you how to build an app with Power Apps to manage Azure Virtual Machines using the Azure Resource Manager REST API and a custom connector. We will take a look at a setup to interact with the Azure VM using the Azure Resource Manager connector, Azure Virtual Machines connector and build a custom connector to enhance the functionality of the app. Let's Get Started! Azure Resources We will be creating a setup to manage virtual machines. For this,

In this #PowerShot, I will show you how you can add a new option to a CDS option set. We will use the Common Data Service (Current Environment) connector and the Perform Unbound action to achieve this. Let's Get Started! Option sets in Common Data Service are a widely used data type and the *only* way to add more options to an option set is by navigating to the solution and then to the option set and then adding the options manually. Now in this post, we will use a flow to cr

In this #PowerShot, I will show you how to better handle throttling limits for API requests actions, connectors and flow runs in Power Automate. Let's Get Started Connectors in Power Automate have a set threshold for throttling limits on the number of API requests per minute/ day. When using a single connection (service account) for a flow that carries out multiple tasks for a large number of people, this limit might easily get crossed. To over come this, we will look at cert

In this #PowerShot, I will show you how to get attachments/ files from a teams message in Power Automate when a flow is triggered from the "For a selected message in Teams" trigger. Let's Get Started! Attachments/ files uploaded in teams chats are stored in SharePoint document libraries. In this post, we will set up a flow to trigger from a message selected in Teams and then get the file location of attachments added to the message and then get the file content of these attac

In this #PowerShot, we will take a look at a setup that allows to get the audit trail of the changes made to an audited field on an audited entity from CDS ('Project Oakdale'). We will use the 'RetrieveRecordChangeHistory' function and get the audit trail and extract the information from there in Power Automate. Let's Get Started! Currently, Power Automate supports scenarios to trigger a flow when a record is updated in CDS ('Project Oakdale'). But it does not return the valu

In this #PowerShot, I will show you how to trigger a flow in Power Automate when a record is created in an N:N relationship entity in CDS. Currently the CDS Current Environment and the CDS connector in Power Automate does not support the system created N:N relationship entity in the trigger actions. We will look at a workaround on how to do this using a WebHook. Let's Get Started! When an N:N relationship is created between two entities in CDS, it created another entity in th

In this #PowerShot, I will show you how to resolve the "The response to partial content upload request was not valid. The returned range header value 'bytes=0-xxxxx' is not in the expected range of '0-3524' with unit set to 'bytes'" error of the SharePoint create file action in Power Automate. This error generally pops up when you are trying to upload a file to SharePoint using the Create File action and the file size is slightly bigger than what is allowed in a single reques

In this #PowerShot, I will show you how to delete empty rows or rows with empty key columns in an MS Excel table using Power Automate and a Win Automation process. Let's Get Started! The current excel online connector in Power Automate does not provide with the capability to detect and delete empty rows or rows with a desired key column value as null. To overcome this limitation, we can use Win Automation processes to read the excel file and get rid of the empty items. Win Au

In the #PowerShot, I will show you how to format unstructured data, CSV data to an appropriate table in Power Automate using Win Automation and PowerShell. Currently, Power Automate does not directly support parsing CSV data or converting it to excel so that it can be further used in the consecutive actions along with the excel connector. Let's Get Started! Consider a scenario where an analyst or another system sends an automated weekly report in the form of CSV. This file ne