Microsoft Power Automate - SharePoint Save File to One Drive, Create Email and Send Daily
This will allow you to not only extract a list view to your location in One Drive but will also do it daily, weekly, etc. and then email it when you want to who you want in your group\365 team.
HINT - If they are out side your network, email it to yourself and then create a rule in Outlook to forward to the user you want.