Expense Report App – Based on Power Apps (Canvas and Model Driven)

Microsoft has provided a sample Power App which can be used for the purpose of managing expenses. Ref: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/expense-report-install We have added more features to the sample Expense App and would like to present and share that with the Power platform community for generic usage. Let's review the Power Apps based Expense Management Solution. This…

Invite External Contacts as Azure AD Guest Users via Power Automate Flow

In this blog we will see how can we add an external contact to Azure AD using power automate flow. This will create an azure AD  guest user account for the user and provide an invitation email with a url to access the APP. Use Case: You are building a Power App, and need to…

Upload Files Directly From Powerapps To Sharepoint(Using Graph API)

In this blog we will see how to upload files directly from powerapps to sharepoint without using any power automate flow. Here we will make use of Graph API. First we will create a sharepoint document library. For that go to the sharepoint site to which you want to create the library. And then click…

How to Display Duplicate/Repetitive Multiple Rows in a Single Cell of a Table/Matrix in POWER BI 

REQUIREMENT: Compress multiple row values in a single cell value of a table or matrix using CONCATENATEX function in Power Bi as shown in the Fig.1     Fig.1  SOLUTION:  Step1: Import table using Getdata in Power BI Desktop as shown in Fig.2   Fig.2  Step2: Add relationships between the tables as shown in Fig.3. There are two…

How to upload an image/file from canvas app to a SharePoint document library and display it in the Document section of model driven app (via Server side Synchronization)

Storing attachment from PowerApps to SharePoint is a common requirement for many apps. To accomplish this we will use a power automate flow with power apps as the trigger. This blog walks you through , how to upload an attachment from canvas app to the corresponding folder in SharePoint document library and thereby display it…

Exception handling in Power Automate

Exception handling is the most common practice used in programming to tackle unwanted or unexpected events. Since exception handling deals with anomalies, it avoids program error, flow error and system crashing. There are many reasons which can cause exceptions, including expression error, invalid user input, loss of network connection, user attempting to open files which…

Power Pages vs PowerApps Portals

The announcement of Power Pages at Microsoft Build was met with some real excitement from our consulting team. It is the fifth addition to the Power Platform – a suite of products designed to streamline your business processes and empower your people to create solutions to their own challenges. It was billed as a way…

Call Custom Page with parameters from Model Driven App – Using New Command Editor

This blog guides you through, how to pass parameters from model-driven app to custom pages while opening custom page as a central dialog inside form using button, in order to upload documents to the respective record's folders in SharePoint. This Functionality was achieved by adding buttons to forms in model-driven apps using the new command…

Update multiple records using custom button

In Dynamics 365, it very common that a larger number of records need to be approved or a similar action need to be done. In these scenarios going to each record and performing the necessary action will not be a better option. To tackle these situations, custom buttons can be used. After selecting the records…

How to Upload Documents from Custom Page to their Respective Record’s Folders in SharePoint

This blog takes you through, how to upload document files from custom page opened in a model-driven form to that respective record’s newly created or already existing folders in SharePoint. This scenario is achieved with the help of a power automate flow. The steps involved in the power automate flow are explained below: Step 1:…

How to Call a Custom Page from Button Click in Model-Driven App

The usage of buttons in model-driven apps helps in easy navigation from one table to other tables or custom pages without even leaving the respective forms. Ribbon workbench is an efficient tool used for the same. This blog guides you through, how to call a custom page as a central dialog box inside the account…

How to add a Custom Page to an Existing Model-Driven App

The custom page is a new page type within a model-driven app, which brings the power of canvas apps into model-driven apps. Custom pages increase the convergence of model-driven and canvas apps and can be used to add full pages or dialogs with the flexibility of the canvas designer. This blog tells you how to…

Call HTTP Request from Canvas Power App using Power Automate Flow and get back Multiple Rows as Response

Well, in order to call HTTP request from canvas app to external resources, you will need to go through a power automate flow and then get response back in the canvas power apps as referred in the figure below. SCENARIO: Call a flow from within a canvas power app on clicking a button and capture…

Enable Interactive Map in Power App (Canvas / Model Driven)

Canvas App Canvas apps are true low-coding apps, they do not require coding know-how. The users have full control over every single aspect of the resulting app, including size and formatting of its components. Since Canvas app allow for a high degree of creativity and flexibility. The Canvas apps are mainly used for mobile devices.…

Create Lead with chatbot using Power Automate

Power Virtual Agents empowers anybody to easily create powerful chatbots for a variety of purposes. The major attraction of Power Virtual Agent from a development perspective is its code-free graphical interface. With Power Virtual Agents, customer support chatbots, sales chatbots, and much more can be created. Chatbots can also be created for customers and also…

Visualize your data quickly from Power Apps and Dynamics 365 apps (preview)

There's a new way to visualize your model-driven Power Apps and Dynamics 365 data stored within Dataverse. With a single click, Power BI will automatically generate a set of visuals for you to explore and find insights within your data. Read more about this here Known issues and limitations Currently, the visuals generated from this…

Delete confirmation Dialog in PowerApps Canvas App

In canvas app we usually come across the need of different types of dialog boxes. Confirmation dialog box is one among those. Mostly confirmation dialog boxes are provided in the app where critical actions like delete, approve, reject etc. are performed. In our case we are trying to delete the gallery item with a confirmation…

Migrate Auto Record Creation Rules & SLAs to UCI before Oct 21!

Automatic Record Creation rules and SLAs are required to be migrated from Webclient to UCI client by Oct 2021. There is a ARC & SLA migration tool in the Customer Service Hub and the same can be used for the migration. Internally these processes were running on traditional workflows and this is the strategic move…

Dataverse and Dataverse (Legacy) connectors in Power Automate. Not just a name change!

The Common Data Service (current environment) connector, featuring a native integration between Power Automate and Dataverse, will now be known as Microsoft Dataverse, and appear with the new icon and color shade as shown below.  The previous Common Data Service connector will be known as Microsoft Dataverse (legacy). It will be shown with the new icon, albeit in a…