CODEWITHSUNDEEP
databasecollectionspowerapps
Ryan Lebato
Ryan Lebato

Reputation: 1

Collect based on Filter of another database - Power Apps

I need to simply create a new collection based on data that is filtered by ID from another database.

I figured this code here would work: ClearCollect(copiedData, Filter(pdarelease_line, releaseID = releaseSelection.Selected.releaseID))

However, after running, the new collection seems to leave out some data.

enter image description here

Additionally, I am certain data exists in the table I am filtering.

Upvotes: 0

Views: 3722

Answers (1)

Werner7
Werner7

Reputation: 333

You can make collections of collections or directly from filtering the data source directly. Something like this could work.

ClearCollect(
 colCopiedData, 
  Filter(
    MasterDataSourceOrCollectionToFilter, 
    releaseID in colOrDataSourceOfSecondaryFilteredList.ID
  )
);

Hope this helps.

Upvotes: 1

Related Questions