Unanswered

filter query - item name is in short term but filtering value is in long term

(0) Share

Report

Posted on by AdrianChang

Is there any solution to escape the problem if the filtering value is using long term but the data is in short term?
for example, I filter it by name eq 'Hong Kong Limited', and there is the record of 'HK Limited' or 'H.K. Limited' only. However, it is the record I would like to get.

Is there any suggestion? Please help.

Categories:

General topics

All responses (3)

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AdrianChang ,

My SharePoint List:

Please use the 'Filter_array' control to filter out item records containing the three strings 'H', 'K', and 'Limited'.

I did a test for your reference.

In my scenario:

@And(contains(item()?['Company'], 'H'),contains(item()?['Company'], 'K'),contains(item()?['Company'], 'Limited')) length(body('Filter_array'))

Best Regards,

Sunshine Gu
AdrianChang 53 on at

Like
a
(0)

Report
Copy link

Link copied!

I think of this too. However, If my data List have many records like 100000+ items, it maybe much slower.
v-yetonggu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AdrianChang ,

Please refer to this flow.

Company ne 'null' and( substringof('HK Limited',Company) or substringof('H.K. Limited',Company)) length(outputs('Get_items')?['body/value'])

Best Regards,

Sunshine Gu