Create dynamic collection

(1) Share

Report

Posted on by Glaga

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.

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Glaga 63 on at

Like (0)

Report

Hi @Drrickryp

Thank's U

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

Thank 🙂

Was this reply helpful? Yes No
NziokiB 83 on at

Like (0)

Report

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

Was this reply helpful? Yes No