Filtering collection from SQL table

(0) Share

Report

Posted on by NicoPet

Hello community!

I was wondering if it is possible to make a filtered collection from SQL table, where i want to filter out specific records i am not interested in?

Currently i have two collections. One where i retrieve two columns from 'Dim.Company' table, "CompanyKey" and "CompanyName" which gives me a list of 25 rows. The second collection adds a column where it splits CompanyKey and extracts the first part of each record. (this is used so i can make a cascading dropdown)

This is fine but i´d like to not be collecting two specific records from CompanyKey. Is there a way to filter that out when making my collection on "OnStart"?

Hope someone can help me on this 🙂

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@NicoPet

This is the formula that will exclude company keys "ABC" and "XYZ".

ClearCollect(CompanyCollectionTest, ({CompanyName:"All"} ), ShowColumns( Filter('Dim.Company'),!(StartsWith(CompanyKey,"ABC") || StartsWith(CompanyKey,"XYZ") )), "CompanyKey", "CompanyName" ) )
NicoPet 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks you so much! it works perfectly. I am so happy