Unanswered

add new row in excel table

(0) Share

Report

Posted on by NicoloMantecca

Hi everyone,
I need help.
I have linked a table of an excel sheet as a database.
I would like to create a row in the table by entering the data in the dedicated screen and clicking on save(Attachment1).
The value in the "Number" field is given by the maximum value +1 from the number column (in excel) and date value is Today().

All the dropdown fields are linked from different tables in the same excel file, but different tables.

i've tried this formula, but it does't work.

Patch(Tab_Riepilogo;Defaults(Tab_Riepilogo);{Numero:Label10.Text;Data:Date.Select;OGGETTO:TextInput_Oggetto;Tipologia:Dropdown_Tipologia;Cliente:Dropdown_Cliente;Compilatore:Dropdown_Compilatore;Produttore:Dropdown_Produttore;Settore:Dropdown_Settore;Dettagli:TextInput_Dettagli;'Rif. Precedenti':TextInput_RifPrecedenti;Risposta:TextInput_Risposta;'Aperta da':Today();'Numero Archiviazione':"0";'Numero Cassetto':"0"})

thank you so much!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NicoloMantecca

Patch(Tab_Riepilogo;Defaults(Tab_Riepilogo); {Numero:First(Sort(Tab_Riepilogo,Numero,Descending)).Numero+1,; Data:Today(); OGGETTO:TextInput_Oggetto;Tipologia:Dropdown_Tipologia;Cliente:Dropdown_Cliente;Compilatore:Dropdown_Compilatore;Produttore:Dropdown_Produttore;Settore:Dropdown_Settore;Dettagli:TextInput_Dettagli;'Rif. Precedenti':TextInput_RifPrecedenti;Risposta:TextInput_Risposta;'Aperta da':Today();'Numero Archiviazione':"0";'Numero Cassetto':"0"})

Was this reply helpful? Yes No
NicoloMantecca 5 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you for your help but it doesn't write anything in the table.

it sais "the operation first isn't supported by this contenitor"
thank you so much

Was this reply helpful? Yes No