Forum Discussion
UnknownOne
Apr 21, 2020Copper Contributor
List Validation - Date Column value required based on another column status
Hey all, Long time lurker, first time poster! I'm currently working on a SharePoint site that will look after staff members certification statuses and alert when they have x amount of days rema...
Alireza Rahimifarid
Apr 29, 2020Iron Contributor
Hello,
This may resolve your issue with a trick.
I am thinking about using PowerAutomate, once a certification is marked to yes, is sending the user a notification and asking for the expiration date. You may want to change the status of the record to pending and show the users all final records.
Please let me know if you like this idea or if you need more help.
Regards,
Alireza