Using ForAll() with collections - how to get the values of the collection?

(0) Share

Report

Posted on by MichaGue

235

Hi,

I have a collection with the following structure.

ClearCollect(
colExample,
 {
 ID: 1,
 Section: true
 },
 {
 ID: 2,
 Section: false
 }
...
);

Now I would like to generate a new collection "colCollection" with further content based on the information of "colExample". To go through each line of collection "colExample" I want to use ForAll().

ClearCollect(
colCollection,
 {
 ForAll(colExample,"Example " & colExample.ID & ", Section: " & 
 If(colExample.Section, "yes", "no")
 )
 }
)

The final result should be a collection (colCollection in the example above) which contains strings, e.g.

"Example 1, Section: yes"

"Example 2, Section: no"

My problem is the ForAll() code above does not work. How do I get the values of colExamples, e.g. ID, inside the ForAll()?

Thanks for your help.

Best regads,

Michael

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

Ethan_009 4,838 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MichaGue ,

Are you trying to achieve something like this?
ForAll( colExample, With( { CurrentExampleRecord: ThisRecord }, Collect( colCollection, { Example: "Example "&CurrentExampleRecord[@ID], Section: If(CurrentExampleRecord[@Section], "yes", "no") } ) ) )

I hope this helps
MichaGue 235 on at

Like
a
(0)

Report
Copy link

Link copied!
You have put me on the right track. I was unfamiliar with the spelling:
CurrentExampleRecord[@ID]

Thanks for the fast feedback. Best regards.