All Collections
Integrations
Microsoft Power Automate
Sync Your Vendor List
Sync Your Vendor List
D
Written by Dave Almond
Updated over a week ago

The Ephesoft Semantik for Invoices Power Automate connector can be used to keep your vendor list in sync with Semantik. This document provides step-by-step instructions on how to build a Power Automate flow to sync a vendor list maintained in OneDrive.

Note: These instructions use OneDrive for Business as the vendor list source location, however, the same steps can be adapted for any document source supported by Power Automate.

Try It Yourself

If you’re new to Ephesoft Semantik, you can sign up for a free trial to evaluate our solution in your own real-world environment.

Prerequisites

To complete the steps in this guide you will need:

  • A Microsoft Power Automate account.

  • A Semantik username and password.

  • A OneDrive for Business account.

Overview

The process for syncing a vendor list from OneDrive for Business to Semantik via Power Automate has two major steps:

  1. Get the content for the vendor list from the source location into Power Automate.

  2. Upload the vendor list to Semantik as a comma-separated list.

Instructions

Step 1: Get Vendor List Content

Follow these steps to get the required file data into Power Automate:

  1. Create a new Instant Cloud Flow in Power Automate using the OneDrive for Business connector’s When a file is modified trigger.

  2. When prompted, login with your OneDrive for Business account and select the folder where modified documents will automatically be uploaded to Semantik.

  3. Use the OneDrive for Business connector’s Get file metadata action to retrieve the file’s name (including extension).

    1. File: <File identifier from When a file is modified>

Step 2: Upload Vendor List to Semantik

Once the file data is available in Power Automate it can be uploaded to Semantik. Follow these instructions to upload file data to Semantik in Power Automate:

  1. Request an upload URL using the Ephesoft Semantik for Invoices connector’s Create vendor upload action and sign-in if prompted

    1. File Name: <Name from Get file metadata>

  2. Upload the invoice to the URL using the built-in HTTP action

    1. Method: Put

    2. URI: <Upload URL from Create vendor upload step>

    3. Headers:

      1. Key: Content-Type

      2. Value: text/csv

    4. Body: <File Content from When a file is modified>


  3. Allow Semantik to process the invoice using the Ephesoft Semantik for Invoices connector’s Update vendor upload action

    1. Status: completed

Conclusion

This completes the process for configuring a Power Automate flow to synchronize a vendor list from OneDrive for Business to Power Automate.

Did this answer your question?