Collecting data from an adaptive card *without* a manual trigger

[aaronhowe]

Hi all,

I have a couple of flows running which log form responses in Excel Online, then create Planner tasks as a result.  When the Planner tasks are completed the Excel sheet is updated with the completion date and an e-mail is triggered to the requestor to check everything is okay.  So far, so good.

I have been asked if I can incorporate some feedback so I have removed the email response and replaced it with an adaptive card which collects feedback.  The problem is, Power Automate doesn't offer me any of those AC responses to use elsewhere - and I can't see why.  When I create the same AC function with a manual trigger, I can use the outputs in an email, so I don't know why it won't work in this instance.

The current (automated) flow:

1. User submits a form

2. Form is validated by type and a Planner task is created/allocated dependent on the request type

3. An Excel sheet is updated behind the scenes to log the request details for later use

4. On completion of the task the person allocated the task ticks off the entry in Planner

5. Excel is updated with the completion date

6. An adaptive card is posted to the original requestor to ask if everything is okay

7. - At this point if everything is not okay I'd like to send an email to the line manager of the person responsible for the task - this is the bit that doesn't work

Am I missing some logic that is stopping me from getting the outputs of the card?  The JSON follows:

{
    "type": "AdaptiveCard",
    "$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
    "version": "1.3",
    "body": [
        {
            "type": "TextBlock",
            "text": "Your recent task request (@{body('Update_a_row')?['Request Type']}) which you submitted on @{formatDateTime(body('Update_a_row')?['ReStartDate'],'dd/MM/yy')} has been completed.  Please acknowledge using one of the buttons below, and provide feedback if required.",
            "wrap": true,
            "id": "txtCompletionNote"
        },
        {
            "type": "Input.ChoiceSet",
            "choices": [
                {
                    "title": "Yes the task is completed",
                    "value": "Yes"
                },
                {
                    "title": "I am not satisfied with the outcome",
                    "value": "Maybe"
                },
                {
                    "title": "No the task has not been completed",
                    "value": "No"
                }
            ],
            "label": "Did it work?",
            "id": "choiceDidItWork",
            "style": "expanded",
            "isRequired": true,
            "errorMessage": "This field is compulsory"
        },
        {
            "type": "Input.Text",
            "label": "Your feedback (optional)",
            "id": "txtFeedbackInput"
        }
    ],
    "actions": [
        {
            "type": "Action.Submit",
            "title": "Submit",
            "id": "btnSubmit"
        }
    ],
    "id": "cardFeedback"
}

Dynamic value missing from 'Send an email (V2)':

[Hardesh15]

@aaronhowe  You have to construct dynamic content from adaptive card. Please check this thread.

https://powerusers.microsoft.com/t5/Using-Flows/Collect-Response-from-Adaptive-Card/m-p/1344582#M269...

Please 'Thumbs Up' the posts that helped you and 'Mark as Solution' if my post answered your question.

@Hardesh /Gopenly.in

[Anonymous]

[deleted]

[Anonymous]

[deleted]

[aaronhowe]

Thanks but that suggestion didn't work.  The outputs pasted into the email were just direct text from the compose field inputs and I can't see how the other solution could be adapted to what I am trying to achieve.

[aaronhowe · Accepted solution]

I was able to resolve this using this link (https://ashiqf.com/tag/dynamic-content-missing-teams-adaptive-card/) and following the example: 

outputs('Post_adaptive_card_and_wait_for_a_response').body.submitActionId

I altered the function from submitActionId to the choice I had used in the card and created a second output for the feedback text.  These work perfectly in the output email now.  For anyone else encountering this problem, assuming like me you didn't rename the adaptive card function remember to use underscores in the field name, and to enter one compose entry in the formula function at a time, you can't enter multiples in there though they will both have the same field name (output) when you come to use them.