Power Platform Community Forum Thread Details

I would like some help on how to include a filter in my formula in the dropdown linked to the search bar, which in addition to filtering the Index column in the DB - (General) Customer (OFFICIAL) database, I would like to filter the "Country (SAP Ps.)" column, but only what is marked as "BR".

And I would also like to include a filter in a dropdown of the Status General of the 'F - SBPT 3.0 / BR' database that is linked to the formula, so that it is possible to separate what is active and what is deleted.

powerapps_01 = App on Edit View

powerapps_02 = Data source F - SBPT 3.0 / BR - Column Status General - Deleted

powerapps_03 = Data source DB - (General) Customer (OFICIAL) - Column Country (SAP - Ps.)

Current Formula in Dropdown Filter linked with Search Bar:

Filter(
SortByColumns(
'DB - (General) Customer (OFICIAL)',
"Index",
SortOrder.Ascending
),
StartsWith(
Index,
TextSearchBox_Customer_A.Text
)
)