Is there a way to combine Power Automate with Ui Path

Help Studio
1

Hello there guys I have a query, I am using Ui Path to do automations, but the standard method for OCR is not working effectively and efficiently, I switched to power automate and used an activity to get tables from pdf, the datatable variable generated all the rows (19000+) in less than a minute. But now I want to add this data to a database. Power automate does not allow to do bulk insertion (neither in excel nor in database), I want to use the “Get table from PDF” activity of Power Automate in ui path, or would appreciate if the datatable variable generated in Power automate could be used in Ui Path studio. Would love to get to know a walkaround.
Thanks in advance.

1 Like
2

Here are a few potential workarounds to bridge the gap between Power Automate’s table extraction and UiPath’s database insertion capabilities:

1. Utilize a Shared Storage Medium:

  • Export the data from Power Automate: After extracting the table data into a DataTable variable, use the “Create file” action in Power Automate to save it as a CSV or Excel file in a shared location like SharePoint, OneDrive, or a local drive accessible to UiPath.
  • Import the data in UiPath: Within your UiPath workflow, use activities like “Read CSV” or “Read Range” to retrieve the data from the shared file and process it into DataTable format.
  • Insert into the database: Once the data is in a DataTable, leverage UiPath’s database activities (e.g., “Insert Data Table”) to bulk insert it into the desired database.

2. Employ an API-Based Approach:

  • Create a custom API in Power Automate: Design a Power Automate flow that exposes an API endpoint capable of receiving PDF files and returning the extracted table data in a structured format like JSON.
  • Call the API from UiPath: In your UiPath workflow, use the “HTTP Request” activity to send the PDF file to the Power Automate API endpoint and receive the parsed data in JSON format.
  • Deserialize and insert the data: Deserialize the JSON response into a DataTable using UiPath’s JSON activities and then use database activities to insert the data into the database.

3. Explore Third-Party OCR Solutions:

  • Consider integrating a third-party OCR library: If UiPath’s built-in OCR capabilities are not satisfactory, research and integrate a third-party OCR library that aligns better with your PDF structures and offers potential bulk insertion features.

Additional Considerations:

  • Performance optimization: If dealing with large datasets, consider performance optimization techniques within UiPath, such as batching database insertions or using asynchronous operations for long-running tasks.
  • Error handling: Implement robust error handling mechanisms in both Power Automate and UiPath workflows to ensure data integrity and prevent process failures.
  • Security: Address security concerns when sharing data between platforms or using APIs, ensuring proper authentication and authorization measures.

Choose the approach that best suits your specific requirements, technical expertise, and resource constraints.

1 Like
3

@Babar_Awan - UiPath cloud has some connectors to connect with power automation, I never tried you need to do some investigation on it for this below might helps.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.