cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sandie
Helper III
Helper III

Add Record > Trigger Power Automate from App > Get a Row by ID

I have a Teams/Power App using Dataverse.

 

I use a form to add a Request, and in the OnSuccess property of the form I am trying to trigger Power Automate, but I cant figure out how to get the right value to pass to Power Automate.

 

The first step of the flow is "Get a Row by ID" and it asks for the rows "globally unique identifier (GUID)".
d-fig1.png
In my Dataverse Table, it says the unique identifier is called "Requests".  This is an auto-generated field, I did not add it.
d-fig2.png

So what I cant figure out is how get this field in Power Apps so that I can pass it through to Power Automate

 

// Send Notification Email
'ANZMPT-NewRequestNotification'.Run("me@mydomain.com",WHAT DO I PUT HERE?);

 

 

I'm not super knowledgeable about data types/field types etc so this a big challenge for me.


I wondered if I had to send the whole record, so I tried First(Filter(Requests,'Request ID' = FormNewRequest.LastSubmit.'Request ID');

Something like FormNewRequest.LastSubmit gives me an error straight away (red squiggly line under code)

Something like FormNewRequest.LastSubmit.crdcb_requestid is not 'available'

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisPiasecki
Dual Super User
Dual Super User

Hi @Sandie,

 

No need to pass the entire record, just the ID should work.

 

In your flow, within the Get a Row by ID action, click into the Row ID field to bring up the Dynamic Content. Select "Ask in PowerApps", which will generate a new parameter with a datatype that matches the Row ID field, which is UniqueIdentifier in this case. Save the flow once done configuring. 

 

In your form's OnSuccess, set the following formula:

'ANZMPT-NewRequestNotification'.Run("me@mydomain.com",FormNewRequest.LastSubmit.crdcb_requestid);

 

In my example below I'm only using 1 parameter and the Account entity (the Account field is the uniqueIdentifier), but illustrates the same idea.

 PowerAppButtonFlow.PNG

 

LastSubmit.PNG

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

View solution in original post

1 REPLY 1
ChrisPiasecki
Dual Super User
Dual Super User

Hi @Sandie,

 

No need to pass the entire record, just the ID should work.

 

In your flow, within the Get a Row by ID action, click into the Row ID field to bring up the Dynamic Content. Select "Ask in PowerApps", which will generate a new parameter with a datatype that matches the Row ID field, which is UniqueIdentifier in this case. Save the flow once done configuring. 

 

In your form's OnSuccess, set the following formula:

'ANZMPT-NewRequestNotification'.Run("me@mydomain.com",FormNewRequest.LastSubmit.crdcb_requestid);

 

In my example below I'm only using 1 parameter and the Account entity (the Account field is the uniqueIdentifier), but illustrates the same idea.

 PowerAppButtonFlow.PNG

 

LastSubmit.PNG

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,030)