Good day, I have been working with Office 365 for more than 5 years. Have gone through your requirement. Option 2 is possible and will deliver working script in 7 days. Option 1 might be also possible, if we can use Microsoft flow, can be said after through testing. let me know if you wish to hire me.