Answered

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

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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)".

In my Dataverse Table, it says the unique identifier is called "Requests". This is an auto-generated field, I did not add it.

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'

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

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.

---
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.

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report
Copy link

Link copied!

Just a note of caution that the Ask in PowerApps Dynamic Content is NOT available if you are using the PowerApps (V2) Trigger.

Was this reply helpful? Yes No