Answered

Records not patching

(0) Share

Report

Posted on by Prav

Hi All, I have a gallery showing a list of repairs sourced from SharePoint where the manager can select to approve or decline. Technicians have been reporting that they are getting several approval emails showing the same repairs approved multiple times from the manager. I’m using an HTML text to capture the selected list and email to the assigned technician on select button. I noticed that when the manager were approving them via an iPhone only 8 out of 20 records were patched, and the gallery will show the rest. And hence, the manager had to approve them until the list is empty. Any insights why?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

leyburn19 2,157 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you share the patch code. You are collecting the list in HTML for emailing but what happens then? Is it supposed to then close those records?

Was this reply helpful? Yes No
Prav 67 on at

Like
a
(0)

Report
Copy link

Link copied!
@leyburn19

ForAll( RenameColumns( Filter( gal_Repairs.AllItems, chk_Approval.Value = true ), "ID", "ID1" ), Patch( Repairs, LookUp( Repairs, ID = ID1 ), { Status: "Approved" } ) )

Was this reply helpful? Yes No
Verified answer

leyburn19 2,157 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, I assume the patch is based on the checks being true. I probably would tackle this a different way. I would create a collection based on the checks. On the on check I would do: Collect(MyCollection,ThisItem) On the uncheck I would do Remove(Mycollection, ThisItem) Then on use the collection to make your HTML email ( I normally put that into a table)

Then on you Submit button I would do

Forall(MyCollection,Patch(Rpairs,Lookup(Repairs,ID=ID),{Status:"Approved"}) - Not sure if you will need the rename column in this as well

Then Clear the collection Clear(mycollection). If you want to keep the gallery view based on the same group you can refresh the Checkbox by using UpdateContext(vReset:true}); UpdateContext(vReset:false}) and put the vReset on the Reset to the checkbox

Was this reply helpful? Yes No