■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 Sheet
Change Sheet Name
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 Sheet
Change Sheet Name
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 a specific cell value (SharePoint)
Get a column range (SharePoint)
Get range by row (SharePoint)
Add sheet (SharePoint)
Rename sheet (SharePoint)
List tables (SharePoint)
Add table (SharePoint)
Enter a formula in a cell (SharePoint)
Enter a value in a cell (SharePoint)
Delete worksheet (SharePoint)
Sort a specified range in ascending or descending order (SharePoint)
Unprotect worksheet (SharePoint)
Create Excel Session (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
Retrieve List of Files in 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 Share Link
Delete File/Folder
Move File to Another Folder