Answered

to reduce the patch function code

(0) Share

Report

Posted on by Max_Wang

Hello there,

In the save button, I'm using 4 Patch functions, 2 for new and updated actions in data source, and rest 2 for new and updated actions in collection. I have to repeat the codes 4 times. With this code, I can create new or update record successfully.

Now, I try to reduce the code, to set the updated data into a variable, then replace the code with variable. But I got following error:

Below is the variable data.

Any idea to improved is appreciated. Thanks.

Max

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Max_Wang ,

You can update in your Collection then pass the collection to Patch function directly.
YouTube Link
Note: If you are updating Items then you need to specific its Unique ID/GUID of the Records in collection.

So your sequence will be
//Create/Update Collection //Patch using Collection

Hope this helps

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@Max_Wang ,

I suppose that your datasource (Requests) is a Sharepoint list and colRequests is a collection with a similar structure as Requests. Here is my proposal.

Patch( colRequests, Coalesce(LookUp(colRequests,ID=SampleGallery.Selected.ID),Defaults(colRequests)), Patch( Requests, Coalesce(LookUp(Requests,ID=SampleGallery.Selected.ID),Defaults(colRequests)), { item to be created / updated } ) )

Hope it helps !

Was this reply helpful? Yes No
Max_Wang 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you both!

Was this reply helpful? Yes No