Email if no record has been submited

[EC_1]

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

[poweractivate]

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

[EC_1]

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

[poweractivate]

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