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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Florida712 ,

Please try:

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

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

Florida712 80 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No