PATCH AND COLLECT FUNCTION ISSUE

[SahilVasani]

I am a new developer in power apps.

I have 2 lists; 'Product List' & 'Sub FJO'. I have 1 column in sharepoint called "product name" in the Sub FJO list (it is a lookup column which gets the data from the master list 'Product List'.

I have tried a similar approach to this article here for reference: Repeating Tables in Power Apps using SharePoint List Form 2.0 (anjcerbolles.com)

I have been trying to get the combo box to work with the collect and clear collect. 

The issue is that when i add a new row in the gallery, the combo box data for row 1 disappears. I then later have to add the values again to the combo box after adding several columns. The patch does work correctly.

Clear Collect Function:

NewForm(CreateItemForm);
ClearCollect(
colInvoice,
{
LineItem: "",
LinePrice: "",
LineQty: "",
LinePayment: false,
LineProduct: ""
}
);
Set(
SharePointFormMode,
"CreateForm"
);
Navigate(
CreateScreen,
Transition.None
)

Combo Box Items Function: 

Choices([@'FJO - Sub FJO'].ProductName)

Patch Function:

Patch(
colInvoice,
ThisItem,
{
LineItem: txtItemNameCreate.Text,
LinePrice: Value(txtPriceCreate.Text),
LineQty: Value(txtQtyCreate.Text),
LineProduct: ComboBox4.Selected.Value
}
);
Collect(
colInvoice,
{
LineItem: "",
LinePrice: "",
LineQty: "",
LinePayment: false,
LineProduct: ""
}
)

Form Submission on Success Function: 

ForAll(
CreateGalleryItems.AllItems,
If(
!IsBlank(txtItemNameCreate.Text),
Patch(
'FJO - Sub FJO',
Defaults('FJO - Sub FJO'),
{
Title: CreateItemForm.LastSubmit.Title,
'Sub FJO Number': txtItemNameCreate.Text,
'TEST COLUMN': Value(txtPriceCreate.Text),
Quantity: Value(txtQtyCreate.Text),
'Product Name': ComboBox4.Selected
}
)
)
);
ResetForm(Self);
RequestHide();

[WarrenBelz · Accepted solution]

Hi @SahilVasani ,

If I am reading this correctly, your issue is that the value does not remain in the Combo Box in the gallery. I am also assuming here that your gallery is displaying records from your collection colInvoice

Try making the DefaultSelectedItems of the ComboBox

{Value: ThisItem.LineProduct.Value}

BTW Lookup columns are not the best friend of Power Apps unless there is a good reason you are using them.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[SahilVasani]

@WarrenBelz 

I took your advise and i saw that the lookup columns are the devil of the combo box. 

Hence, i linked the combo box directly to my secondary product list and used:

{Title: ThisItem.LinePaymentMethod}

 It ended up working! Thank you for the knowledge!

[v-xiaochen-msft]

Hi @SahilVasani ,

If the issue has been resolved , please consider mark @WarrenBelz 's solution to close the case. Thanks.

Best Regards,

Wearsky