Patch duplicating "Choice/Combo Box" value.

[DarkStranger]

I have a gallery that displays a collection.  I am then trying to patch the collection and text value patches work as correct and only patch the edited row, but the "Choice\ComboBox" seems to duplicate to all rows.  Why is it doing this and how can I correct?

The patch code is...

Patch(
PatchingInventory,
ThisItem,
{
Floor_x0020_Port_x0020_No_x002e_: Floor_Port_No_Gallery_Input_1.Text,
Equipment_x0020_Type:Equipment_Type_Gallery_Input_1.Selected.Result,
Comments: Comment_Gallery_Input_1.Text
}
)

Thanks in advance

[CNT]

@DarkStranger what is the Items and default property for Equipment_Type_Gallery_Input_1?

[DarkStranger]

The item is: Distinct(PatchingInventory,Equipment_x0020_Type)

The Default is: ThisItem.Equipment_x0020_Type

[CNT]

@DarkStranger try changing the item to Choices((PatchingInventory.Equipment_x0020_Type)

[DarkStranger]

I tried both..

Choices(PatchingInventory.Equipment_x0020_Type)

Choices(PatchingInventory,Equipment_x0020_Type)

and both gave a "Red" error and the dropdown wasn't populated...

[CNT]

@DarkStranger Isn't Equipment_x0020_Type a Choice column in your SP list? Do you see any error in the Items property?

[DarkStranger]

The source data is a SP List, but due to having over 2000 rows, I have pulled in the SP List into a collection (PatchingInventory) and then the gallery is looking at the collection.  I am trying to update the collection.

Yes, at the source data (SP), Equipment_x0020_Type is a choice type.  

Hope that makes sense.

[CNT]

@DarkStranger Change to Choices(yourSPList.Equipment_x0020_Type) replace yourSPList with the actual name of your Share Pont list where the choice column is. Hope that helps

[DarkStranger]

Just want to check that we are working on the same issue.  The issue isn't that the dropdown box not displaying the choice items as it is with the code "Distinct(PatchingInventory,Equipment_x0020_Type)", the issue is that when I patch as single row, it patches a single row for "Floor Port No" & "Comments", but the "Equipment Type" patches every row.

 

[CNT]

@DarkStranger Using choices is the best way to get all the choices available for a column. When you say "patches every row." can you tell me when do new record get added to the gallery? Do you have a certain number of records that you have at start? Please explain a little more. Thanks.