Get Flow Runs via Powershell

(0) Share

Report

Posted on by hugojesus

Hi Community,

I've a challenge to shared with you, I'm facing this issue for the last three days and I'vent found any article explaining how to solve it.

First of all, my idea is use a Service Principal App to get a Flow Runs.

At the moment I've this configured ( and please ignore the name of the App 😞

1. In the App Registration ( Azure ) I've granted the following permissions to my App.

2. I created a Security Group and add my Service App as a member ( please ignore the name of the security group )

3. I add the Security Group as a Owner of my flow.

4. The Script that I'm using in Powershell to connect to PowerAutomate.

I'm not receiving any error in the connection.

5. To get all Flow Runs I'm this command.

6. The result is empty.

Another way to get results ( Working Fine 😞

7. Connecting via Service Account ( my account ) and granting for the owner of the flow my account.

8. Using the same command as the step 5.

9. The result is not empty.

What I'm doing wrong?

Best Regards,

Hugo Jeus

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @hugojesus,

Do any of the other Microsoft.PowerApps.PowerShell cmdlets return any results in the Power Automate API.ps script? Can you for example try and add something simple like

get-flowenvironment

before the get-flowrun part of your script?

Just to rule out if it is related to this specific cmdlet or if it is related to security/client cert setup.

Btw, which version of the Microsoft.PowerApps.PowerShell module are you using? I assume the current one, version 1.0.32?

Was this reply helpful? Yes No
hugojesus 25 on at

Like (0)

Report
Yes, if I use the following command, I get results.
get-flowenvironment

Was this reply helpful? Yes No
DB_OK 14 on at

Like (0)

Report

Hello Hugo,

Did you get any solution? I am in the same situation

Was this reply helpful? Yes No
hugojesus 25 on at

Like (0)

Report

Hi @DB_OK ,

I don't found anything to help me out of this problem.

I still with the same issue to solve.

Sorry.

Best Regards,
Hugo Jesus

Was this reply helpful? Yes No
DB_OK 14 on at

Like (0)

Report

Thank to reply hugo.

We look for a workaround by making requests to graph environments with a custom connector. It's not ideal, but it allowed us to move forward.

Was this reply helpful? Yes No
Suggested answer

ME-28051803-0 2 on at

Like (0)

Report

Adding app reg permissions in the gui does not work.

https://learn.microsoft.com/en-us/power-platform/admin/powershell-create-service-principal#registering-an-admin-management-application

TLDR;

$appId = "CLIENT_ID_FROM_AZURE_APP"

# Login interactively with a tenant administrator for Power Platform
Add-PowerAppsAccount -Endpoint prod -TenantID $tenantId

# Register a new application, this gives the SPN / client application same permissions as a tenant admin
New-PowerAppManagementApp -ApplicationId $appId

Was this reply helpful? Yes No