You’re offline. This is a read only version of the page.
102
I have this formula that is working fine , but I need to include a filter based on status
current formula is
If(IsBlank(search_rep_text_1.Text),
SortByColumns(Filter(Master_List,
StartsWith(Title,search_carrier_code_6.Text),
StartsWith(field_1,search_carrier_name_6.Text),
StartsWith(field_4,search_region_1.Text),
StartsWith(SRRep,search_sr_rep_2.Text),
StartsWith(field_5,search_country_1.Text)), "field_1", Ascending ),
With(
{varFilter:Filter(Master_Proflies_Collection, field_10 = search_rep_text_1.Text).Title},
SortByColumns(
Filter(
Master_List,
StartsWith(Title,search_carrier_code_6.Text),
StartsWith(field_1,search_carrier_name_6.Text),
StartsWith(field_4,search_region_1.Text),
StartsWith(field_5,search_country_1.Text),
StartsWith(SRRep,search_sr_rep_2.Text),
Title in varFilter
),
"field_1",
Ascending
)
))
what I attempted to create was this code but I can not get it to work , this is the line causing me issue
{varFilter:Filter(Master_Proflies_Collection, field_10 = search_rep_text_1.Text).Title && Status = "Inactive").Title},
If(IsBlank(search_rep_text_1.Text),
With(
{varFilter:Filter(Master_Proflies_Collection, Status = "Inactive").Title},
SortByColumns(
Filter(
Master_List,
StartsWith(Title,search_carrier_code_6.Text),
StartsWith(field_1,search_carrier_name_6.Text),
StartsWith(field_4,search_region_1.Text),
StartsWith(field_5,search_country_1.Text),
StartsWith(SRRep,search_sr_rep_2.Text),
Title in varFilter
),
"field_1",
Ascending)),
With(
{varFilter:Filter(Master_Proflies_Collection, field_10 = search_rep_text_1.Text).Title && Status = "Inactive").Title},
SortByColumns(
Filter(
Master_List,
StartsWith(Title,search_carrier_code_6.Text),
StartsWith(field_1,search_carrier_name_6.Text),
StartsWith(field_4,search_region_1.Text),
StartsWith(field_5,search_country_1.Text),
StartsWith(SRRep,search_sr_rep_2.Text),
Title in varFilter
),
"field_1",
Ascending
)
))
Share
Report
All responses (
Answers (
