Collect repeating the first row instead of making new rows

(0) Share

Report

Posted on by lars_randaberg

I have a gallery with these three columns:

I'm trying to make a collection duplicating this - but instead of collecting the three rows, it repeats the first row three times:

This is the code im currently using:

ClearCollect(
 colNyeRaderFraExcel;
 ForAll(Galleri_lim_inn_fra_excel_HØP.AllItems ;
 {
 konto: card_konto.Text;
 ansvar: card_ansvar.Text;
 funksjon: card_funksjon.Text
 }
))

Thoughts?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @lars_randaberg,

When you use 'card_konto.Text' to get a value, you only get a default value in the ‘card_konyo’.

You can try to change it like this:
ClearCollect(colNyeRaderFraExcel, ForAll(Galleri_lim_inn_fra_excel_HØP.AllItems, { konto:ColumnName1, ansvar:ColumnName2, funksjon:ColumnName3 } ) )

There is another easier way here:
ClearCollect(colNyeRaderFraExcel, Galleri_lim_inn_fra_excel_HØP.AllItems)

Best regards,
Rimmon Li

Was this reply helpful? Yes No