Collect specific record

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello All,

I am trying to do what I was hoping would be simple, which is to add a specific data source record to a collection.

With that said, is there a way to grab an entire specific record and add it to a collection?

Any help would be appreciated.

Thank you,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Edwin-Abdalian 641 on at

Like
a
(1)

Report
Copy link

Link copied!
yes, absolutely.
if you want to get one specific record into a collection, use lookup on your datasource to get only 1 record
ClearCollect(ColYourRecord, Lookup('YourDataSource', condition such as ID= Textbox1.Text))
This will return only 1 record.

if you want to get records that match a certain criteria and then insert them into a collection, use Filter on your datasource to get only those records
ClearCollect(ColYourRecord, Filter('YourDataSource', condition such as ID= Textbox1.Text))
this will return all the records that have ID= Textbox1.Text
--------------------------------------------------------------------
Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!

Was this reply helpful? Yes No
v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Did you mean that you already have a collection exists and you want to add one record from another data source to this collection?

If so, then the formula should be something like:

Collect(CollectionName,Item)

Item should be the record that you want to add to the collection. For example:

Collect(CollectionName,Last(List1))

This would add the last record in List1 data source to the collection.

Regards,

Mona

Regards,

Mona

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

Like
a
(0)

Report
Copy link

Link copied!

Thank you sir, I was very close but you filled in the missing piece for me.

Was this reply helpful? Yes No