cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Email if no record has been submited

Is there anyway to sen an email if the have not submit any form?

i would like to set an email/notification at certain hour indicating if the user didn't capture records or if the app wasn't used

3 REPLIES 3
Super User II
Super User II

@EC_1 

 

Try at the data source level.

 

Have a column or field at the data source level that tracks a timestamp when record was updated. In Common Data Service you can use OOB "Modified On" field.

 

Have a recurring Flow that checks each interval (your choice) and iterates through all records and checks the timestamp against the current timestamp. If the timestamp is greater than a delta of your choice, then send an email notification.

 

Caveat: You may need Power Automate standalone license to be allowed to make this type of Flow.

How do I add that column?
My Data Source is SQL

@EC_1 

 

Check if it has it out of the box as well.

Try in a test Gallery to simply add the field 'Modified On' or similar name, try looking for out of box timestamp column instead of rolling out custom functionality if you can.

 

If your out of box column doesn't exist, you may have to add an SQL column yourself - we won't go into it for now here as it is outside scope of PowerApps and also, it is bit advanced. 

 

Recommend also you can consider to remodel the data as Common Data Service, it has Modified On out of box field for each record. 

 

First, try making sure that you don't already have one for SQL. Often SQL database may have out of box timestamp field for Modified On for each record when it was last updated. Other than that we won't elaborate further at this time and we recommend you research further yourself, or wait and see if someone else here has further insight into your issue.

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (25,913)