Power Apps - Building Power Apps

Unanswered

How to add a row to the collection

(0) Share

Report

Posted on by MIA27

I am using the below code to add a row to the existing collection, but it is giving me error.

Please advise what correction should I do to achieve this:

Clear(colSvcExportData);

ForAll(

SupportSvcGallery.AllItems As SvcExportData,

Collect(

colSvcExportData,

{

RecoNo: SvcExportData.RecoNo,

SvcDate: Text(SvcExportData.SvcDate,"dd-mm-yyyy"),

Model: SvcExportData.Model,

SerialNo: SvcExportData.SerialNo,

SvcSMR: SvcExportData.SvcSMR,

SvcRemarks: SvcExportData.SvcRemarks,

SvcExpense: SvcExportData.SvcExpense,

Customer: SvcExportData.Customer

}

)

);

//Below code to collection 1 row of total at the end

Set(

colSvcExportDataAddRow,

{

RecoNo: "Total",

SvcDate: " ",

Model: " ",

SerialNo: " ",

SvcSMR: " ",

SvcRemarks: " ",

SvcExpense: Text(Sum(SupportSvcGallery.AllItems,SvcExpense),"##,##0.00"),

Customer: " "

}

);

//below code to Union/Join with main collection and last row

Collect(

colSvcExportData,

{

RecoNo: colSvcExportDataAddRow.RecoNo,

SvcDate: " ",

Model: " ",

SerialNo: " ",

SvcSMR: " ",

SvcRemarks: " ",

SvcExpense: colSvcExportDataAddRow.SvcExpense,

Customer: " "

}

);

All responses (4)

Answers (0)

rzuber 545 Super User 2025 Season 1 on at

Like (0)

Report

Re: How to add a row to the collection

OK.. So all columns in your collection have to be the same data type when you add a new row.

If ID is a number, it must be a number in every record. If date is a date, it must be a date in every record. If you convert a column to text, you must convert it to text in every record.

Make sure your data types for each column match what you are initializing in your collection. (The top Collect() call)
MIA27 on at

Like (0)

Report

Re: How to add a row to the collection

Also tried below, but same issue
MIA27 on at

Like (0)

Report

Re: How to add a row to the collection

I tried, its the same error.

Please note I not able to keep the same Data type.
Therefore, I want all the column last row to blank blank and
One column last row to show Text "Total" and the last row of Column SvcExpense as
Text(Sum(SupportSvcGallery.AllItems,SvcExpense),"##,##0.00"),

I also tried to put 0 where number field was required as shown in below image, still the same error
Note : I want to be keep blank not 0, still I tried, but no result erro
rzuber 545 Super User 2025 Season 1 on at

Like (0)

Report
Re: How to add a row to the collection

@MIA27 - Try:

Collect( colSvcExportData, { RecoNo: colSvcExportDataAddRow.RecoNo, SvcDate: " ", Model: " ", SerialNo: " ", SvcSMR: " ", SvcRemarks: " ", SvcExpense: Text(colSvcExportDataAddRow.SvcExpense, "##,##0.00"), Customer: " " } )
Data types have to be the same.