Creating a new record

(0) Share

Report

Posted on by Utente_365_1fl

256

Hi guys,

what's wrong with this formula?

If(lista_dipendenti.Selected.reparto_anagrafica.Text <> anagrafica_reparto.Text; Patch('Dpi gestione consegne';Defaults('Dpi gestione consegne');{Titolo:"consegna_dpi";Reparto:anagrafica_reparto.Text;cambio_reparto:Now()}));;

I think there is something wrong with the Patch function: It doesn't create a new record when the values are differents.

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

timl 37,314 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Utente_365_1fl

To diagnose this, I'd add a label and set the text property to the formula below. Can you confirm that this shows true when the values are different?

(lista_dipendenti.Selected.reparto_anagrafica.Text <> anagrafica_reparto.Text)
Utente_365_1fl 256 on at

Like
a
(0)

Report
Copy link

Link copied!

I ussually do too.
in the label I wrote: If(lista_dipendenti.Selected.reparto_anagrafica.Text <> anagrafica_reparto.Text; "reparto changed"; "reparto same")
I'll show you: as I open the form page and I do not change anything the the label gives me "reparto same", if I change I get "reparto changed"
Than, If I change something i get "reparto changed": it means that the check works. That's why I think there is something wrong in the Patch()
joyle Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
The Patch expression should be working fine. I run the same expression from my end with your locale and I can confirm new records are getting added to the table.
Now, one thing that I experienced though was a delay for some controls to get refreshed. For instance, a label with the following expression.
Last(DVTable).Name // this was not refreshing in a good time fashion

Gallery sorted by 'Created on" descendent worked fine.