Category Archives: PowerApps

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 :

Add Search Box in Canvas Power App

In this blog we will see how to add Search Box in Canvas App Step 1 –  Add text box in your screen. Hint text – Search Step 2 – Select Gallery and on items of the Gallery write your query Syntax – Search(DataSource,InputText.text,Attributename) for example – Search(‘Safety Checklists’,SearchBox.Text,”mc_name”) Output – Hope this helps !

Share Story :

[Solved]Combo Box not showing Look up value ??

Introduction – Recently we were working on Canvas app and tried using combo box but after adding items to it, lookup values were not showing. So here is solution – Select Combo box -> Select IsSearchable And set value to true Output Hope this helps !

Share Story :

Create Pop up in Power Apps

Posted On August 30, 2020 by Ankita Chavan Posted in

In this blog we will see how to create Popup in Canvas power Apps Step 1: Add a label on you screen where you want to add a Popup Now add a background color -> select  custom as shown in below image. Step 2: Add a rectangle Step 3: now add two buttons, and name … Continue reading Create Pop up in Power Apps

Share Story :