Save Multiple Gallery Items to Collection and SharePoint List

[Phineas]

I am building an app with 'Offline' capability.

I am able to collect and then save the data back to SharePoint.

Some of the saved data is coming from a gallery. The user has
the ability to create one or multiple items in the gallery.

When I collect and save the data only one item from the gallery
is being stored in the collection and saved back to the SharePoint
list.

How do I update my formulas (below) so that all the items in the
gallery are stored in the collection as records and saved as records
back to the SharePoint list?

My 'Save Collection' button has -
If(Invoice_Type_DataCardValue.Text = "Drop",

Collect(colDropData,

    {    

         //Gallery Fields -
         colDrop_Activity: Activity_ComboBox.Selected.Value,

         colDrop_Activity_Rate: Value(Activity_Rate_Fld.Text),

         colDrop_Activity_Quantity: Value(Activity_Quantity_Fld.Text),

         colDrop_Activity_Total: Value(Activity_Total_Fld.Text),
         //Form Fields -

         colDrop_Technician_Name: Tech_Name_ComboBox_DataCardValue.Selected.Full_Name,

         colDrop_Technician_ID_Number: Technician_ID_Number_DataCardValue.Text,

         colDrop_Customer_Name: Customer_Name_Dropdown.Selected.Value,

         colDrop_Customer_Account_Number: Customer_Account_Number_DataCardValue.Text,

         colDrop_Invoice_Type: Invoice_Type_DataCardValue.Text,

       }

    )

);

My 'Submit Data' button has -

