Hi @Vicki ,
Thank you for posting in this community.
I read your question carefully, consider customizing SharePoint using Power Automate (formerly known as Flow). Since Power Automate is currently not supported in the Q&A forum, and my knowledge of it is limited, I suggest you start a new discussion in the Power Automate Community on this issue so that you can get more professional help, there will be very professional people to tell you the steps on how to realize this function.
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.