TEAM PowerApp , patch combobox to sharelist from collection.

(0) Share

Report

Posted on by cordycep

HI: I have read a few related solution with comboboc attach to the list, but I cant get it working.

I was able to save the combobox value in collection using Unit Value having "Each" assigned.

THe Unit is also the column in sharelist which is a CHOICE .

ForAll(ExpenseCollect, Patch('Order Item', Defaults('Order Item'), {Title: Title,'Item Code': ItemCode, Quantity: Quantity, Unit: Value(Unit), Desc, CostObject: CostObj, Price: Price, BudgetItem: BudgetItem, Extension2: Extension, OrderID: Form2.LastSubmit.ID}));

here is my Collect command for each itemize expense items, which seems to be valid.

Collect(ExpenseCollect, {Title: "", ItemCode: txtItemCode.Value, Quantity: txtQuantiy.Value, Unit: ComboBox3.SelectedItems, Desc: txtDesc.Value, CostObj: txtObjectnum.Value, Price: txtPrice.Value, BudgetItem: txtBudget.Value, Extension: txtExtension.Value});

As an alternative, I also tried creating a Units type TEST column in the sharelist to store combo result but could not get it working either. Also tried Unit: ComboBox3.Selected in Patch but not working. How do I reference to the collection combo Unit Value for patching? thanks screen name is CreateOrder

DISEProcurement10...

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @cordycep,

Could you please tell me that how you set the Items property of the ComboBox?

Since it is a Choice(make sure it allows multi select in your list), you should have populate the ComboBox using Choices(List.Unit).

I have a test and the situation is confirmed on my side, please check for reference:

1). The Unit column is my list is named as Choice

2). I set the Choice column in my List with allowing multi select, which is important.

3). I set the ComboBox Items property with the following formula:

Choices(Stage.Choice)//Stage is my list name

4). I write the Patch() as below:

ForAll(ExpenseCollect,Patch(Stage,Defaults(Stage),{Title:Title,Item:Item,Choice:Unit}))//Title and Item is column from the collection

5). Here is the collection and testing result:
cordycep 80 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you for your help, I set the multipleslection and it work fine.