Trigger: Microsoft Forms submission
Steps:
- Get response details
- Create item in SharePoint
- Run AI Builder sentiment & key phrase analysis
- Update SharePoint item
- Send confirmation email
- Post Adaptive Card to Teams with claim summary and AI results
1. SharePoint Fields Not Populating from Microsoft Forms
Certain fields like Radio button or drop down(choice) and $Amount(number) are not saving correctly when submitted via Microsoft Forms.
They work fine when submitted via Power Apps, but not via Forms.
- Verified Form ID and Response ID in the trigger and “Get response details” step.
- Confirmed that the form question labels match exactly.
- Rebuilt the “Create item” step multiple times.
- Renamed SharePoint columns temporarily to force schema refresh.
- Used Compose steps to extract and format values.
- Considered using HTTP request to SharePoint as a workaround (haven't done so- I am not that techy).
2. Adaptive Card Shows Raw Expressions Instead of Values
Sentiment
outputs('Compose_-_Clean_Sentiment_Result')
outputs('Compose_-_Key_Phrases_Cleaned')
- Used @{outputs('...')} syntax in the Adaptive Card JSON.
- Pasted the below JSON into the Message field in Code View.
- Tried inserting dynamic content using the expression builder.
- Created intermediate variables (SentimentText, KeyPhrasesText) and referenced those.
- Tried both “Post card in a chat or channel” and “Post adaptive card and wait for a response” actions — but both seem to lock the Message field in read-only mode.
- How can I get SharePoint to recognize and populate the missing fields from Microsoft Forms?
- How can I ensure Power Automate evaluates expressions inside Adaptive Cards correctly?
- Is there a specific version of the “Post Adaptive Card” action that allows full JSON editing and expression parsing?
Any insights, workarounds, or examples would be greatly appreciated!
{
"type": "AdaptiveCard",
"body": [
{
"type": "TextBlock",
"text": "🟡 **Low Priority Claim Notification**",
"wrap": true,
"size": "Large",
"weight": "Bolder",
"color": "Warning"
},
{
"type": "TextBlock",
"text": "**Claim Details:**",
"wrap": true,
"weight": "Bolder"
},
{
"type": "FactSet",
"facts": [
{
"title": "Policy Number",
"value": "@{outputs('Create_item')?['body/PolicyNumber']}"
},
{
"title": "Claim Description",
"value": "@{outputs('Update_item')?['body/LossDescription']}"
},
{
"title": "Loss Date",
"value": "@{outputs('Create_item')?['body/DateofLoss']}"
},
{
"title": "Damage Type",
"value": "@{outputs('Create_item')?['body/DamageType/Value']}"
},
{
"title": "Estimated Loss",
"value": "$@{string(outputs('Update_item')?['body/EstimatedLossAmount'])}"
},
{
"title": "Insurance Type",
"value": "@{outputs('Create_item')?['body/InsuranceType/Value']}"
}
]
},
{
"type": "TextBlock",
"text": "**AI Analysis:**",
"wrap": true,
"weight": "Bolder"
},
{
"type": "FactSet",
"facts": [
{
"title": "Sentiment",
"value": "@{variables('SentimentText')}"
},
{
"title": "Key Phrases",
"value": "@{variables('KeyPhrasesText')}"
}
]
},
{
"type": "TextBlock",
"text": "🔗 View Claim in SharePoint?['body/ID']})",
"wrap": true,
"spacing": "Medium"
}
],
"actions": [
{
"type": "Action.Submit",
"title": "Assign to Me",
"data": {
"action": "assign"
}
}
],
"$schema": "http://adaptivecards.io/schemas/adaptive-card.json",
"version": "1.4"
}

Report
All responses (
Answers (