Filter Gallery items where Column contains comma seperated values

(0) Share

Report

Posted on by asif082

Hi All,

I am trying to filter gallery where I have a column in SQL which contains values like "File,List,First Nation" etc.

So, if Flag column contains "File" it should not show data.

Below is the formula currently using.

SortByColumns(
Search(
Filter(
vw_MasterBooking,
Location = ddlHomeCourtLocation_2.Selected.Court_Name,

ddlHomeCaseType_2.Selected.Value = "All" || Hearing_Type = ddlHomeCaseType_2.Selected.Value,
Booking_date_int >= Value(
Text(
dteHomeStartDate_2.SelectedDate,
"[$-en-US]yyyymmdd"
)
) && Booking_date_int <= Value(
Text(
dteHomeEndDate_2.SelectedDate,
"[$-en-US]yyyymmdd"
)
),
ddlHomeListType_2.Selected.Value = "All" || List_Type = ddlHomeListType_2.Selected.Value

),
txtDashdboardSearch_2.Text,
"case_number"
),
"Status",
SortOrder.Ascending,
"Booking_date_int",
SortOrder.Ascending
)

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 154,928 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @asif082 ,

I am not totally clear here, but if you simply want to look for the string "File" anywhere in the text field Flag, then

SortByColumns( Search( Filter( vw_MasterBooking, Location = ddlHomeCourtLocation_2.Selected.Court_Name, ddlHomeCaseType_2.Selected.Value = "All" || Hearing_Type = ddlHomeCaseType_2.Selected.Value, Booking_date_int >= Value( Text( dteHomeStartDate_2.SelectedDate, "[$-en-US]yyyymmdd" ) ) && Booking_date_int <= Value( Text( dteHomeEndDate_2.SelectedDate, "[$-en-US]yyyymmdd" ) ), ddlHomeListType_2.Selected.Value = "All" || List_Type = ddlHomeListType_2.Selected.Value, "File" in Flag ), txtDashdboardSearch_2.Text, "case_number" ), "Status", SortOrder.Ascending, "Booking_date_int", SortOrder.Ascending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
asif082 29 on at

Like (0)

Report
Copy link

Link copied!

thanks @WarrenBelz yeah this worked i have changed it to Not("File" in Flag) for my requirement.

Was this reply helpful? Yes No