filter a dropdown or collection by multiple conditions

(0) Share

Report

Posted on by Questionasking

116

Hi, i have a dropdown that i wish to filter by about a dozen different fields

for example i use a collection to create a blank value as per below

If(
 Connection.Connected,
 ClearCollect(
 colAssetReg,
 {Result: ""}
 );
 Collect(
 colAssetReg,
 Distinct(
 'Asset Register',
 Asset
 )
 )
)

i then use items colAssetReg with result to show these however, there is another field in the source AssetsLIST called AssetTYPE (choice column) that contains all sorts of types of the field asset i wish to filter for example

Asset	AssetType	AssetID
ass1	gear1	11
ass2	gear1	22
ass3	gear2	33
ass4	gear2	44
as5	gear3	55

so say for example i wish the dropdown to only show the assets with assettype gear1 and gear 2? whilst keeping my blank in the clearcollect formula?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Questionasking ,

This should do the job

If( Connection.Connected, ClearCollect( colAssetReg, {Result: ""} ); Collect( colAssetReg, Distinct( Filter( 'Asset Register', AssetType="gear1" || AssetType="gear2" ), Asset ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No