powerapps - How to track if a form has been filled out

Question

I am working on a powerapps form that collects data, and within this data there are 7 locations that must fill out the form monthly, is there a way to track if they have completed it? And could this be added onto, for example sending out an email to the designated people that should have filled out the form? Thank you for the help!

question from:https://stackoverflow.com/questions/66068008/how-to-track-if-a-form-has-been-filled-out

Answer 1

Like @Aakash said yesterday i would submit each data field as an separate item into a SharePoint list. This way you can use a power automate flow to check how many fields a specific person has submitted or not.

A scheduled flow with a if statement could be used to send out a "3 of 7 locations are missing. Please complete your form" notification by mail or teams chat X days before deadline.

---

Or as alternative use Forms + Power Automate to check if the completed form was submitted

1. In power automate create a new instand cloud flow

2. The trigger we need is not one of the most used. so choose "skip" on the next screen

3. in the next screen choose "Microsoft Forms" as trigger to start the flow

4. Choose "When a new response is submitted (so the Flow starts every time a user finishes a Form)

5. Choose the Form to use with this flow

6. Just add an action to send out an E-Mail or add an item to a SP list and then use a monthly scheduled flow to check if you have an entry from this person or not