Check the below steps and let me know if this works for you.
1)Start by setting up a trigger for your Microsoft Form using "When a new response is submitted".
2)Retrieve the details of the form response using the "Get response details" action. This action helps to retrieve the individual answers submitted by the respondent.
@{triggerOutputs()?['body/resourceData/responseId']}
3) Add action, "Initialize variable" and create variables with array type and store the upload type questions in the value.
4) Then loop the questions to get a attachements and Include action, "Parse Json" to extract the link from Json
@{items('Apply_to_each_2')}
@{outputs('Each_Question_Files')}
You can use the below schema to parse json.
{
"type": "array",
"items": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"link": {
"type": "string"
},
"id": {
"type": "string"
},
"type": {},
"size": {
"type": "integer"
},
"referenceId": {
"type": "string"
},
"driveId": {
"type": "string"
},
"status": {
"type": "integer"
},
"uploadSessionUrl": {}
},
"required": [
"name",
"link",
"id",
"type",
"size",
"referenceId",
"driveId",
"status",
"uploadSessionUrl"
]
}
}
6) As a final step, add "Post message" in slack. Use the expression,
<@{items('Apply_to_each')['link']}|@{items('Apply_to_each')['name']}>
to reference links and names in the Slack message.
If this solution proves helpful and resolves your issue, kindly consider marking it as accepted. Doing so will aid others who encounter similar challenges in the future.
Regards,
Santhosh Balakrishnan
Apps4.Pro - Trusted Office365 T2T Migration partner. Migrate Exchange, SharePoint, Microsoft Teams, Stream, Yammer, Power Platform between tenants.
Product Specialist - http://www.apps4.pro/
