News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Collection combination

Power Apps - Building Power Apps

Answered

Collection combination

(0) Share

Report

Report

Posted on by EmilioRoqueta69

521

Hi everyone,

I have two collections with these values and I need to get a collection combining both.

The idea is to get one record for each day of the current month for each employee.

Thanks for any help!

Categories:

Using Apps Using Formulas

All responses Img

All responses (3)

Answers Img

Answers (1)

DJ_Jamba 2,822 Super User 2025 Season 1 on at

Like (1)

Report

Re: Collection combination

You're welcome!
d(-_-)b
EmilioRoqueta69 521 on at

Like (0)

Report

Re: Collection combination

Thank you DJ !
Verified answer

DJ_Jamba 2,822 Super User 2025 Season 1 on at

Like (1)

Report
Re: Collection combination

Hi @EmilioRoqueta69

Try:
Clear(colResult); ForAll( Distinct(colEmployees,Employee) As EEs, ForAll( colDaysMonth, Collect( colResult, { Date: Date, Employee: EEs.Value } ) ) )