
Announcements
Context
In my Canvas App I have a Form on which I'm trying to create a cascading dropdown. In other words, I change my list of Items on a dropdown based on the value of my previous dropdown.
Method
As I'm working with a Form, I set the AllowedValues on my DataCard using a filter. This works, as long as I don't submit the form.
Unexpected result
When I run the SubmitForm() function, the AllowedValues property of my DataCard changes. When I look at it from the DataCard itself, it still shows the correct values:
AllowedValues as seen from DataCard
However, when I look at it from my dropdown the list is different and a column has been added. Because of this, the value of my dropdown has also changed to a value that shouldn't be possible in combination with the previous dropdown's value.
AllowedValues as seen from dropdown
The item of the form is a collection, the data source of both the form and the AllowedValues formula is Dataverse.
I strongly suspect this is a bug. And that it has something to do with the order in which background functions are run. If anyone has a workaround or agrees that it is a bug and knows how to communicate this to Microsoft, please let me know.