Count number of occurrences of specific column

(0) Share

Report

Posted on by marsdendd

I have two lists:

1. Ideas (suggestions)

2. Applicants (applicants to idea)

For each application a new list entry is created and a flow triggers sending the idea creator an email informing them an application was made to their idea.

I have a PowerApp (canvas App) which should display the number of applications to a particular idea. There is a column called IdeaApplicantCount which should display the number of applicants. The PowerApp reads the column called IdeaApplicantCount and display the number of applicants.

What I would like to achieve is that for each new applicant the "Idea" column is counted and the IdeaApplicantCount list column incremented to the corresponding number of occurrences of the "Idea" column.

I tried to create an array and count how many times the Idea column appeared which would give me the sum total of applications to that Idea but I have been able to do this so far.

Can anyone help ?

Thanks.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Gristy 2,429 on at

Like
a
(0)

Report
Copy link

Link copied!

cant you just create a column on the ideas list called ApplicantCount.
When application us submitted, increment the applicant count for the specific idea and update the value.

Was this reply helpful? Yes No
marsdendd 68 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Thanks for getting back to me.

I though of that but then if someone deletes their application to the Idea I would then need to reduce the value which is why I felt the count of the occurrences of the column Idea would give a more dynamic count.

I would need to maintain two flows. One that triggers on the deletion of an item and one that triggers on the addition of a new item.

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @marsdendd,

In the Power App when you retrieve the "idea" information you can query the Applicants list filtering the IdeaId (unique identifier od the idea) and then count the returned records, this should be the correct number of active applicants for the idea, and you don't need to worry on maintaining a "count column".

Please let me know if I missing any information here or if this can be a possible solution for you.

Best regards,
Ademar Urbano
Power Platform Support Engineer

Was this reply helpful? Yes No