You’re offline. This is a read only version of the page.
68
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.
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
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.
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
