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
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.
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.
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Did you miss the call? Check out the Power Apps Community Call here.
We are excited to announce the Power Apps Super Users!
Check out our new profile badges recognizing authored solutions!