Edit a Record in a colletion

(0) Share

Report

Posted on by Eric McKinney

173

Powerapps Community

I am struggling with something that to seems pretty easy to do, for some reason i am not finding what I need to make this happen.

I am collecting records from a form into a collection, i then have a gallery to review the data in those records, on the card in the gallery i have an icon to edit that record which navigates them to an edit form, the form has the item set to the galleryname.selected. All this works to this point, however this is where I am stumped, what action do i need to use on a button to basically send it back to the collection with the edits that are made to the record . Do I run a collect or patch? i don't think submit form is what I want because it will submit it to the datasource, i want to review it again in the gallery before doing that, along with any other records.

Looking for hlep, i appreciate it.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Paul_C Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

It sounds like Update() or UpdateIf() may be what you're looking for.
Take a look at this: https://powerapps.microsoft.com/en-us/tutorials/function-update-updateif/

See how that goes and let us know if you get stuck on anything!

Was this reply helpful? Yes No
Verified answer

hpkeong 2,944 on at

Like (4)

Report
Copy link

Link copied!

Hi

Collection and Patch basically having the same formual, except Collection for temporary storage whereas Patch is permanently saved into a DS.

Since you can edit the gallery.selected items, then you can then UpdateIf the selected records

@Paul_C has hinted that https://powerapps.microsoft.com/en-us/tutorials/function-update-updateif/ is the right place for you.
Update and UpdateIF has different actions. Please read careully so that you can use the right formula.

I share a screenshot using UpDateIF , and compare to the selected Name = Gallery.Selected.Name to request which to be repalced.

Hope this helps.
Have a nice day.

Was this reply helpful? Yes No
Eric McKinney 173 on at

Like (1)

Report
Copy link

Link copied!

@hpkeong @Paul_C

Paul C, updateif was what i needed, combined with hpkeong giving me that screenshot on the updateif based on name. What I had to do in addition to what you told me, was add a record id field that i could reference since the collection did not have one by default. I thank you very much, this one is solved!

Was this reply helpful? Yes No
PytByt 943 on at

Like (0)

Report
Copy link

Link copied!

Hi @hpkeong

I have the similiar problem,
Can i have take a look the formula that you're using for edit and update the collection item record please?

thanks,
pytbyt

Was this reply helpful? Yes No
WebWmn53 on at

Like (0)

Report
Copy link

Link copied!

I would also like to see the formula with the added ID.
thanks in advance

Was this reply helpful? Yes No