Answered

UPDATE COLUMN WITH COMBOX

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Buen día a todos, disculpen

quisiera saber si puedo modificar el valor de el campo de varios elementos seleccionados en un ComboBox2.

La columna se llama SAP ID y quiero actualizarlo con el valor que yo seleccione en dos listas desplegables Dropdown2 y Dropdown3 es decir concatenar los valores.

Categories:

Building Power Apps

All responses (4)

Answers (2)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous,

What is the column type of this 'SAP ID'? LookUp or Choice? Is it allowing multi select?

Could you please share a bit more about the ComboBox2 and Dropdown2 and Dropdown3?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have 2 dropdowns.
I want to take both values to update the items selects in my ComboBox2_1.
I have a label with Concatenate(Dropdown2.Selected.Value;Dropdown3.Selected.Value)
Then I want to take this value to update the column UBICACIÓN of my list UBICACIONEXPEDIENTES (only the items selected in ComboBox2_1)
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous，

Do you want to update the selected items with the concatenated value?

I want to confirm with you that if you want to append this concatenated value or just replace previous two items with this concatenated value?

Is there a primary key to capture this record?

To replace previous two items with this concatenated value, you could try as below:

Patch(UBICACIONEXPEDIENTES ,Defaults(UBICACIONEXPEDIENTES),{UBICACIÓN:Table({Value:Concatenate(Dropdown2.Selected.Value;Dropdown3.Selected.Value)})})
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanksss, I used this
ForAll(
Filter(UBICACIONEXPEDIENTES; ID in ComboBox2_1.SelectedItems.ID);
Patch(
UBICACIONEXPEDIENTES;
{ ID: ID }; // Identificador único del elemento a actualizar
{ UBICACIÓN: Label17.Text }
)
);;
Notify("Columna UBICACIÓN actualizada para elementos seleccionados"; NotificationType.Success);;
Reset(ComboBox2_1)

But now I want to move all the items selected with my ComboBox2_1 to another list and also change the value of the column UBICACIÓN in the destiny list