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)

v-bofeng-msft on at

Like (0)

Report
Hi @Florida712 ,

Please try:

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

Best Regards,

Bof

Was this reply helpful? Yes No
Verified answer

Florida712 78 on at

Like (0)

Report

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