You’re offline. This is a read only version of the page.
18
Greetings!
I'm trying to create a flow that takes posts created in the last week in a Sharepoint blog "list" and mails out the titles and links via e-mail. When I attempt to "Get Items" from the blog list I get this error on the step:
Thanks for your reply Mabel! Sorry it took so long to reply.
Here is the "Post" content type. Below that is the json definition of the Flow, and below that, the json of the error message.
Share
Report
All responses (
Answers (
{
"$connections": {
"value": {
"sharepointonline": {
"connectionId": "/subscriptions/3200b703-8ae2-4bd4-9c66-dcd3bf335cd2/resourceGroups/Redacted-Tasks/providers/Microsoft.Web/connections/sharepointonline",
"connectionName": "sharepointonline",
"id": "/subscriptions/3200b703-8ae2-4bd4-9c66-dcd3bf335cd2/providers/Microsoft.Web/locations/northcentralus/managedApis/sharepointonline"
}
}
},
"definition": {
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
"actions": {
"Create_HTML_table": {
"inputs": {
"columns": [
{
"value": "@item()['dynamicProperties']"
},
{
"value": "@item()['ItemInternalId']"
}
],
"format": "HTML",
"from": "@body('Get_items')?['value']"
},
"runAfter": {
"Get_items": [
"Succeeded"
]
},
"type": "Table"
},
"Get_items": {
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['sharepointonline']['connectionId']"
}
},
"method": "get",
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://redacted.sharepoint.com/sites/redacted/news/'))}/tables/@{encodeURIComponent(encodeURIComponent('Posts'))}/items"
},
"runAfter": {},
"type": "ApiConnection"
}
},
"contentVersion": "1.0.0.0",
"outputs": {},
"parameters": {
"$connections": {
"defaultValue": {},
"type": "Object"
}
},
"triggers": {
"Recurrence": {
"recurrence": {
"frequency": "Minute",
"interval": 15
},
"type": "Recurrence"
}
}
}
}{
"status": 400,
"message": "The query to field 'NumComments/PostTitle' is not valid.\r\nclientRequestId: 026ba1a4-145e-40f3-8527-59ac4b5ad5bb",
"source": "https://redacted.sharepoint.com/sites/redacted/news//_api/SP.APIHubConnector.GetListItems(listName='Posts',queryOptions=@q)?@q=''",
"errors": [
"-1",
"Microsoft.SharePoint.SPException"
]
}
Hi DennisWOlson,
I am not sure with the “Sharepoint blog list” you mentioned. Is it a custom list in SharePoint? Could you share more info on it?
Please share a screenshot of your flow configuration. Do you have any special settings on the action “Get items”?
Currently, filter query is supported by Flow, but seems that select query has not been supported yet. Please take this doc for more details:
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-rest-requests
And you could also add a request at Flow ideas Forum the $select query, I will help collect and report it on my side:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Best regards,
Mabel Mao
