How can we link particular choices with another choices in canvas app

Question

I have to implement something like A column employee we have three choices like EmpA EmpB EmpC and for each sub choices have almost 3-4 choices can we link particular choice value to the another choice.

Jithu Thomas · Answer

Absolutely! You can link choices in a Power Apps canvas app to achieve the desired cascading functionality for your employee and sub-choice selection. Here's how to implement it: 1. Data Source: You'll need a data source that stores the employee (EmpA EmpB EmpC) and their corresponding sub-choices. This could be: SharePoint list Excel table Other data sources supported by Power Apps 2. Create the Choices: Create two dropdown controls in your Power App: One for the Employee (EmpA EmpB EmpC) Another for the Sub-Choices 3. Define Choice Options: For the Employee dropdown set the Items property to a static list of choices: [EmpA EmpB EmpC] 4. Dynamic Sub-Choices based on Employee Selection: Here's the key step for linking choices: Set the Items property of the Sub-Choices dropdown dynamically based on the selected employee in the Employee dropdown. Use the Filter function to achieve this: Filter( YourDataSource // Replace with your data source name Employee = EmployeeDropdown.Selected.Value // Reference the Employee dropdown value ) .SubChoices // Replace with the name of the sub-choice column in your data source Explanation: This formula filters your data source based on the Employee field matching the selected value from the Employee dropdown. It then retrieves the SubChoices column (replace with your actual column name) from the filtered data providing a dynamic list of sub-choices specific to the chosen employee. 5. Cascading Updates (Optional): If you want to perform actions based on the selected sub-choice use the OnChange event of the Sub-Choices dropdown and access the Selected.Value property. Additional Tips: Consider using a lookup column in your data source to link employees and their sub-choices for a cleaner data structure. You can customize the appearance of the dropdowns using the BorderColor  Fill  and other styling properties. Example with a SharePoint List: Assuming you have a SharePoint list with columns Employee and SubChoices  here's an example of the Items property for the Sub-Choices dropdown: Filter( SPListName // Replace with your SharePoint list name Employee = EmployeeDropdown.Selected.Value ).SubChoices By implementing this approach you'll create a dynamic selection experience in your Power Apps canvas app where the sub-choices adjust based on the chosen employee.

Jayraj Chhaya · Answer

In Power Apps you can achieve the desired functionality by utilizing cascading dropdowns. By creating relationships between the main choices (EmpA EmpB EmpC) and their corresponding sub-choices you can dynamically update the available options based on the selection made. This involves setting up dependent dropdowns where the options in the second dropdown change based on the selection in the first dropdown. // Assuming you have two dropdown controls: Dropdown1 for main choices and Dropdown2 for sub-choices // Set the Items property of Dropdown1 to the main choices Items = [EmpA EmpB EmpC] // Set the Items property of Dropdown2 to the sub-choices based on the selection in Dropdown1 Items = If(Dropdown1.Selected.Value = EmpA [SubChoice1 SubChoice2 SubChoice3] If(Dropdown1.Selected.Value = EmpB [SubChoice4 SubChoice5 SubChoice6] If(Dropdown1.Selected.Value = EmpC [SubChoice7 SubChoice8 SubChoice9] []))) By implementing cascading dropdowns in this manner you can link specific choices to their corresponding sub-choices effectively within your Power Apps canvas app.