Unanswered

Text Datacards in Form reset when selecting from a filtered Choices combobox

(0) Share

Report

Posted on by marco72

Hello,

I have a Form which contains, among the rest, 2 text and 2 dropdowns (combobox) data cards. The 2 dropdowns represent a data hierarchy with Level 1 on the first and Level 2 on the second. They are both Choices (the second one derives from a Lookup field on a different Table). When the value of the first dropdown is selected, it is used to filter the Choices in the second dropdown so to limit the options for the users.

My problem is that as long as the second dropdown has unfiltered Items = Choices() everything works as expected even if the unfiltered second dropdown has too many choices for the users.

As soon as I introduce the filter for the second dropdown based on the value of the first one, the moment I select a value from the first dropdown the 2 text data cards, whose content has been modified in the meantime by the user, reset back to their original values when the record started to be edited.

I have tried re-adding all the involved datacards, but not matter what, as soon as the second dropdown Items are being filtered, this side effect happens.

Here is the filtering code I use for Items of the second dropdown:

Filter(Choices([@Main_Table].Column2), Text(Column1) = Text(DataCardValue2.Selected.Value))

Which works perfectly beside having the side effect mentioned above.

If I just revert to the standard unfiltered:

Choices([@Main_Table].Column2)

There is no longer any side effect on the two text controls.

Is this a bug of some sort or am I overlooking something? My only option at this point would be to redo the whole Form from scratch.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

AJ_vizMan on at

Like (0)

Report

Hi @marco72 - You are facing issue while editing an item. RIght?

Use this
Filter(Choices(Main_Table. Column2); Column1= DataCardValue2.Selected.Value)

Was this reply helpful? Yes No
marco72 19 on at

Like (0)

Report

Thanks for the suggestion but I cannot use that form because Column1 and DataCardValue2.Selected.Value are OptionSetValues from different tables and, while they are identical in content, they cannot be directly compared. I get an error that the two types are not comparable. Hence I had to revert to a text comparison with Text().

What I find strange is the crossover effect on other DataCards, so running that filter is triggering something on the whole Form but I cannot pinpoint it.

Was this reply helpful? Yes No
AJ_vizMan on at

Like (0)

Report

Have you checked data type of both columns. Is it different?

Was this reply helpful? Yes No
marco72 19 on at

Like (0)

Report

Yes, Please see the error. Had to hide the column names because of confidentiality, but they are seen as two different OptionSets because they come from different tables even if the content (as a text) is identical for both. Not the best data model but ok, I am not aware of shared Choice columns in Dataverse for Teams.
My problem is not that the filter isn't work. It is working perfectly, but having it seems to affect other DataCards in the same form or the form itself in an unexpected manner. Getting rid of the Filter and leaving only Choices removes the side effect on the other DataCards/Form, but of course the combobox has now too many entries and is basically unusable.

Was this reply helpful? Yes No
marco72 19 on at

Like (0)

Report

I have done many other attempts to fix this, but no matter what, if the second combobox is being filtered, the form reset happens each and every time the first combobox value is changed. Running out of options...

Was this reply helpful? Yes No