Patch function - multiple entries only 1 result...

[JeffR68]

...Hi all!

I have an issue using the patch function. I have been using Patch a few times now, and I never had that issue. 

Let me explain:

I use patch because I want to enter data from a gallery into a sharepoint list. 

Whenever I submit my patch, it is only the first set of items that is entered in the sharepoint list, but it is entered as many times as there are items. 

So, if I filter my gallery to have 30 items, once submitted, my sharepoint list will have 30 new entries of the same data (the first line).

This is my formula: 

ForAll(
Saisie_CLM.AllItems;
Patch(
POC_Sortie_DMS_CLM;
Defaults(POC_Sortie_DMS_CLM);
{
Process: Label14.Text;
Nom_du_Paramètre: Label15.Text;
Section_ou_porte: Label13.Text;
Unité: Label10.Text;
Tol_Max: Label12.Text;
Tol_Min: Label9.Text;
Valeurs: Label11.Text;
Valeur_du_check: TextInput2.Text
}
)
)

Attached is a picture of my app. Basically, sharepoint will only enter the data from the first "row" of my gallery, but as many times as there are items..

Has anyone ever had that issue ? Am I using the Patch function for something it is not supposed to do? 

Many thanks,

Best

JFR

[WiZey]

Hello @JeffR68 ,

Try this formula instead:

Patch(
    source;
    ForAll(
        Gallery.AllItems;
        Defaults(source)
    );
    ForAll(
        Gallery.AllItems;
        {
            ...
        }
    )
)

[JeffR68]

Hi @WiZey !

Thanks for the quick answer.

I try your formula :

Patch(
POC_Sortie_DMS_CLM;
ForAll(
Saisie_CLM.AllItems;
Defaults(POC_Sortie_DMS_CLM)
);
ForAll(
Saisie_CLM.AllItems;
{
Process: Label14.Text;
Nom_du_Paramètre: Label15.Text;
Section_ou_porte: Label13.Text;
Unité: Label10.Text;
Tol_Max: Label12.Text;
Tol_Min: Label9.Text;
Valeurs: Label11.Text;
Valeur_du_check: TextInput2.Text
}
)
)

But it is the same result. I have the same data entered multiple times...

Did I miss something in the formula?

Thanks

[WiZey]

Can you try adding "ThisRecord" before each control like this:

ThisRecord.Label14.Text

Otherwise, you could also directly reference the column's value instead of the label's text.

[JeffR68]

the formula is completely underlined in red..

Patch(
POC_Sortie_DMS_CLM;
ForAll(
Saisie_CLM.AllItems;
Defaults(POC_Sortie_DMS_CLM)
);
ForAll(
Saisie_CLM.AllItems;
{
Process: ThisRecord.Label14.Text;
Nom_du_Paramètre: ThisRecord.Label15.Text;
Section_ou_porte: ThisRecord.Label13.Text;
Unité: ThisRecord.Label10.Text;
Tol_Max: ThisRecord.Label12.Text;
Tol_Min: ThisRecord.Label9.Text;
Valeurs: ThisRecord.Label11.Text;
Valeur_du_check: ThisRecord.TextInput2.Text
}
)
)

Error messages are: 

- non valid arguments(table), Record value is needed

- Patch function includes wrong arguments

- Impossible to use a value that is not a Record in this context : (Show the whole formula)

What do you mean by "directly reference the column's value instead of the label's text"?

Thanks

[WiZey]

Instead of using the label controls to get the record's values, why not directly reference the columns you're using to populate those labels'? 

For example, you're populating your label with "ThisItem.Process". You could use the same logic in "Patch()" instead of using the label "Label14".

[JeffR68]

Hi @WiZey ,

So I am now using this formula: 

Patch(
POC_Sortie_DMS_CLM;
ForAll(
Saisie_CLM.AllItems;
{
Valeur_du_check: ValChek.Text;
Tol_Min_: TOLMIN.Text;
Section_ou_porte: SECTION.Text;
Tol_Max: TOLMAX.Text;
Process: PRO.Text;
Valeurs: VAL.Text;
Nom_du_parametre: PARAM.Text
}
)
)

Much simpler! Actually, I was using containers and that's what caused my issue. It seems like the values were not taken into account due to the container.

I have to create text boxes that capture the values inside my container, and use those in my formula. 

I honestly don't know if the container are the real issue here, but I was wondering if you had any info on that?

Thanks