Update Dataverse Table from combo box in gallery

(0) Share

Report

Posted on by fero

I have the following elements in a Power Apps canvas:

A collection called colUsersList that contains one column (Value) with the following items: {"","Peter Smith", "Joe Perez"}
A gallery connected to a Dataverse Table called 'Dataverse-ActiveTable' with two columns: "Table-comment" and "Table-User"
Inside the gallery I have a text box (txt_comment) and a combo box(combo_user)--only one item can be selected.
The combo box is populated from the colUsersList.
To patch the value on the text box I use the following in the OnChange property:

Patch('Dataverse-ActiveTable',ThisItem,{'Table-comment':txt_comment.Text})

6. To patch the value from the combo box, I use the following in the OnChange property:

Patch('Dataverse-ActiveTable',ThisItem,{'Table-comment':Concat(ComboBox1.SelectedItems,"")})

My questions are:

1. When I change the value in the text box, the table is updated correctly and the comment displayed on the text box. But when the value changes in the combo box, the user name flashes for a second and then disappears. The value on the table is not updated. What am I doing wrong?

2. How do I update the DefaultSelectedItems in this case?

Categories:

I have the same question (0)

All responses (2)

Answers (1)

Join the conversation

Helpful resources