cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Silva_BR
Helper II
Helper II

Sending multiple records to SharePoint

I'm having a problem sending 55 records from Power Apps to Sharepoint using the ForAll + Patch function.With few records the formula was working but for many it wasn't.I'm using Power Apps in Portuguese so if you want to replicate the code, change it; by , and ;; per ;.

         ForAll(GalSimula.AllItems;
          Patch(Item_Simula;{
            Linha:dpLP.Selected.Value;
            LB:Value(lLB.Text);
            SKU: Value(lSKU.Text);
            Descricao:IDescrição.Text;
            Qtd:Value(lQTD.Text);
            PesoBR:If(ModElu.Selected.Value="Construção Civil"; Value(iPeso.Text);0);
            CTFix:Value(lCTFix.Text);
            CTVar:Value(lCTvar.Text);
            Premio:Value(lPremio.Text);
            LME:If(ModElu.Selected.Value<>"Construção Civil";Value(lLME.Text);0);
            CM:Value(lCM.Text);
            OCIO:Value(lOcio.Text);
            BF:If(CanalElu.Text="MI";0; Value(lPremio.Text + lLME.Text) * 0,001);
            RULE:Value(IRule.Text/100)
            ;Simulacao:{Id:VarPatch.ID;Value:VarPatch.Simulacao}
          })
          );;

Thank you all

 

2 REPLIES 2
WarrenBelz
Super User
Super User

Hi @Silva_BR ,

I cannot see your data or model, so this is a little difficult - I have parsed your code below for easy reference

ForAll(
   GalSimula.AllItems;
   Patch(
      Item_Simula;
      {
         Linha:dpLP.Selected.Value;
         LB:Value(lLB.Text);
         SKU: Value(lSKU.Text);
         Descricao:IDescrição.Text;
         Qtd:Value(lQTD.Text);
         PesoBR:
         If(
            ModElu.Selected.Value="Construção Civil"; 
            Value(iPeso.Text);
            0
         );
         CTFix:Value(lCTFix.Text);
         CTVar:Value(lCTvar.Text);
         Premio:Value(lPremio.Text);
         LME:
         If(
            ModElu.Selected.Value <> "Construção Civil";
            Value(lLME.Text);
            0
         );
         CM:Value(lCM.Text);
         OCIO:Value(lOcio.Text);
         BF:
         If(
            CanalElu.Text="MI";
            0;
            Value(
               lPremio.Text + lLME.Text
            ) * 0,001
         );
         RULE:Value(IRule.Text/100);
         Simulacao:
         {
            Id:VarPatch.ID;
            Value:VarPatch.Simulacao
         }
      }
   )
);;

The only two areas I can see maybe should be

BF:
If(
   CanalElu.Text="MI";
   0;
   (Value(lPremio.Text) + Value(lLME.Text)) * 0,001
);
RULE:Value(IRule.Text)/100;

 

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

WarrenBelz
Super User
Super User

Hi @Silva_BR ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,210)