Run Command for Power Automate

(0) Share

Report

Posted on by ez1138

218

Hi, from within an App I wanted to run a flow from the record I am current working in.

Step that I have taken.

Have a working flow (Assessment-CreateReport...)
Added a PowerApp flow first step in Power Automate
Selecting the icon in PowerApps, I choose "Power Automate" under the Actions menu.
It create the command line below with nothing after Run(
My main SQL Server table has Audit_ID

'Assessment-CreateReportforQAQC0719200212pmCST'.Run(Don't know what to put in here...)

Quick follow-up...

I went back in to my flow and removed the "get" rows, etc. from SQL Server. Once I removed that and went back in I could do a RUN(). Not sure if this will work now.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@ez1138

You must add PowerApps parameters into the flow before you can pass any values from PowerApps.

Read this full tutorial by Microsoft. It will teach you anything you need to know.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
ez1138 218 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply. I saw that link and maybe I just don’t get it. If I’m in the PowerApp It pops up Getrow(V2), Row_ID or something like that. That the piece where I’m pulling “a” row from the SQL table. Is it pulling what I want? When I run it from Power Automate and it asks me what row, yes.

What do I enter in after the Run( to select the current row (Audit_ID)?

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ez1138 ,

Have you got this resolved? If not, I'm happy to help further.

Could you please share the detailed flow steps?

The Row ID of GetRow(V2) is the primary key that you defined on the SQL table, so you need to input the Primary key of the record you want to retrieve into corresponding parameter place in Run() code.

Sik

Was this reply helpful? Yes No