web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Help with Does Not Con...

Power Apps

Answered

Help with Does Not Contain in Filter Query

(0) Share

Report

Report

Posted on by olsen9

378

Looking to pull only ID's that do not have a "." in them. I have a column in which subtasks generate a Custom ID 1.1, 1.2 etc

I came up with this but it doesn't work in my filter

Filter('SP List',Custom_ID=SharePointIntegration.Selected.Custom_ID,!("." in Custom_ID))

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Ricardo_Costa 150 on at

Like (0)

Report

you can try only this part

Filter('SP List',!("." in Custom_ID))

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (0)

Report
If you are looking to filter it by two things, like in your example you should write it like this

Filter('SP List', And(Custom_ID=SharePointIntegration.Selected.Custom_ID, Not("." in Custom_ID)))

Since your Datasource is a SPList though, Not and In are NOT DELEGABLE which means if your list grows over 2,000 items your app will not be able to handle the filter anymore.

Was this reply helpful? Yes No

Join the conversation