Power Platform Community Forum Thread Details

Hi,

I have a dropdown list (linked to a single line text input column - not a choice column) for "resource types", and I was wanting to link two types together - for example.... If "Outpatient" is selected ... I want all results that are outpatient to show, however I also want the results that are for the option in the same column "Both" to show.

This is the coding that I have so far - I expanded the original coding for the filter so that I could account for the two additional outcomes however nothing that I've tried is working.... ALL HELP greatly appreciated!

SortByColumns(
Search(
If(
//This is all service and all types
Dropdown1.Selected.Value ="All" And Dropdown1_1.Selected.Value="All" , 'RRG',
// This is for all services and inpatient type
Dropdown1.Selected.Value="All"And Dropdown1_1.Selected.Value="Inpatient",
Filter('RRG',TYPE= "Inpatient" && TYPE="Both"),
// This is for all services and Outpatient type
Dropdown1.Selected.Value="All"And Dropdown1_1.Selected.Value="Outpatient",
Filter('RRG',TYPE="Outpatient" && TYPE="Both"),
// This is for all services and selected type not outpatient or inpatient
Dropdown1.Selected.Value="All"And Dropdown1_1.Selected.Value<>"All" And Dropdown1_1.Selected.Value<>"Outpatient" And Dropdown1_1.Selected.Value<>"Inpatient",
Filter('RRG',TYPE= Dropdown1_1.Selected.Value),
// This is for selected services and all types
Dropdown1.Selected.Value <> "All" And Dropdown1_1.Selected.Value="All",
Filter('RRG','Service Location'= Dropdown1.Selected.Value),
//This is for selected services and Inpatient selected
Dropdown1.Selected.Value <> "All" And Dropdown1_1.Selected.Value="Inpatient",
Filter('RRG','Service Location'= Dropdown1.Selected.Value And TYPE="Inpatient" && TYPE="Both"),
// This is for selected services and Outpatient selected
Dropdown1.Selected.Value <> "All" And Dropdown1_1. Selected. Value="Outpatient",
Filter('RRG','Service Location'= Dropdown1.Selected. Value And TYPE="Outpatient" && TYPE="Both"),
// This is for selected services and selected types not inpatient or outpatient
Dropdown1.Selected.Value <> "All" And Dropdown1_1.Selected.Value<>"All" And Dropdown1_1.Selected.Value<>"Outpatient" And Dropdown1_1.Selected.Value<>"Inpatient",
Filter('RRG'= Dropdown1.Selected.Value And TYPE= Dropdown1_1.Selected.Value)),
// This is the end of the search sentence
TextSearchBox1.Text,"Title","KeyWords"),
"Title",If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))