I'm developing an app for employee of the month voting using powerapps..below is the detail for my apps and the problem that I need an answer and solution to make it works.
For now this is the process of my apps process But after nomination process Admin will collect the nomination data already submit from user when nomination process from excel that connected to form My Nominee and put on Voting Process. Data is nomination name, justification and picture (refer at voting process). Nomination data save on screen 4 in excel table..on page 5 just confirmation display.
Then after Voting process end. From this powerapps it self will generate an email to send to all user (microsoft O365...The data from email is the highest name on voting process.
Now the email by manual..admin collect the name from excel table and then send an email to inform the winner....
This part is a use case for Flow. I did not build it myself, but this is what I'd do.
First you need to have condition in mind for when to trigger this process: this could just be you pushing a button when you want to start, or it can be a predetermined date and time when voting ends. That will be the first step of your flow.
Trigger the start of this flow from a button in PowerApps
Trigger the flow from a flow button
Trigger the flow from a recurrence once a month after voting
Next, you'll want to use a variable for identifying the winner. Initialize the variable. You'll probably do some filtering of a table where the votes are stored to find the sum of votes for each distinct email that was chosen. Set it to the variable.
Then you can use the connector to your Office 365 users. Add an Apply to Each box and make an action from your favorite email service to send an email to each person in your organization. In the body of the email be sure to reference the variable that is storing the name of the winner.
My solution is vague, but I hope it points you in the right direction.