Skip to content

Solution Overview

Context:

  • The Goal of the solution is to automate exporting reports as PDFs into the sharepoint under a shared folder
  • To do so, all you need to do is run a function once, wait for it to finish, and you can see your reports in the folder

Components:

  • Excel File
  • SharePoint
  • Azure Function

The way it will work is presented on the diagram below:

mermaid graph LR; A[Turn On Capacity] --> B[Read the Excel Config File]; B --> C[Export reports as PDFs]; C --> D[Save reports on SharePoint folder];