Power Automate Azure Databricks connector cannot get output result of a run

[biubiurx]

Hi everybody, I'm using the Azure Databricks connector in Power automate and try to trigger a job run + get result of that single run. My job created in databricks is to run a notebook that contains a single block of SQL code, and that's the only task. But when I run the flow it says,  Action 'Get_the_output_for_a_single_run' failed: Retrieving the output of runs with multiple tasks is not supported. Please retrieve the output of each individual task run instead.

I'm a bit confused as have 1 single task & that there's no parameter to choose as task id from the action of "trigger a job run", only the body/run_id to be selected.

has anyone encoutered the same issue and knows how to resolve that? Thank you!

[nayan_wylde]

Even though your Databricks job only has one task, Power Automate might still treats it as a multi-task job under the hood. That’s why you're getting the error when trying to fetch the output directly from the job run.
Here’s a simple workaround you can try and let me know if it works:

1. Trigger the job and grab the run_id from the response.

2. Use the Get Job Run API (GET /api/2.1/jobs/runs/get) to fetch details of the run.

3. From that response, extract the run_id from the tasks block(there should be just one).

4. Then call the Get Task Run Output API (GET /api/2.1/jobs/runs/get-output?run_id=<task_run_id>) to get the actual output.