For my item description box, I would like to filter the descriptions depending on the commodity that was chosen. The current box for the commodity is datacardvalue9. This is the current formula I use
Filter ('Conditioning Tool 2', Commodity = DataCardValue9.Selected.Result). It is not working. Although, a dropdown box is in the commodity section. A global variable is used to select the correct commodity depending on the button used to get to the edit screen. Is this why the formula is not working? If so, how do I fix the issue?
