Azure Ai Document Intelligence on local .PDF file with powerautomate desktop

Question

Hi! Hoping someone can help me here with a little problem i have.

I'm using Azure Ai Document Intelligence with PowerAutomate and it work great on a online file (Using the Document/URL Parameter)

But if i have a file locally (EX:C:\Temp\Test.pdf) i don't know what to do.

If i do it this way It says the parameter should be a binary and if a convert the file in a binary variable before like this

I have a error during runtime saying "code": "ParameterMissing", "message": "The parameter urlSource or base64Source is required."

So to make it short what are the parameters to use for a local file?

Thanks in advance

Answer 1

Hello @Eric Dallaire ,

It seems the connector always taking the value from Image URL field, that may be the reason you getting The parameter urlSource or base64Source is required. when setting Image URL to blank and gives it should be http or https when setting Image URL other than http urls.

So, i found workaround that you create a python script which makes POST request and returns job URL, next run this script from PAD using command session.

Below is the python script

import requests
import base64
import json
import time

def execute(data):
    headers = {"Ocp-Apim-Subscription-Key": "key"}
    body = {"base64Source":data}

    res = requests.post("https://eastus.api.cognitive.microsoft.com/documentintelligence/documentModels/prebuilt-invoice:analyze?_overload=analyzeDocument&api-version=2024-11-30",headers=headers,data=json.dumps(body))
    if res.status_code == 202:
        return res.headers['Operation-Location']
    else:
        return res.content


def file_to_base64(filepath):
    with open(filepath, "rb") as file:
        base64_encoded = base64.b64encode(file.read()).decode("utf-8")
    return base64_encoded


file_path = r"Your_local_file_path\goals.pdf"  # Replace with your file path
base64_source = file_to_base64(file_path)

print(execute(base64_source))

It's not that you need to use python only you can use any familiar language where you can run it using command.

And below is the flow you need make.

1. In Open CMD session you give path to your script file folder.

2. In Write to CMD session give the command
   
3. Wait for few seconds.
4. Then you Read from CMD session

Output :

After the running the flow you will get output in CmdOutput.

You can alter the script further to retrieve results from above URL, according to your requirement you change the script.

Let me know if you have any query.

Thank you

Answer 2

In power Automate i clicked "See more action" and added Azure Ai Document Intelligence

Added the step Analyse Document v4

Filled the connexion needed info

If i try with a online .pdf file it work

But can't make it to work with a local file like i explained in my first post

Hope it answer your questions

Answer 3

is it a bug of the power automate action? Any updates? @Anonymous