Filter of Concated Text with In - 100 block vs 1100 block

(0) Share

Report

Posted on by Florida712

Hi,
I am running into a filtering issue with my Gallery Items.

I have a column "Destination", the values (text string) come from a multi-select combobox and are patched as

Upper(Concat('dcvcmbDestination-NR'.SelectedItems, Name & ","))

e.g.

1) 100 block,

2) 100 block, 200 block

3) 1200 block

When I am now filtering the archived records based on "Destination" with the filter criteria coming from a combobox single select.
Filter: 200 block (bring back all records where i have 200 block in my Destination column)

Results based on the 3 example above:
2) 100 block, 200 block (--> as expected)
3) 1200 block (--> 1200 block - the filter finds and returns the 200 block string from 1200 block, whereas I only want to return "exact matches within the complete string)
For this example the filtered result should only be
2) 100 block, 200 block

Is this possible? How? I may just not know the correct command.

Thanks a lot

All responses (2)

Answers (1)

Verified answer

Florida712 78 on at

Like (0)

Report

Re: Filter of Concated Text with In - 100 block vs 1100 block

Thank you Bof, that did solve my issue. BUT now I am running into the delegation issue.
I am using Dataverse and the table has about 50000 records, growing about 30000 every year.

Rather than not getting all results I may be better off getting too many and including 1200 in the 200 results, though I do like your solution a lot and will keep it in mind. I may rename 200 to 0200 and resolve it that way.
v-bofeng-msft on at

Like (0)

Report
Re: Filter of Concated Text with In - 100 block vs 1100 block

Hi @Florida712 ,

Please try:

"200 block" in Split(Destination,",")

Best Regards,

Bof