Unanswered

hide a blank row in the items within a gallery made from a collection

(0) Share

Report

Posted on by Community Power Pla...

Hi,

In my app i have a gallery that shows a collection of Assets

SortByColumns(
 Filter(
 MyAssetColl, 
 If(
 IsBlank(HOMEASSET.Selected.Asset),
 true,
 Asset = HOMEASSET.Selected.Asset
 ) && StartsWith (
 Asset,
 TextSearchBox1.Text
 )
 ),
 "Asset",
 If(
 SortDescending1,
 Descending,
 Ascending
 )
)

When i collect the assets from the database i use the following code

ClearCollect(MyAssetColl,{Asset:""}); Collect(MyAssetColl,'Asset Register')

I need to collect the blank for the dropdown called HOMEASSET to work as i need the dropdown to display blank when the app is first started.

However i now have a blank row in the gallery, i wish for that blank gallery to be hidden?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Power Pla... on at

Like (0)

Report
Im an idiot lols,

SortByColumns( Filter( MyAssetColl, !IsBlank(Asset), If( IsBlank(HOMEASSET.Selected.Asset), true, Asset = HOMEASSET.Selected.Asset ) && StartsWith ( Asset, TextSearchBox1.Text ) ), "Asset", If( SortDescending1, Descending, Ascending ) )
All i had to do was add

!IsBlank(Asset),
arghhh stared way to hard at the screen this time

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous ,
A couple way ways of filtering this - the below should work
SortByColumns( Filter( MyAssetColl, Len(Asset)>0 && StartsWith( Asset, TextSearchBox1.Text ) ), "Asset", If( SortDescending1, Descending, Ascending ) )

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