web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Create dynamic collection
Power Apps
Answered

Create dynamic collection

(1) ShareShare
ReportReport
Posted on by 63

Hello, 

I have a recruiting application.

And I would like to create a collection in a dynamic way for a performance calculation of each member of the team.

 

The lines:

each member of the team (I create a local collection that lists)

 

The columns :
These are calculations based on employees.

 

For example : 
Number of "Qualif." for BERTRAND:

CountIf(PROPALES_PP;Year(Date_Kliff_PP)=RECH_ANNEE_1.Selected.Value;!IsBlank(Date_Kliff_PP);Month(Date_Kliff_PP)=RECH_MOIS_1.Selected.mxhs;'Resp-RS_PP'="BERTRAND")

 

here is the expected result.

For the moment I have built this report by hand, with about forty inputext, it is not a table.

PA.jpg

 

 

 

How can we create a "dynamic" collection which includes online the names of the staffs registered in a STAFF_COLL collection and in the column of calculations according to Staff?

 

Thanks for your help !

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    Hi @Glaga 

    I am looking at your model but it seems to me that a better database design would be a Many to Many relationship as shown below. You would have three tables to describe it.  With these three tables, you could design an app that could show  each skill and get a list of who achieved it and when as well as an evaluation or description of their performance.  You could also look at each staff member to see the list of skills that they have as well as the evaluation and date obtained. If you want to go further with this, let me know and I can help you with the design. StaffSkills.png

  • Verified answer
    Glaga Profile Picture
    63 on at

    Hi @Drrickryp 

     

    Thank's U 

    Finaly I have create a new collection and add columns with my formul 

    Thank 🙂

  • NziokiB Profile Picture
    83 on at

    I am struggling with a similar issue, could you please share your solution?

    Thank you

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 846

#2
Valantis Profile Picture

Valantis 532

#3
Haque Profile Picture

Haque 410

Last 30 days Overall leaderboard