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.

Hello,Consider a scenario where we need to have a table (entity) which is a replica of other table or you need some fields replicated into another table. This tool will save a lot of precious time. Let’s say I have a table called ‘Scoping’ and I want fields from that data replicated into another table called ‘ScopingClone’. Steps you’ll take to do this in a time-efficient manner. Step 1: Create a new Table/Entity. (In my case, I created ScopingClone) Step 2: Navigate to XrmToolBox and install ‘Clone Field Definitions‘, connect to your environment and open the tool. As you can see, the fields that I selected are successfully cloned. I hope you found this blog useful.

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.

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.

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.

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 font-size range into slider or any other control element like dropdown.Set Title or any text as value of slider or dropdown and use increment or decrement as per requirement.For example: Header title is X then sub-header will be X-2 font-size. To make gallery change its style as per font-sizeSelect ‘Wrap-count’ property of gallery and insert formulaIf(Slider.Value > 25, 1, 2);This will make 1 column is font size is more than 25 else 2. You can create this on every control/elements that requires such change. Hope this helped.

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: Determine your layout before hand like X,Y, Height and Width)(Customize your look, I’ve added dots above just for demonstration purpose.)How to make this, Elements used visually are, Create a Rectangle as main background and set Height, Width, X and Y. (I’ve used light grey color) Insert another Rectangle to show loading animation which will fit inside main Rectangle.Determine its Height, Width, X and Y. Label control to show current status or add a simple static label. Gallery Control having circle in them i.e.: Dots (Optional, I used to show how i retrieve data as its similar to Navigation Screen Gallery Control used in 1 of predefined template in Canvass PowerApps) Functionality behind used are, Gallery Control under ‘Items’ I’ve added table. (Based on your content, keep total count of steps you would like to see in loading page. In my case, i have 6 steps) Label Control that shows current status based on current step. Rectangle with loading animation. (Note: Your step count and width may vary) Now you may have a button that will call list of execution that you will perform. To track every successful completion of process just add this, Later reset count and turn visibility off. (Note: This is re-usable and can be used as component.) Hope this helps.

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 is Custom Dropdown I have created, Steps to make the custom dropdown menu Step 1. Insert a ‘Text Input’ and ‘Horizontal Gallery’ and set height of gallery of your desired height also change Template Size according to fields added into a row. (As I have added only Name, Phone and Image) Step 2: Add an Icon ‘Down Arrow’ at the right of ‘Text Input’ and change property. onSelect = UpdateContext({showDropdown: !showDropdown})   //Condition to show/hide the CustomDropdown (Gallery). Step 3: Property to be changed.‘Text Input’ changes below, Default = textVal              //It’s a Variable Fill = // Anything you feel suitable, I used “RGBA(230, 230, 230, 1)” Height and Text Size = // Anything you feel suitable. onChange = UpdateContext({showDropdown: !IsBlank(Self.Text)})             // Condition to show/hide the CustomDropdown (Gallery). ‘Gallery’ changes below, Items = Search(Accounts, TextInput.Text, “name”)             // Filter Parameter by text. showScrollBar = false TemplateFill = // Anything you feel suitable, I used “RGBA(255, 255, 255, 1)” TemplatePadding = 10 TemplateSize = // As per your contents in a row Visible = showDropdown              //It’s a Variable Step 4: To add functionality of basic dropdown on selection.Add a button to of size equal to template Size (i.e: cover entire record section) and change properties given below, onSelect = UpdateContext({textval: ThisItem.’Account Name’})    //Defined variable HoverFill = //Anything you feel suitable, I used “ColorFade(RGBA(240,240,240, 0.3), -10%)” Step 5: Custom Dropdown complete. You will have something like this, Note: For additional responsiveness in design, change X, Y, Height, Width. Hope this helps!