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

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

timl 36,393 Super User 2025 Season 2 on at

Like (0)

Report
@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" ) )

Was this reply helpful? Yes No
NicoPet 29 on at

Like (0)

Report

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

Was this reply helpful? Yes No