■Overview
By using the workflow "When an invoice PDF is uploaded to OneDrive, perform OCR and add the detailed (table) information to Microsoft Excel," you can automatically retrieve table data from files on OneDrive.
This reduces the manual input into Microsoft Excel, thereby improving work efficiency.
■Recommended for
■Benefits of using this template
By utilizing the OCR function to add table data from files within OneDrive to Microsoft Excel, data import tasks proceed quickly.
This reduces the burden of inputting data from paper or PDFs, supporting the swift progress of tasks.
As manual transcription decreases, the risk of input errors is also minimized, improving data accuracy.
Additionally, data management and analysis in Microsoft Excel become easier, further streamlining subsequent tasks.


When a file is created or updated in a specific folder
When a folder is created or updated in a specific folder
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add worksheet
Rename sheet
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session
List sites
List drives in site
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add worksheet
Rename sheet
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session
List sites
List drives in site
Get worksheet information (SharePoint)
Get the value of a specific cell (SharePoint)
Get a column range (SharePoint)
Get range by row (SharePoint)
Add worksheet (SharePoint)
Rename worksheet (SharePoint)
Get table list (SharePoint)
Add table (SharePoint)
Set formula in cell (SharePoint)
Set value in cell (SharePoint)
Delete sheet (SharePoint)
Sort a specified range in ascending or descending order (SharePoint)
Unprotect worksheet (SharePoint)
Create Excel Session (SharePoint)
Get Item ID (SharePoint)
When a file is created or updated in a specific folder
When a folder is created or updated in a specific folder
Search Folder/File
List files in a specific folder
Create Folder
Download file
Upload File
Copy a File
Create Excel File
Grant Permissions to Folder or File
Change Folder or File Name
Create sharing link
Delete File/Folder
Move File to Another Folder
Download file as PDF
Get top-level folders
Get subfolders of a specific folder