Hi All,
I am using Sharepoint as my backend. I have four dropdown columns. Three dropdown columns are available in powerapps screen and based on the dropdown selection the gallery should display the results (Screen 1).
Screen2:
There will be option to accept attachment, where user will upload excel with bulk rows of records, by filling the fourth column data. Fourth dropdown value will be entered by the user. Result of fourth column could be "Yes" or "No" . Once the bulk upload done, another gallery will be available in the screen 2, which will display if any incorrect values entered by the user in Fourth dropdown column. For example, if user enters "True/false/NA" instead of "Yes or "No" , then it should display the incorrect rows.
So i have written a formula to filter the records which is not equal to the value of Yes or No in filter, but it is giving Delegation warning and not providing the expected result. Could anyone please help on this.
Filter('Test 1',
('Column1' = column1dropdown.SelectedText.Value || column1dropdown.SelectedText.Value = Blank()) &&
(Column2 = Column2dropdown.SelectedText.Value || Column2dropdown.SelectedText.Value = Blank()) &&
('Column3' = Column3drpdown.SelectedText.Value || Column3drpdown.SelectedText.Value = Blank()) &&
('FourthDropdowncolumn'.Value <>
"Yes" || 'FourthDropdowncolumn'.Value <> "No") )
