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: " "

}

);

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

rzuber 552 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
MIA27 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
MIA27 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Also tried below, but same issue

Was this reply helpful? Yes No
rzuber 552 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No