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)':
