@vaibhavtandon87 , you can configure the flow as follows:
1. Use Get Items action to retrieve items from SharePoint list
2. Add apply to each action to loop through the items, also go to settings of this action and turn on the Concurrency Control property of apply to each action
3. In the apply to each action add actions as follows:
3.1 Add compose action and put below json for your adaptive card, update the duedate and created by fields in json as per your SharePoint list columns.
{
"$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
"type": "AdaptiveCard",
"version": "1.2",
"speak": "<s>Overdue Item</s>",
"body": [
{
"type": "TextBlock",
"text": "Overdue Item",
"size": "Large",
"weight": "Bolder",
"wrap": true
},
{
"type": "TextBlock",
"text": "Due Date: @{items('Apply_to_each_2')?['DueDate']}",
"isSubtle": true,
"wrap": true
},
{
"type": "TextBlock",
"text": "Created By: @{items('Apply_to_each_2')?['Author/DisplayName']}",
"isSubtle": true,
"spacing": "None",
"wrap": true
},
{
"type": "TextBlock",
"text": "Status",
"wrap": true
},
{
"type": "Input.ChoiceSet",
"id": "status",
"value": "5",
"choices": [
{
"title": "Open",
"value": "Open"
},
{
"title": "Closed",
"value": "Closed"
}
],
"placeholder": "Open"
}
],
"actions": [
{
"type": "Action.Submit",
"title": "Submit"
}
]
}
3.2 Then add Post adaptive card to Teams Channel and wait for response action and configure it as follows
3.3 Change name of action to "PostAdaptiveCardWaitForResponse" and configure other properties of action as per below screenshot
3.4 Then add Update Item action to update the status selected in your adaptive card in the SharePoint list item, in order to get the status value from adaptive card, use the below expression
body('PostAdaptiveCardWaitForResponse')['data']?['Status']
