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

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
Highlighted
Power Participant
Power Participant

Re: Email if no record has been submited

@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.

Highlighted
Helper II
Helper II

Re: Email if no record has been submited

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

Highlighted
Power Participant
Power Participant

Re: Email if no record has been submited

@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

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (9,391)