Hi All.
I am trying to replicate the flow from here: https://www.damobird365.com/microsoft-list-add-comment/
For me, it fails in the Apply to each loop with the following error:
BadRequest. The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.
The 'Select' is setup as follows:
{
"type": "Select",
"inputs": {
"from": "@body('Send_an_HTTP_request_to_SharePoint')?['d']?['results']",
"select": {
"Text": "@{concat(formatdatetime(item()?['createdDate'],'yyyy-MM-dd HH:mm'),' ',item()?['text'])}",
"Mention": "@{item()?['mentions']?['results']}"
}
},
"runAfter": {
"Send_an_HTTP_request_to_SharePoint": [
"Succeeded"
]
},
"metadata": {
"operationMetadataId": "a38b9e86-bcc1-49cd-9f71-f7d6180d3728"
}
}
Apply to each uses that output: body['Select']
The MentionSelect 'From' is
Items('Apply_to_each')?['mention']
Select:
item()?['name']
The Raw Input is:
[
{
"Text": "2023-12-05 17:21 @mention{0} and another one for good measure.",
"Mention": "[{\"email\":\"Mark.Lagerweij@geoverra.com\",\"id\":253,\"loginName\":\"i:0#.f|membership|mark.lagerweij@geoverra.com\",\"name\":\"Mark Lagerweij\"}]"
},
{
"Text": "2023-12-04 17:31 @mention{0} this is a beautiful message",
"Mention": "[{\"email\":\"Mark.Lagerweij@geoverra.com\",\"id\":253,\"loginName\":\"i:0#.f|membership|mark.lagerweij@geoverra.com\",\"name\":\"Mark Lagerweij\"}]"
}
]
The 'From' field in the error message reads:
[
{
"email": "Mark.Lagerweij@geoverra.com",
"id": 253,
"loginName": "i:0#.f|membership|mark.lagerweij@geoverra.com",
"name": "Mark Lagerweij"
},
{
"email": "Mark.Lagerweij@geoverra.com",
"id": 253,
"loginName": "i:0#.f|membership|mark.lagerweij@geoverra.com",
"name": "Mark Lagerweij"
}
]
Now, isn't the above and array, why does it telling me it is a string?
Any insights are appreciated.
Thanks!
