Hi @OESteve ,
Per my knowledge, you can achieve this function through Power Automate.
In fact we are currently providing help on SharePoint in the Q&A forum, and Power Automate is a product independent of SharePoint which we are not so familiar with. We would recommend that you go to the forum dedicated to flow for more professional help, there will be very professional people to solve the problem for you quickly.
Microsoft Power Automate Community - Power Platform Community
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.