Unanswered

Duplicate entry for key primary MySQL

(0) Share

Report

Posted on by Ing_Jesus_Lopez

Hi, i have a issue when i patch into forall function. My datasource is Mysql this database is relational and i use a gallery with checkbox, in this checkbox show a skill description, so when the user press the boton i should insert all checked value but, i use patch function into forall the server show error. My code is next:

ForAll(Checked;Patch('DB_DEV_SIC.vco_prospectohabilidades';Defaults('DB_DEV_SIC.vco_prospectohabilidades');{idhabilidadtecnologica:LookUp('DB_DEV_SIC.vcc_habilidadestecnologicas';Descripcion = Checkbox2.Text;idhabilidadestecnologicas) ;idprospecto:v_idprospecto;idprospectohabilidades: v_idprospectohabilidades}))

The error is "Duplicate entry '1' for key primary".

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ing_Jesus_Lopez

To start, your formula has the ForAll backward. You are trying to use it like a ForLoop in some development language - which PowerApps is not. ForAll is a function that returns a table of records based on your iteration table and record schema.

It is more efficient to use the function as intended and will provide better performance.

What is the name of your primary key column? And, what is "Checked" in your formula? If it is some sort of collection, what is the definition of the collection?
Ing_Jesus_Lopez 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello RandyHayes, my table contains 3 fields, idprospectohabilidades, idprospecto and idhabilidades. My primary key is idprospectohabilidades. I created a collection on start app with all skills description like Qlik View, Qlik Sense etc, this collection i called "HabilidadesTecnologicas". In my gallery put a checkbox and in the items option, i did reference to collection. After that in my button i need to insert each checkbox checked in the table in mysql with idprospectohabilidades(PK), idprospecto(FK) and idhabilidades(FK).

Collection:
Gallery
OnCheck Checkbox. I created a new collection with all checkbox checked.

Text of the CheckBox
Button Onselect