Hello Power Apps community,
I am quite new to Power Apps and struggling with a function that does not work for me.
I have build a canvas app with two dropdowns, which get distinct values from a Sharepoint list. Dropdown two is dependent on dropdown 1, so the number of choices when the user selects an option in dropdown 1 is reduced for dropdown 2 to only the relevant values. The behavior that I want to achieve now is, that depending on the selection of the user for the two dropdowns a third colum in the same Sharepoint list is checked (the combination of the values from dropdown 1 and 2 identifies a unique row from the Sharepoint) and if it contains a special text, then the "Continue" button should be deactivated until the user fills something in an additional text field.
Right now I am using the following formula on the DisplayMode property of my button:
If(!IsBlank(LookUp('Beschreibungen', Name=Dropdown1.SelectedText.Value && Beschreibung=Dropdown2.SelectedText.Value && 'Weitere Beschreibung notwendig?'="weitere Beschreibung zwingend notwendig!")) && !IsBlank(TextInputTätigkeit), DisplayMode.Edit, DisplayMode.Disabled)
The formula is working as intended regarding the first part of the condition. If a special combination in which additional description is needed gets selected the button is activated once the user fills in some text. But the button is deactivated for all other combinations in which I do not have the specified condition so no additional description is needed. Even if I fill in the text field, the button does not get activated as it should.
Could someone explain to me where I got it wrong and point me in the right direction? Thank you very much in advance!
