Power Platform Community Forum Thread Details

Hi all,

this should be an easy one. I have simple collection from a galllery (column with Names, IDs, Date and a text value from dropdown).

This is the code:

ForAll(colPlan As plan;
    Patch(DelnikPrescasy;
        Defaults(DelnikPrescasy);
            {
                KdoID: plan.crf13_id;
                Kde: plan.drpTextP;
                Kdo: plan.crf13_jmeno;
                Kdy: datPlan.SelectedDate;
                Hotovo: false   
            }
    )
);;

Makes no alerts on errors first, but get back with runtime error when launched (see picture).

The problem is dropdown control obviously. In gallery I am transferring the value to a label:

Text(drpPlan.Selected.Soupis)

and in Patch I am taking text from that label, but both columns in collection consists this: Control element - undefined

I cant see why there is no actual value from a dropdown in collection.

Thank you

Categories:

Building Power Apps

Hi @JM-14081323-0,

Assuming that Kde is a Text field and drpTextP is your Label in the gallery, you may need this

ForAll(
   colPlan As plan;
   Patch(
      DelnikPrescasy;
      Defaults(DelnikPrescasy);
      {
         KdoID: plan.crf13_id;
         Kde: plan.drpTextP.Text;
         Kdo: plan.crf13_jmeno;
         Kdy: datPlan.SelectedDate;
         Hotovo: false  
      }
   )
);;

You may also be able to do it a lot more efficiently like this

Patch(
   DelnikPrescasy;
   ForAll(
      colPlan As plan;
      {
         KdoID: plan.crf13_id;
         Kde: plan.drpTextP.Text;
         Kdo: plan.crf13_jmeno;
         Kdy: datPlan.SelectedDate;
         Hotovo: false  
      }
   )
);;

ForAll is not designed to be a loop, although it can act that way if it contains an action inside it. ForAll creates a Table, which can be Patched in one action to the data source and will run much faster than individual Patches for each record.

Please ✅ Does this answer your question 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 answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn