New or update latest record

(0) Share

Report

Posted on by fatimaandrea

113

Hi,

I have a dataverse table where I have an unique ID with the following form: Date+Name.

Everytime, an user clicks on a button on my app, I got the data with the following patch:

Patch('SAB cout projet';
Defaults('SAB cout projet');
{'Month and year': Text(ComboBoxPMois_1.Selected.Result)};
{Month: TitleMois.Text};
{Year: TitleYear.Text};
{Date: GalleryDateMasque.Selected.Date};
{'Total month': Sum ((Sum(GalleryDataBudgetR.AllItems; BodySalaire.Text)); (Sum(BodyLicencesPVPA)); (Sum(BodyLicencePVJ)); (Sum(BodyLicencesPVC)); (Sum(BodyLicencesPVPB)); (Sum(BodyAchats)); (Sum(BodyDeplacements)))};
{Salaire: Sum ((Sum(GalleryDataBudgetR.AllItems; BodySalaire.Text)))};
{Achats: Sum ((Sum(GalleryDataBudgetR.AllItems; BodyAchats.Text)))};
{Deplacements: Sum ((Sum(GalleryDataBudgetR.AllItems; BodyDeplacements.Text)))};
{Licences: Sum ((Sum(BodyLicencesPVPA)); (Sum(BodyLicencePVJ)); (Sum(BodyLicencesPVC)); (Sum(BodyLicencesPVPB)); (Sum(BodyAchats)); (Sum(BodyDeplacements)))};
{Projet:ComboBoxVProjets.Selected.Result};
{ID: Text(ComboBoxPMois_1.Selected.Result) & "-" & ComboBoxVProjets.Selected.Result})

But I will like to have the possibility to keep the latest record in case the row has the same ID. I tried by modifying the business rules and by going on the admin center. And I even activated the detection of the duplicate rows but I'll like to have an update or create button instead of that options.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi

You could fetch the most recently created record before patching to Dataverse:

First(Sort('SAB cout projet', 'Created On', Descending))

This function can then be used to check whether the id would be the same as the one that is about to be created.

Was this reply helpful? Yes No
fatimaandrea 113 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks for your answer @LaurensM . What I want is to create or update records. In case, an user registers a new record, I want to keep the one they're about to create and delete the latest record.
In case the ID is a new one, I want to save the data

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Is updating the previous one also a possibility instead of create & delete?
With the code below you will update if the IDs match, otherwise you will add a new record.

If( First(Sort('SAB cout projet', 'Created On', Descending)).ID = YourNewID, Patch('SAB cout projet', LookUp('SAB cout projet', ID = YourNewID), {your fields}), Patch('SAB cout projet', Defaults('SAB cout projet'), {your fields}) )

I hope this helps!

Was this reply helpful? Yes No
fatimaandrea 113 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much ! That works !

Was this reply helpful? Yes No