If(CountRows(colDropData) > 0,

ForAll(colDropData,

    Patch(Drop_Backup_List,

    Defaults(Drop_Backup_List),

    {    
          //Gallery Fields -

         Activity: colDrop_Activity,

         Activity_Rate: colDrop_Activity_Rate,

         Activity_Quantity: colDrop_Activity_Quantity,

         Activity_Total: colDrop_Activity_Total,
         //Form Fields -

         Technician_Name: colDrop_Technician_Name,

         Technician_ID_Number: colDrop_Technician_ID_Number,

         Customer_Name: colDrop_Customer_Name,

         Customer_Account_Number: colDrop_Customer_Account_Number,

         Invoice_Type: colDrop_Invoice_Type

       }

       )

);

[WarrenBelz]

@Phineas ,

I am assuming here that your collection code works and colDropData contains the expected data.

If(
   CountRows(colDropData) > 0,
   Patch(
      Drop_Backup_List,
      ForAll(
         colDropData As _Data,
         {    
            Activity: _Data.colDrop_Activity,
            Activity_Rate: _Data.colDrop_Activity_Rate,
            Activity_Quantity: _Data.colDrop_Activity_Quantity,
            Activity_Total: _Data.colDrop_Activity_Total,
            Technician_Name: _Data.colDrop_Technician_Name,
            Technician_ID_Number: _Data.colDrop_Technician_ID_Number,
            Customer_Name: _Data.colDrop_Customer_Name,
            Customer_Account_Number: _Data.colDrop_Customer_Account_Number,
            Invoice_Type: _Data.colDrop_Invoice_Type
         }
      )
   )
);

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

[Phineas]

Yes, I have confirmed - several times, the current formula is storing a single line of data to the collection add patching said line of data to the list.

I am also building an regular "online" version of the mobile app.

How would the formula change where there is no collection, and the user 

needs to patc,h one or multiple lines of form/gallery data directly to the list (no collection)?

[WarrenBelz]

@Phineas ,

You asked how to patch all the records of a collection colDropData to new records in your SharePoint List Drop_Backup_List - How do I update my formulas (below) so that all the items in the gallery are stored in the collection as records and saved as records back to the SharePoint list?

I believe what I posted will do that so firstly, does it work for you ? There are some dangers with posting direct from the gallery depending on your structure.

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

[Phineas]

My apologies, I miss read your first reply.

No, my collection DOES NOT contain ALL of the data.

Here is an example of the colDropData collection.

The form being stored to the collection has one item (the form will always have one item),

The gallery has two items, yet the colDropData collection stored one of the gallery items, the last item entered in the gallery. 

[Phineas · Accepted solution]

Edited Reply:
Okay, looks like I got it; I finally got the formula provide more than one gallery item with the same base form data, as desired.

colDropData collectin formula. I'm not sure if this is properly formatted, but it's working.

If(Invoice_Type_DataCardValue.Text = "Drop",

   ForAll(Activity_Gallery.AllItems,

      Collect(colDropData,

      {
         //Form Data

         colDrop_Location: Location_Dropdown.Selected.Value,

         colDrop_Technician_Name: Tech_Name_ComboBox_DataCardValue.Selected.Full_Name,

         colDrop_Technician_ID_Number: Technician_ID_Number_DataCardValue.Text,

         colDrop_Customer_Name: Customer_Name_Dropdown.Selected.Value,

         colDrop_Customer_Account_Number: Customer_Account_Number_DataCardValue.Text,

         colDrop_Invoice_Type: Invoice_Type_DataCardValue.Text,

         colDrop_Title: Work_Order_Number_DataCardValue.Text,

         colDrop_Substation: Substation_DataCardValue_ComboBox.Selected.Sub_Feeder_Name,

         colDrop_Bill_To: Bill_To_DataCardValue.Text,

         colDrop_Work_Date: Work_Date_DataCardValue.SelectedDate,

         colDrop_Work_Ending_Date: Week_Ending_Date_DataCardValue.SelectedDate,

         colDrop_Tap: Tap_DataCardValue.Text,

         colDrop_Tap_Pole_Number: Tap_Pole_Number_DataCardValue.Text,

         colDrop_Light_Level_at_NID: Light_Level_DataCardValue.Text,

         colDrop_Job_JHA_Completed: JHA_Checkbox.Value,

         colDrop_Role: Role_DataCardValue.Text,
          //Gallery Data

         colDrop_Activity: Activity_ComboBox.Selected.Value,

         colDrop_Activity_Rate: Value(Activity_Rate_Fld.Text),

         colDrop_Activity_Quantity: Value(Activity_Quantity_Fld.Text),

         colDrop_Activity_Total: Value(Activity_Total_Fld.Text),

         colDrop_Activity_Consumable: Consumable_Fld.Text,

         colDrop_Activity_Consumed_Qty: Consumed_Qty_Fld.Text,

         colDrop_Activity_Consumed_Description: Consumed_Description_Fld.Text,

         colDrop_Activity_Unit: Consumed_Unit_Fld.Text,

         colDrop_Activity_Waste_Qty: Waste_Qty_Fld.Text,

         colDrop_Activity_Waste_Description: Waste_Description_Fld.Text,

         colDrop_Activity_Waste_Unit: Waste_Unit_Fld.Text

       }

    ) )

);

I now have the following formula in my 'Submit Data' (to SharePoint) button. All of the data is being patched as desired.

If(CountRows(colDropData) > 0,

   Patch(Drop_Backup_List,

   ForAll(

    colDropData,

    {    

         Activity: colDrop_Activity,

         Activity_Rate: colDrop_Activity_Rate,

         Activity_Quantity: colDrop_Activity_Quantity,

         Activity_Total: colDrop_Activity_Total,

         Technician_Name: colDrop_Technician_Name,

         Technician_ID_Number: colDrop_Technician_ID_Number,

         Customer_Name: colDrop_Customer_Name,

         Customer_Account_Number: colDrop_Customer_Account_Number,

         Invoice_Type: colDrop_Invoice_Type,

         Title: colDrop_Title,

         Location: colDrop_Location,

         Substation: colDrop_Substation,

         Bill_To: colDrop_Bill_To,

         Work_Date: colDrop_Work_Date,

         Week_Ending_Date: colDrop_Work_Ending_Date,

         Tap: colDrop_Tap,

         Tap_Pole_Number: colDrop_Tap_Pole_Number,

         Light_Level_at_NID: colDrop_Light_Level_at_NID,

         Job_JHA_Completed: colDrop_Job_JHA_Completed,

         Role: colDrop_Role

}

      )

   )

;

[WarrenBelz]

@Phineas ,

You marked your own post as a solution to a different question to what you asked again . . .
I wanted to know if the solution provided to the posted question worked before proceeding (possibly in error) assuming it did with something involving the gallery. I am in a different time zone and just got to this.

[Phineas]

Regarding storing data to the collection, I took what you sent and worked it over a bit. The initial lines had to be edited and rearranged, as shown in the previous post.

Regarding saving the collected data to the SharePoint list, yes - after I removed the "As _Data", your formula did work.

[WarrenBelz]

@Phineas ,

You do not need to remove  As _Data - the structure is correct. You have been posting here a long time (many years), but I still seem to struggle providing you with solutions to the initial question you post. 

[Phineas]

1. I thank you for your "years" of patient assistance.

2. I've always asked - whomever would help, to understand I may struggle processing what you know to be obvious; yet I am not deterred.

3. I tried the formula with thr "As _Data", Power Apps kicked back an error.

Taking it out and reconfiguring the formula got it to work.🤷🏾‍♂️

It is never my intent to waste anyone's time, and I am thankful for the vastness of the knowledge base in this community.🙏🏾