Hello my fellow Power Rangers. If someone can figure this out, you will be my Power Hero.
In a nutshell: looking to get dependent dropdown and translation toggle functionality all in one.
My dataverse has two important tables....
TABLE 1: FruitClassificationTable
This table has 4 relevant columns. The table will provide values for the dropdowns in the app. I mimicked what the table looks like in Excel below:
[fruit_family]: General family of fruits. For example, oranges and grapefruits belong to the citrus family.
[fruit_english]: A specific fruit. For example, an orange is a specific fruit in the citrus family.
[fruit_spanish]: The Spanish translation of the specific fruit in the [fruit_english] column.
[fruit_code]: The unique code identifying a specific fruit.
TABLE 2: PurchasedFruitTable
This table has 1 relevant column. Every time someone purchases a fruit, the fruit_code goes into the [purchased_fruit] column and the table grows by one row. I mimicked what it could end up looking like using Excel below:
This is what the app looks like:
It's kind of hard to see, but basically the top left is a toggle that should allow the end user to toggle the dropdown on the right between English and Spanish. The left dropdown is the Fruit Family dropdown, and the right dropdown is the Specific Fruit dropdown.
There are three requirements that must be satisfied…
1) Specific Fruit dropdown needs to be dependent on the Fruit Family dropdown. For example, if I click on “berry” in the Fruit Family dropdown, only specific fruits that belong to the berry family should appear in the Specific Fruit dropdown. This would be a dependent dropdown.
2) When the end user clicks the “Click Me to Translate to Spanish” toggle, the Specific Fruit dropdown should switch to the Spanish translations.
3) When the end user clicks the “Submit to PurchasedFruitTable” button, the fruit_code corresponding to the specific fruit that was selected must be written to the PurchasedFruitTable in the dataverse.
The important thing is that, regardless of whether the dependent dropdown is being displayed in English or Spanish, the fruit_code is what is written to the PurchasedFruitTable. That way we don’t end up with a PurchasedFruitTable that looks like this:
… because that would be too difficult from a data analysis perspective.
There is plenty of online content about building a dependent dropdown in Power Apps, but to build a dropdown that is both dependent and translatable via a toggle button is turning out to be quite the challenge!
Any help appreciated (:
Thank you!
