Collect Record from combobox selection

[Connor55]

Hi!  I'm trying to collect a record from a selected record in a combobox with this:

Collect(PullSheetCollection, InventorySearch.Selected)

I have an entity called "Inventories" that's the source of a combobox "InventorySearch" - and I'm using a collection called "PullSheetCollection."

The issue, is when I run the collect function it's only collecting the record from the column that's displayed in the combobox - not the entire record.  My collection actually has all of the columns from the entity in the combobox, but the only one getting filled is the Commercial_Name column - which is what is displayed in the combobox.  

Any ideas?  

[v-xida-msft]

Hi @Connor55,

Could you please share more details about the formula you typed within the Items property of the ComboBox?

Based on the issue that you mentioned, I have made a test on my side, if you save the selected record within the ComboBox into a collection directly, only the display column and the Unique Identifier Column would be populated with proper value.

As an alternative solution, I think the LookUp function could achieve your needs. I have made a test on my side, please consider take a try with the following workaround:

Set the Items property of the ComboBox to following:

Inventories

specify the proper column as display value within the ComboBox.

Then modify your Collect formula as below:

ClearCollect(
             PullSheetCollection, 
             LookUp(Inventories, 'Unique Identifier Column' = ComboBox1.Selected.'Unique Identifier Column')
)

please consider take a try with above solution, check if the issue is solved.

Best regards,

[Connor55]

Thanks for the reply.

I have my items set to "Inventories."

See the previous replies about the lookup function. It works, but it only collects column values that have been previously referenced in the app.

[Connor55 · Accepted solution]

After some more searching I found someone with a similar problem - I think it was a new feature added.  You just have to turn off Explicit Column Selection.  

Thanks to @v-siky-msft
He solved this in the original case I found.