r/MicrosoftFlow • u/Majestic_Potato_4061 • 1d ago
Desktop How can I automate transferring approved drawings from Oracle Aconex to Asite using Power Automate?
Hi everyone,
I'm trying to build an automation using Microsoft Power Automate (Cloud or Desktop) to transfer approved drawings between two construction document management systems: Oracle Aconex and Asite.
Currently, this process is done manually, and I'm looking for a way to automate it.
Here's the workflow I'm trying to achieve:
- Access Oracle Aconex: Navigate to a project's document register and identify drawings that have received an updated approval status (A, B, C, or D).
- Capture document information: Extract the document reference number, revision number, approval status, and other relevant metadata.
- Download the PDF: Download the approved drawing PDF from Aconex, including any consultant comments or markups.
- Access Asite: Search for the same drawing in Asite using its document reference number.
- Match the existing document: The drawing already exists in Asite, so I don't want to create a duplicate.
- Update the drawing: Upload the PDF received from Aconex to the existing Asite document record and update its approval status to match Aconex.
- Keep the same revision: The revision number should remain unchanged. Only the PDF and approval status need to be updated.
- Prevent duplicates: The automation should recognize previously processed drawings and avoid unnecessary updates.
Important details:
- Both systems are accessible through a web browser.
- The drawings already exist in Asite.
- I want to automate the entire process rather than manually downloading and uploading PDFs.
- Ideally, the automation would run automatically on a schedule.
- I'm open to using Power Automate Desktop, Cloud Flows, APIs, or a combination of these.
My questions:
- Is this possible using Power Automate Desktop with browser automation?
- Would using APIs for Aconex and Asite be more reliable than browser automation?
- Has anyone successfully automated document transfers between two construction EDMS platforms?
- How would you handle updating an existing document's PDF and approval status without creating a new revision?
- Is there a way to export or generate a Power Automate flow that I can import directly rather than building every action manually?
I'm relatively new to this type of automation and would appreciate any guidance, examples, or recommendations on the best approach.
My ultimate goal is to have a fully automated Aconex → Asite synchronization process for approved construction drawings.
Thanks in advance!


