web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Make a new Collection ...

Power Apps

Unanswered

Make a new Collection based on another collection with a Filter

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

What I have: Collection called "colAmendData"

ClearCollect(colAmendData,
AddColumns(
ShowColumns(gal_AmendData_View1.AllItems,
"AUTO_ID", "SKU", "PRODUCT_DESCRIPTION", "QTY", "TARGET_GP", "TARGET_PRICE"
),
"TARGET_GP_EDIT", "",
"TARGET_PR_EDIT", ""
)
)

What I Need:

I need to create a new collection based on "colAmendData" but filter where..

"TARGET_GP_EDIT" is not Null OR "TARGET_PR_EDIT" is not Null in any given row. ?

//Filter collection code ???

ClearCollect( colFilterAmendData, Filter( colAmendData ,TARGET_GP_EDIT <> "" Or TARGET_PR_EDIT <> "" ) );

Thanks

dave

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

I usually advise against creating more and more collections as this is just more and more overhead on your app and memory, but in this case the following should provide a table that you can put into a collection:

Filter( colAmendData, !IsBlank(TARGET_GP_EDIT) || !IsBlank(TARGET_PR_EDIT) )

I hope this is helpful for you.

Join the conversation