Thanks, @Audrie-MSFT, adding to Audrie's note, @banthony you can get the newly generated fields following these steps. Here is what the end result looks like:
Add a "Get a row" action after you add the row into your table, like the screenshot below:
Here is my screenshot from Power Automate
Here is the YAML for my topic. I added the Id in my Adaptive card, but you can remove the ID and use the same adaptive card
kind: AdaptiveDialog
beginDialog:
kind: OnRecognizedIntent
id: main
intent:
triggerQueries:
- excel
actions:
- kind: AdaptiveCardPrompt
id: BQueje
card: |-
{
"type": "AdaptiveCard",
"$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
"version": "1.5",
"body": [
{
"type": "TextBlock",
"text": "Report an Issue",
"weight": "bolder",
"size": "medium"
},
{
"type": "Input.Text",
"id": "name",
"placeholder": "Your Name"
},
{
"type": "Input.Text",
"id": "issue",
"placeholder": "Describe the Issue"
},
{
"type": "Input.Text",
"id": "email",
"placeholder": "Your Email"
},
{
"type": "Input.Text",
"id": "phone",
"placeholder": "Your Phone Number"
}
],
"actions": [
{
"type": "Action.Submit",
"title": "Submit",
"data": {
"id": "customId"
}
}
]
}
output:
binding:
actionSubmitId: Topic.actionSubmitId
email: Topic.email
id: Topic.id
issue: Topic.issue
name: Topic.name
phone: Topic.phone
outputType:
properties:
actionSubmitId: String
email: String
id: String
issue: String
name: String
phone: String
- kind: InvokeFlowAction
id: invokeFlowAction_utd9Fd
input:
binding:
text: =Topic.name
text_1: =Topic.issue
text_2: =Topic.email
text_3: =Topic.phone
output:
binding:
email: Topic.Email
issue: Topic.Issue
jobid: Topic.Jobid
name: Topic.Name
flowId: a4c17b4f-18b0-ee11-a569-00224827ed84
- kind: SendActivity
id: sendActivity_wqkff0
activity: |-
Your issue has been created and here is the IssueId for you reference:
**Issue ID:** {Topic.Jobid}
We will reach out soon at this{Topic.Email} to get more details.
Thanks!
