Category Archives: PowerApps

Export Power BI data to CSV via Power Automate visual and upload to SharePoint

After PowerAutomate was added in PowerBI as a preview feature, it is finally available for general use. In this blog we are going to use this PowerAutomate visual to export PowerBI data into CSV and upload the CSV on Sharepoint. Open PowerBI Desktop and drag the PowerAutomate Visual, if it isn’t available in the visualization … Continue reading Export Power BI data to CSV via Power Automate visual and upload to SharePoint

Share Story :

Create Custom Recommendation on Form within Canvas Power Apps

Hello, everyone! We know that Recommendations are created using Business Rules, but that only works on Model Driven Apps. As a result, we’ll develop Custom Recommendations that are flexible and customizable to our needs and enhance our App. This is how the Custom Recommendation looks, Let’s start with a simple use case, I want to … Continue reading Create Custom Recommendation on Form within Canvas Power Apps

Share Story :

How to personalize Password field based on strict Regular Expression (RegEx) formulas in Canvas PowerApps

Hello,In this blog, I’ll show you how to personalize Input Password field with various requirements using strict regular expression in Canvas PowerApp. Now, validation part comes in using RegEx. Let’s say you have a requirement where,1. Password length should be equal or greater than 8.2. Password should contain at least 1 number.3. Password should contain … Continue reading How to personalize Password field based on strict Regular Expression (RegEx) formulas in Canvas PowerApps

Share Story :

How to solve OLE DB or ODBC errors in PowerBI

Introduction: Sometimes while refreshing our dataset in PowerBI or importing new data from existing sources we may encounter OLE DB or ODBC errors as shown in the image below. This might be due to caching issues. To solve this follow the steps: Go to File tab on the ribbon in PowerBI Desktop , then click … Continue reading How to solve OLE DB or ODBC errors in PowerBI

Share Story :

How to extract information from XML/HTML/FSON and convert it into PlainText in Canvas PowerApps without Flow

Posted On March 16, 2021 by Ethan Rebello Posted in Tagged in , ,

If you are curious about the data in XML/HTML/JSON and want to fetch data from it without flow. Here’s something what you can do There’s an inbuilt function in PowerApps that converts HTML/XML to string text. Function Name is ‘PlainText‘. But all tags are neglected and extracting certain data is difficult. Consider you want to … Continue reading How to extract information from XML/HTML/FSON and convert it into PlainText in Canvas PowerApps without Flow

Share Story :

Control elements in PowerApps with different font-size

Posted On March 15, 2021 by Ethan Rebello Posted in Tagged in , ,

Its good to have a user’s choice based font-size but without controlling how it displays on screen may not look good. I have created a simple design that consists of a header, gallery and font-size slider to show how elements react on certain font size. Here’s how it looks. How to make this, Set your … Continue reading Control elements in PowerApps with different font-size

Share Story :

Create a Custom Real-time Loader Control in Canvas PowerApps

In Canvas PowerApps, we usually show an image that lies over the screen until an execution is completed. But tracking real-time update might be confusing. I’ll show you a simple custom loading control that not only show execution status but also look good and is highly customizable. Here’s a preview how it will look (Note: … Continue reading Create a Custom Real-time Loader Control in Canvas PowerApps

Share Story :

Create a Custom Dropdown Control in Canvas PowerApps

As we know that a Standard Dropdown control do not have enough features and has limited properties to modify. Hence I have created a custom dropdown menu. Some drawbacks in Standard Dropdown,1. It shows only 1 particular attribute as value. Example: “Name”2. If multiple records of same name exist, then you cannot differentiate them. This … Continue reading Create a Custom Dropdown Control in Canvas PowerApps

Share Story :

Auto Save Using Timer Control In PowerApps

Introduction: While using Power apps, we might come across situation where we do not want the user to click on the Save button and then move to next screen to fill in child records. In such case we can use timer control to auto save the form and navigate to new screen. Solution: In my … Continue reading Auto Save Using Timer Control In PowerApps

Share Story :

Create a new record using Editable Grid in Canvas App

Introduction  – In this blog we will see how can we create new record in editable grid itself. Below is the Time Entry Grid and we wanted to add new row on click on “+” Step 1  : Add  new icon “+” on screen and add patch operation On Select of the new icon. Syntax … Continue reading Create a new record using Editable Grid in Canvas App

Share Story :