Hello,
I hope someone will be able to help me with my quest.
I have an expiry table (new_tablee) that contains 2 fields:
table name (new_tablename)
remind me before (new_remindmebefore)
another two tables:
Students that contain: Name (cr6ec_name), Date(new_date), email(new_studentemail)
TBs that contain: Name (cr6ec_name), Student Name (new_studentname), Course Name (new_coursename), Date(new_date), email(new_studentemail)
**Student name and course name are lookup fields
the azure function should read the records in the expiry table to check the date based on "remind me before" every day.
then if the case verifies with remind me before values, it should create a new record in the notification table with fields: Name (new_name), student email (new_studemail), Date (new_date) = today's date, Stat (new_stat) = in progress.
Can someone help me with the azure function?
Thank you!