I have a flow set up that uses data from a sharepoint list that is updated when a button is pressed in Powerapps. The data from this list is then pasted into a newly created excel file template for the results for the individual who filled out the Powerapps survey.
What I want to happen afterwards, is that we email the person who submitted the powerapps survey their personal excel file which is named after them. However, this part does not seem to work properly. I have attached images of my flow and the problem, and any help would be appreciated. The error detail appears as "The file id '/Technical Knowledge & Capability Results/Aidan Rogers.xlsx' is not valid."

Report
All responses (
Answers (