Patching gallery items

(0) Share

Report

Posted on by ccqn

205

Hi all,

I am writing a formula to patch all items in a gallery to an existing collection using the unique identifier no. Below is the formula and it runs with no errors.

ForAll(
 Gallery5_1.AllItems As obs,
 Patch(Findings,
 LookUp(Findings,no=obs.no),
 { 
 department: Dropdown8_2.Selected.Dept,
 hod: Label37_2.Text,
 category: Dropdown6_3.Selected.Value,
 subcat: Dropdown7_3.SelectedText.Value,
 level: Radio5_3.Selected.Value,
 root: TextInput7_4.Text,
 finding: TextInput7_3.Text,
 corrective: TextInput8_3.Text,
 preventive: TextInput8_4.Text
 }
 )
);

However, the patch function is patching the same values even though I have entered different values in the gallery.

Annotation 2023-10-13 140949.png

TIA!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

v-mengmli-msft on at

Like (0)

Report
Hi @ccqn ,

What is your gallery's data source? If it's also Findings, then your current code is updating the original records. If you want to create records of items in the gallery in Findings, you should use default:

ForAll( Gallery5_1.AllItems As obs, Patch(Findings, Defaults(Findings), { department: obs.Dropdown8_2.Selected.Dept, hod: obs.Label37_2.Text, category: obs.Dropdown6_3.Selected.Value, subcat: obs.Dropdown7_3.SelectedText.Value, level: obs.Radio5_3.Selected.Value, root: obs.TextInput7_4.Text, finding: obs.TextInput7_3.Text, corrective: obs.TextInput8_3.Text, preventive: obs.TextInput8_4.Text } ) );

Hope this helps you!
-----------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @ccqn ,

Assuming all of those controls are in the Gallery, try this

ForAll( Gallery5_1.AllItems As obs, Patch( Findings, LookUp( Findings, no = obs.no ), { department: obs.Dropdown8_2.Selected.Dept, hod: obs.Label37_2.Text, category: obs.Dropdown6_3.Selected.Value, subcat: obs.Dropdown7_3.SelectedText.Value, level: obs.Radio5_3.Selected.Value, root: obs.TextInput7_4.Text, finding: obs.TextInput7_3.Text, corrective: obs.TextInput8_3.Text, preventive: obs.TextInput8_4.Text } ) );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report

Hi @WarrenBelz

Worked like a charm! Thank you so much 😊

Was this reply helpful? Yes No