In this blog, I am going to show how we can create a collapsing and retracting gallery control in Canvas Power app. Let’s start making this into our Canvas PowerApps Step 1: Insert a Flexible Height Gallery on the screen. For the current example, I’m using a table of User details. Items property of Gallery Step 2: Adding a ‘button’ which is stay visible all time and a ‘Container’ which will only be visible when that specific record is selected. Step 3: Adding variables to store information of selected record unique ID. OnSelect property of Button, Visible property of Container, Step 4: Modify as you like, I’ve added color indication which record is selected. That’s all, We have finally created the collapsible Gallery control in Power App. Hope this helps!!

Hi Everyone,Awaited moment is here, we finally have Power Apps designated application for Windows. Currently its in Preview so use only for testing as of now until its pushed globally. Here’s the steps to download and use Power Apps for Windows Step 1: Go to Microsoft Store and search “Power Apps” Step 2: Install the application. Step 3: In order to run this application, we need to check WebView2 Runtime version on our device. It should be version 99.0 or later. To check this, go to Settings > Apps > Apps & features. Search for WebView and verify that you have version 99.0 or later installed. For those who don’t have this, follow below steps. To install WebView2 Runtime, download the WebView2 Runtime. Download version 99.0 or later. Installing an earlier version may cause Power Apps to crash. Under Evergreen Bootstrapper, select Download. Go over the license terms and privacy statement and then select Accept and Download. When the download is complete, then run the MicroEdgeWebview2Setup.exe. Step 4: Open and sign-in with your ID Step 5: After logging in, you will find list of Model and Canvas Apps that are shared to you or you having access by security roles. The screen will show all Apps from all the environments present in you tenant. You can also see other model-driven apps if you enable Show non-production apps in settings under Model Apps. That’s all about installing Power Apps on Windows. Find the Microsoft Documentation for Installing – Microsoft Docs Find the Usage of Power Apps Windows – Microsoft Docs List of known issues – Microsoft Docs Hope this was informative and helped you.

Hi Everyone, If you are using Custom Pages in your Model Driven App and would like to have multiple languages as per User’s Personal settings? Here’s a quick helpful method for Custom Pages Step 1: Let’s start by creating a Custom Page Go to PowerApps Maker Studio, in your selected environment outside or inside a solution. Add new Custom Page Step 2: Fill your app as per requirement. I’ll just keep it basic. Note: OOTB Tables/Entities will show translated values except custom text/tooltip/custom tables, etc. Below, for my custom Title Label. I have used Language() function to detect the User’s language set in Personal Settings applied on Browser Level. Step 3: Save, Add and Publish the Page on Site Map (Edit in Preview) section. Reload your Model Driven App to see the effect User’s Language set as English User’s Language set as Spanish Select Spanish in Personal Settings That’s how simple it is to set Language in your Custom Page. Note: If you are working with Custom Entities, BPFs you need to add translation for the Language in Data verse manually. Please follow the steps mentioned in this Blog: Enable language translation on Custom solutions in Dynamics CRM. Hope this helps 🙂

Hi Everyone, Consider a scenario where we want to filter out a dropdown/combo-box choice field based on value in other field or dropdown.Since we cannot use scripts in Canvas App, here’s how we can show specific choice based on multiple values For this example, I’ve considered a bunch of basic items belonging to Fruits, Vegetables and Dairy products. For example purpose I’ll be creating a collection of values to representation. This step will be avoided for choices field within a table/entity.Below is the ‘Master Record’ of collection. Step 1: Create an indexed collection. (referring to MasterList in this example) Step 2: Let’s say we would like to classify the Master List into 3 categories (Fruits, Vegetables and Dairy). In this example, I’ll be using a dropdown list for which the main dropdown field is required to filter data. I’ll be adding a hidden button, containing the following code Based on the above code,Type 1 refers to “Fruits”, Type 2 refers to “Vegetables” and Type 3 refers to “Dairy” Step 3: Added dropdown which will hold classification values. Step 4: The main dropdown choice field which will be filtered based on categories mentioned by above dropdown. That’s it. We have successfully implemented the dynamic choice list as per values dependent on other field. Hope this helps you.

