@WarrenBelz
Perhaps explaining the situation may put it in a better perspective. It is a follow-up to our previous discussion on a different thread.
PowerApp Form:
Choices([@'SPList'].'Status')​
If(SharePointForm1.DisplayMode.Edit, {Title: ThisItem.field_1})
- cboComboBox1.DefaultSelectedItems
If(SharePointForm1.DisplayMode.Edit, {Title: ThisItem.field_2})
SortByColumns(Filter(SPList2, SPField2 = cboComboBox1.Selected.Title),"Title",SortOrder.Ascending)
- cboComboBox2.DefaultSelectedItems
If(SharePointForm1.DisplayMode.Edit, {Title: ThisItem.SPField2})
If(
//both false
And(
! chkCheckBox1.Value,
! chkCheckBox2.Value
),
Concatenate(
Trim(cboComboBox1.Selected.field_1),
" " ,
Trim(txtTextBox2.Text)
),
//1 true, 2 false
And(
chkCheckBox1.Value,
! chkCheckBox2.Value
),
Concatenate(
Trim(cboComboBox1.Selected.field_1), " " ,
Trim(cboComboBox2.Selected.field_4), " " ,
Trim(txtTextBox2.Text)
),
//1 false, 2 true
And(
! chkCheckBox1.Value,
chkCheckBox2.Value
),
Concatenate(
Trim(cboComboBox1.Selected.field_1), " " ,
Upper(txtTextBox1.Text) , " " ,
Trim(txtTextBox2.Text)
),
//else, so both true
Concatenate(
Trim(cboComboBox1.Selected.field_1), " " ,
Trim(cboComboBox2.Selected.field_4), " " ,
Upper(txtTextBox1.Text) , " " ,
Trim(txtTextBox2.Text)
)
)
ISSUE #1 -
When I hit NEW in SharePoint, all the fields empty out. When I select an item in the SharePoint List and hit "EDIT", cboComboBox1 and cboComboBox2 are populated correctly. However, their Selected values are no longer being populated in txtTextBox3.Default.
ISSUE #2 -
I don't know if it is because of ISSUE #1, or something else, but after hitting EDIT, then Save, instead of updating the existing Item, it creates a new item in the list.
