Collect specific record

[bhayden]

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,

[Edwin-Abdalian · Accepted solution]

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!

[v-monli-msft]

Hi @bhayden ,

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

[bhayden]

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