Hi Everyone,
I'm very new to building flows and trying hard to build a Claim Prioritization & Notification workflow using Power Automate, Microsoft Forms, SharePoint, and Adaptive Cards.
The goal is to automate intake, triage, and internal notifications for insurance claims.
Workflow Overview
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
Issues I’m Facing
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.
What I’ve Tried:
- 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
In Teams, the Adaptive Card displays:
Sentiment
outputs('Compose_-_Clean_Sentiment_Result')
Key Phrases
outputs('Compose_-_Key_Phrases_Cleaned')
What I’ve Tried:
- 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.
What I’m Looking For
- 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!
Thanks in advance, Community🙌
Sample Adaptive Card JSON
{
"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"
}