Patch/Update problem

(0) Share

Report

Posted on by memphis11

147

Hello everyone,

I have a problem with a patch / update function.
I would like to use a patch function to check whether a value is present in a dataverse table.

If so, the value will be updated, if not, create a new entry.
The information that should go in there comes from a gallery

I have the following patch function:

ForAll(Gallery2.AllItems;
Patch(tbl_listes;
Coalesce(LookUp(tbl_listes;

{
GUID:lb_SCHGUID.Text;
Surname:lb_SCHSurname.Text;
Name lb_SCHnameText;
Class:lb_SCHclass.Text
} Defaults(tbl_listes);
));;

My data records are transferred to the CDS,
but it is not checked whether they already exist.
I would like to filter by GUID, if present then update record,
if GUID does not exist then recreate record

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@memphis11

ForAll( Gallery2.AllItems; Patch( tbl_listes; {GUID:lb_SCHGUID.Text, Surname:lb_SCHSurname.Text; Name: lb_SCHnameText; Class:lb_SCHclass.Text } ) )

From: https://global-sharepoint.com/office-365/powerapps-power-platform/powerapps-bulk-update-using-forall-patch-function/

Was this reply helpful? Yes No
memphis11 147 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
thank you very much first...

But unfortunately the patch sets the entries twice if the GUID already exists.
So no update if the GUID is available
there is no IF loop or a lookup missing

greetings

Was this reply helpful? Yes No
memphis11 147 on at

Like
a
(0)

Report
Copy link

Link copied!

I just tried to write all values in a collection.
That works, but I still have problems with the comparison of whether the GUID is available in the CDS

Was this reply helpful? Yes No