For all Gallery patch

[AlwynSchutte]

Good day

I have a gallery that always consist of four records with various fields. I want to use two of the fields the unique identifier named Website_ID and the Form_URL field values which holds values for the four records to update a corresponding unique identifier in another table named Contacts. The four fields that must be updated in the Contacts table has different names.

My formula is:

ForAll(Gallery1.AllItems, Patch(Contacts, First (Filter (Contacts, Contact_ID =Website_ID)), {Assessment_form1:Form_URL, Assessement_form2:Form_URL,Assessement_form3:Form_URL,Assessement_form4:Form_URL}))

The problem is that the formula does not loop through the gallery- it writes the same Form_URL value to each of the different fields in the Contacts table.

Regards

Alwyn

[AlwynSchutte]

Good day

The Gallery has four identifiers named WebSite_ID which are all the same value. Another field named Form_URL has all different values. I want to lookup the Website_ID of the gallery in the Applications table in the field named Contact ID and write the four different values of the Form_URL field in the gallery to the fields named Assessment_form1, Assessment_form2, Assessment_form3 and Assessment_form4. The record in the Applications table is found but the fourth value of the Form_URL field of the gallery is written to all of the fields in the Applications table instead of the four different values.

Attached the picture will clearly explain what the problem is.

[AlwynSchutte]

Good day

Tested the code but it only writes to Assessment_form1

[AlwynSchutte]

Good day 

Website_ID in the gallery are all the same values which is exactly the same value as Contact_ID in the Contacts table. In the Contacts table Contact_ID is a unique number. In the gallery the business rules dictate that four of the same assessments of the same applicant must be grouped together. So the Website_ID of the Gallery which is the same value for all four records must be matched to the Contact_ID in the Contacts table which is a unique value. The Form_URL are all different values and this is the problem. The different values are not written to the Contacts table. The fourth value of Form_URL of the Gallery is written to all fields in the Contacts table.

Attached you will see on the picture exactly what the current problem is. As I explained above I overcame the problem with some bulky code- but it is not ideal.

[WarrenBelz · Accepted solution]

@AlwynSchutte ,

The fundamental issue is that if you want to differentiate between the gallery Items, you need a different identifier for each that then has to match the target record in the list you are patching to. If your "bulky code works, then stick with it, although my approach would be to have a different data structure from the outset.

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.

Visit my blog Practical Power Apps