web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Create a Collection by...

Power Apps

Answered

Create a Collection by filtering Gallery

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello

I am trying to create a collection from a gallery (take QTY not blank or zero).

There is a lot of text boxes in my gallery but I would like to take itemno, qty and price only.

I would like to make a collection list "mylist_" list form filtering QTY

This is my formula but not working how I would like to do.

Clear(mylist_); ForAll(Filter(Gallery6.AllItems,ThisRecord.txt_qty>=0),Collect(mylist_),{itemno:txt_itemno,QTY:txt_qty,prie:txt_price}))

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Florian_Kleinz 227 on at

Like (0)

Report
Copy link

Link copied!
Hello,

I think generally it would be easier to filter directly the data source of your first gallery, but since there are reasons for not doing so I propose the following:
ClearCollect(mylist_;ForAll(Filter(Gallery6.AllItems;quantity>0);ThisRecord))
Please let me know if this helps.

Best regards
Florian

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Florian_Kleinz
Hello, thank you for your help.

I don't know why but not working,😅

Was this reply helpful? Yes No
slhangen 356 on at

Like (0)

Report
Copy link

Link copied!

Not sure if it helps but record is misspelled.

Was this reply helpful? Yes No
Verified answer

dyee4614 283 on at

Like (1)

Report
Copy link

Link copied!

I think this is the easiest way to do it.

1) Use Clear Collect instead of clearing it each time
2) Don't bother with ForAll, just use filter.
3) Use ShowColumns to drop the other columns

It will look something like this

ClearCollect(MyList_,ShowColumn(Filter(Gallery6,Qty>=0),column1,column2,column3)

Was this reply helpful? Yes No
Florian_Kleinz 227 on at

Like (1)

Report
Copy link

Link copied!
Hello if your txt_qty is a string as naming implies you need to wrap it with VALUE.

ClearCollect(mylist_;ForAll(Filter(Gallery6.AllItems;VALUE(quantity)>0);ThisRecord))

Was this reply helpful? Yes No

Join the conversation