Hello there,
Success Flow: I created a power automated flow to populate an Excel template. First, I created an Excel script and then ran the script in Power Automate to populate my template and it's working very smoothly. No issues. The trigger point in this flow was; as soon as new items are added to my SharePoint list it will trigger the flow and run it.
Failure: I created another power automate flow, for which the trigger point is a Power app button and it's manual (unlike in the other flow above where the trigger point is a new item added to the list). I tested the flow and there are no errors. The template it is creting, that's giving me an error as below when I open the file.
"This workbook couldn't be opened because the file format may not be matching with the file extension."
I can explain it more and provide pictures of my flow if needed.


Report
All responses (
Answers (