Category Archives: PowerApps
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
How to extract information from XML/HTML/FSON and convert it into PlainText in Canvas PowerApps without Flow
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
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
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
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
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
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
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 !
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 !
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