Forms to Excel to Sharepoint to copy sharepoint to break live excel link
I am currently building out a flow that goes like this.
1) MS Form submission
2) Data is then fed into an excel file ( a forms for excel file that is saved on SharePoint) where calculations are made
3) Last sheet on Excel file has a table that show's score's for the last submission of the form
4) These scores are then live linked to a PowerPoint file that is saved on Sharepoint
How would I copy this powerpoint file, rename it, add it to a new folder in SharePoint, and also break the live link feeding data in from Excel. (The goal here is to have a new PowerPoint file in Sharepoint for each form submission with the matching data for that submission)
Right now my flow copies the file and renames it but I am struggling with the breaking the live link part of this flow.
Any help or possible work around's would be greatly appreciated!!