Power Platform Community Forum Thread Details

I have ComboBox inside my form which is referencing choice field of sharepoint. When choice is not available in the combobox whatever you write in the search box of combobox will be added to choices in sharepoint.

Above is my form. Below is Update property of Category:

If(
 !IsBlank(DataCardValue6.Selected),
 DataCardValue6.Selected,
 If(
 !IsBlank(DataCardValue6.SearchText),
 {
 Value: DataCardValue6.SearchText,
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
 },
 Blank()
 )
)

This all works perfectly.

Problem is. I have another list where i enter data using gallery. I want to achieve same thing in that. But, i don't know how to approach this. Below is the picture of gallery where i enter data. On Click of Add button PowerApps will take data from above dropdowns and pre filled data. User will only have to select month and Budgt.

Each of this control have onChange property which stores their value into collection. And finally on save button it will patch that collection to sharepoint.

Code on OnChange:

If(
 ThisItem.ID in colBudgetTracker.ID,
 Update(
 colBudgetTracker,
 LookUp(
 colBudgetTracker,
 ID = ThisItem.ID
 ),
 {
 Company: Dropdown1_2.Selected,
 OfficeLocation: Dropdown1_3.Selected,
 Year: Dropdown1_4.Selected,
 ID: ThisItem.ID,
 Month: Dropdown1_11.Selected,
 PlannedExpense: Value(TextInput1_1.Text),
 Rate:Value(TextInput1_7.Text)
 }
 ),
 Collect(
 colBudgetTracker,
 {
 Company: Dropdown1_2.Selected,
 OfficeLocation: Dropdown1_3.Selected,
 Year: Dropdown1_4.Selected,
 ID: ThisItem.ID,
 Month: Dropdown1_11.Selected,
 PlannedExpense: Value(TextInput1_1.Text),
 Rate:Value(TextInput1_7.Text)
 }
 )
)

Categories:

Building Power Apps