Filter and search a data source via a search box and dropdown


Sun Jul 17 2022 08:27:57 GMT+0000 (Coordinated Universal Time)

Saved by @gofunk1 ##powerapps

Filter('Aviva Account Desk Booking', StartsWith(TextName, SearchBox.Text) && (Status.Value = Dropdown4.Selected.Value || Dropdown4.Selected.Value = Blank()))

In this case, the formula uses the StartWith function to compare a SharePoint column (TextName) to text input (SearchBox.Text) and a dropdown selector (Dropdown4). It contains and or function (||) to ensure it works if the drop-down is blank. AllowEmptySelection must be set to 'true' for this to work. Used in the Items field.