Yes, I believe it can be achieved by Power Automate flow as per my experience. As I'm not an expert in Power Automate low, you may ask the experts in the dedicated Power Automate forum over here:: https://techcommunity.microsoft.com/t5/power-automate/ct-p/PowerAutomate.
Thanks for understanding.
If the answer is helpful, please click "Accept as 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.