Hi there,
Happy Holidays to you all!
I'm having difficulty creating a cascading dropdown from a single, custom Dataverse table. There are two columns wherein I want one to be dependant upon the other, both are "Choice" data-type columns. These drop-downs are currently displayed in a form, which when a new form is updated/submitted, it submits the data directly to the Dataverse table.
The first column, is titled Energy Group, and has three choices: Gas, Electricity & Water.
The second column, is titled Energy Type, and has ten choices: gas one, gas two, water one, water two, water three, water four, water five, electricity one, electricity two & electricity three.
Naturally, I only want the respective energy types showing, when the energy group has been selected.
So far, I've used Youtube tutorials, (which have been based on Sharepoint lists, although i know the premise is the same).
The first solution, is to create a formula on the energy-types dropdown datacard, using the right hand side "depends-on" toggle, and the generated solution created, is:
Filter('Jab Readings', 'Energy Types' = DataCardValue14.Selected.Value) - this creates two errors. One against the datacard, and one against the '=' value in the formula.
If I use DISTINCT, against the energy groups datacard, to filter the choices, the "Update" parameter errors out, and leaves the dropdown inert.
Thank you in advance if anybody could shine a light on this, as I'd be very grateful.
Sincerely
W
