Hi @Anonymous ,
The Open in excel function only supported in the form and if you want to use it, you need to open and save the excel in your folder manually, then you could create a flow to send an email with the excel attached.

If you want to record the form response to an existsing excel table when a response is submitted, you could create a flow to record the form response to an existsing excel table, and then you could send an mail with the updated excel attached.

Please let me know if your problem could be solved
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.