Hi Everyone, Isn’t it annoying that you have a text field in your Canvas App which holds a huge information to fit in a small space?There’s a quick solution which you can use to show a mini pop-up by an out-of-the-box feature. Let’s consider an example of where we have a paragraph in a text field then we have output is to be displayed with a limited height and width on the screen. Fig 1: This is a TextInput control where we have a detailed information.Fig 2: This is a normal label/text field control which has limited height and width. (Especially in scenarios like gallery records)Fig 3: This is a ComboBox control with DisplayMode set to View and the DefaultSelectedItems property is set as [TextInput.Text]We can see that when having more data, we can click more and see the entire information. Hope this quick tip helped you in your scenario.

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 pane update your PowerBI Version. Now add the columns, you need in your CSV file. Click on the ellipsis button on the visual and select edit. Create new flow and select instant cloud flow. A default PowerBI trigger would be created, click on add new step. Search “Compose” action in the search bar and select it as we have to compose PowerBI Raw data first. In the Inputs select PowerBI Data. After composing we have to convert this data into CSV, therefore add “Create a CSV table” step and add previous output. Now we have to upload this CSV into sharepoint so we will add a step to create a sharepoint file. Enter the Sharepoint address, Folder Path, give the file any name desired and put “.CSV” as suffix. Save and close the map. To run the flow, press Ctrl and left click. As you can see the file in SharePoint is created. Thanks for reading, hope this blog helped!

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 set ‘Preferred Method of Contact’ field as Phone when User enters data within ‘Phone’ field within the App. Step 1: Add an Edit Form in Canvas Power Apps where the Recommendation would be applied. Step 2: Within Form properties, Click on Edit Fields Add Custom DataCard. Drag your Card below the DataCard where you need Recommendations. Step 3: Within the Custom DataCard, enter necessary information that you like in your App and use below condition. Step 4: For Apply button, I’m using context variables that sets true when click and remains until record is saved or the current screen is Active. Step 5: For changing values in my combo box on field ‘Preferred method of contact’.Note: Based on your requirement, this will change… That’s all. Hope this helps you.

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 at least 1 lowercase alphabet.4. Password should contain at least 1 uppercase alphabet.5. Password should contain at least 1 special character. After everything all requirements is satisfied, show that password is valid. Let’s say you have 5 labels containing Text of these requirements and will be visible if its respective condition is not satisfied. Hope this helps you.

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 on About and check the PowerBI version, make sure it is the latest version if not update PowerBI. If PowerBI version is latest, click on the dropdown arrow below the Transform Data button. Click on Data source settings Click on Global Permissions Select the Data Source and click on Clear Permissions and click on close. Click on close and again select the data source as new and enter the credentials. This time the dataset would be loaded without errors. Hope this article helped

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 extract a small size information which is in XML/HTML/JSON and don’t have time to write a flow. Here’s what you can do I have a XML data.Tip: When converting your XML/HTML to PlainText. It’ll show space and next line if you place tags correctly. Keeping in 1 line or no spaces will reflect in result which will look bad. I have created 2 buttons and 2 input text boxes. 1st button will set XML/HTML/JSON in a variable or collection 2nd button will check for next values if tag found. 1st and 2nd input Text Boxes represent start and end tags There are 3 main variables that we’ll use to iterate the values. Here TagFind, TagFind_End are 2 input text boxes and var1 is variable holding XML data. Find function finds data which is encountered once. Since it has starting point we define it to iterate to next search. Current and CurrentEnd will represent start and end point of tag.Next will determine next index to start searching from We will have 1 label to show our answer Here the text property has the formula that retrieves data within the start and end point of the tag. Finally you will achieve something like this, You can use this fetched data somewhere in your PowerApp. You can also use something similar to extract values in branched data form. In a certain range of data.For example; In above XML, i have ’employees’ as 1 tag determining contents in it.If i had Name tag in employees and Name tag in ‘Department’ then by range of ‘Employees’ or ‘Department’ i can fetch Name of that block only. Hope this idea helped.