Hi,
We are trying to create a PowerApp form for our SharePoint list and we are facing the below issue.
There are two text fields in SharePoint list , Category and Sub-Category. When i create the powerapps form I converted this to a combo box. because, we want to create a new item when the data is not already present in the field if its already exist user can select from the dropdown list.
I am able to create the new record, I can either select from the combo box list or I can type a new value and I can save. The problem I am facing is , When i try to edit a field value other field value is getting deleted.
Ex: creating a new record with values Category = Test and Sub-Category= Test 1, if i try to update the Sub-Category value the Category value is getting deleted.
These are my codes:
Item :- [listname].Category
Datacard Update :-
If(
IsBlank(ComboBox1_1.Selected.Category),
ComboBox1_1.SearchText,
ComboBox1_1.Selected.Category
)
Combobox Defaultselected items:-
If(
SharePointForm1.Mode = FormMode.New,
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Value: ""
},
{ /* <-- Modify here, type a record value rather than a Text value */
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Value: ThisItem.Category
}
)
Can anyone please help on this ? Appreciate your help
Thanks
