Hi recently I was watching an interesting YouTube video by Reza Dorrani on how to 'Build a CHAT experience in Power Apps using SharePoint Lists' - https://www.youtube.com/watch?v=u7uLgJS-NUs. I have created a similar workflow where I am able to get comments added to a list item as well as post a comment from power apps using the 'GET' & 'POST' method in Send an HTTP request to SharePoint connector in flow. Additionally I wondered if I could also add additional features such as delete or edit a comment (which is existing in SharePoint) to a list item from power apps. So to achieve this I added an Or branch to my flow which checks if the input is equal to Delete (set in the power apps V2 connector inputs), if yes then using a similar approach as in 'GET' & 'POST' method in Send an HTTP request to SharePoint connector I am asking the flow to delete comment using the 'DELETE' method. I am calling my flow on the 'OnSelect' of a trash icon inside my gallery control set to: Set(varComments, CustomerRequestsComments.Run("Delete",Table1.Selected.ID).response) where 'varComments' is the variable that holds metadata JSON structure, 'Table1.Selected.ID' shows item ID. But its gives me an 502 error: The type Microsoft.SharePoint.Comments.CommentEntitySet does not support HTTP DELETE method and the flow fails.
In my flow:
'Send an HTTP request to SharePoint 2' action Raw inputs:
"message": "The type Microsoft.SharePoint.Comments.CommentEntitySet does not support HTTP DELETE method.\r\nclientRequestId: 3407568d-279c-49d5-8519-bd25a7082dbe\r\nserviceRequestId: 89ef5ca1-7007-6000-b8c5-c82673e05f24",
DELETE Method in Send an HTTP request to SharePoint connector in flow
Finally got the DELETE method to function perfectly. To delete a specific comment we need to provide a commentID input parameter type number(make it optional) in the api after Comments(commentID) similar to what we do to get ItemID. And to get commentID value associated with each comment dynamically I added a text label in the gallery with Text property set to: This item.Value.id. Where 'id' denotes the comment id which we can see in the output JSON. FInally I added a Trash icon in my gallery and set its 'OnSelect' property to: Set(varComments,Flowname.run("Delete",Table1.Selected.ID, {num_2:txtlabel.Text}). response). Similarly I added an edit icon to edit each comment using the PATCH method.
DELETE Method in Send an HTTP request to SharePoint connector in flow
If I hardcode the comment ID I am able to delete the particular comment from the list item. But when I try to add it as a dynamic field by adding a input type number parameter (CommentID) in the power apps V2 connector and used it in the Uri field as you have mentioned I am still getting the same error code 502. "The type Microsoft.SharePoint.Comments.CommentEntitySet does not support HTTP DELETE method". Also if I change it to text input parameter (make it optional) this time I get the following error "Unable to process template language expressions in action 'Send_an_HTTP_request_to_SharePoint_3' inputs at line '0' and column '0': 'The template language expression 'triggerBody()['text_2']' cannot be evaluated because property 'text_2' doesn't exist, available properties are 'text, number'".
DELETE Method in Send an HTTP request to SharePoint connector in flow
@Jalpa Mahesh Dhola
I have tried to add a input type number parameter (CommentID) in the power apps V2 connector and used it in the Uri field as you have mentioned but i am still getting the same error code 502. Should I create a new flow for 'DELETE' method
@DGDGDGFHF
I think, List name is not proper in this API.
When you use getbyTitle in API, we have to pass SharePoint List Display name only. Have you changed the display name?
Please check in the SharePoint site where you created a list.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
25
All responses (
Answers (