Answered

Collect all items in gallery

(0) Share

Report

Posted on by agneum

204

ForAll(MyGallery; Collect(myCollection; {a:FieldA; b:FieldB}))

I'm trying to collect two fields for every item in the gallery. How should the code be written?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(5)

Report
Copy link

Link copied!
@agneum

I think you were just missing the ".AllItems" after MyGallery.

ForAll(MyGallery.AllItems; Collect(myCollection; {a:FieldA; b:FieldB}))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Verified answer

FacundoGorla 293 on at

Like
a
(0)

Report
Copy link

Link copied!

This works:

ForAll(MyGallery.AllItems; Collect ( myCollection; FieldA.Text; FieldB.Text ) )

Depending what type of data FieldA and FieldB have.

I recomend to add Clear(myCollection) before the ForAll depending on the case.

Was this reply helpful? Yes No
MW Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

If you ran in the same issue, being unable to load all items in a Gallery, please vote and support this idea: Enable the option to load all items in a Gallery · Community (powerapps.com)

Was this reply helpful? Yes No
RobD390 8 on at

Like
a
(0)

Report
Copy link

Link copied!

The semicolon after all items is wrong. It needs to be a comma.

Was this reply helpful? Yes No