Power Platform Community Forum Thread Details

Hi,

Im making an app to register quality reports. Im using this video (https://www.youtube.com/watch?v=wI6SHGQ9ATg&) as a guide to create a editable grid table.

The problem is when im trying to patch my collection into my datasource, using a buttom with the following code:

//distribuicao -> my table in sql server
//colgrid -> collection

Patch(
 distribuicao/*;
 colgrid)
;;
Select(button_ClearCollect)
;;
Set(varGridEdit;!varGridEdit)

The error is showed when i run the app and try to change informations on a row.

Additional information:

Im using Onpremise as a gateway to connect with my db;
Theres a PK registered on sssms with auto increment. The PK is not listed on the grid;
On the grid im using the following code OnSelect:

Patch(colgrid;
 ThisItem;
 {ID:Value(id_card_value.Text);
 SKU:sku_card_value.Text;
 Amostra:amostra_card_value.Text;
 Produto:produto_card_value;
 'Qtd Recebida':lote_card_value.Text;
 Reprovado:reprovado_card_value.Text;
 'Qtd Liberada':saldo_card_value.Text}
)

Categories:

Building Power Apps