How to Use Power Automate to Remove a SharePoint Item from a Teams Reply
Question details
The user needs to configure a Power Automate flow that deletes a specific SharePoint list item when a reply is made to a Microsoft Teams message.
- Product
- Power Automate, Microsoft Teams, SharePoint
- Device & OS
- not provided
- Scenario
- Automating the removal of processed items from a SharePoint list based on Microsoft Teams reply triggers.
- Observed behavior
- The current automation successfully adds the original Teams message to the SharePoint list, but a secondary flow is required to remove the item using the parent message ID once a reply is posted.
Ensure you have the necessary edit permissions for the target SharePoint list and access to the Microsoft Teams channel where the workflow will be triggered.
Build a Power Automate Flow to Delete the SharePoint Item
Create a flow triggered by a new Teams reply that captures the parent message ID, locates the corresponding SharePoint list item, and deletes it.
To accomplish this, your flow must cross-reference the unique ID of the original Teams message with the corresponding record stored in your SharePoint list before executing the delete command.
In Power Automate, create an automated cloud flow and select the trigger 'When a new channel message is added' or 'When keywords are mentioned' depending on your specific Teams channel setup.
Add a 'Get message details' action to capture the Reply to ID (Parent Message ID) from the triggered Teams reply.
Add the 'Get items' action for SharePoint. Use an OData Filter Query to find the specific list item where the stored Teams Message ID matches the retrieved Parent Message ID.
Add an 'Apply to each' control using the dynamic values from the previous step, then insert the SharePoint 'Delete item' action, configuring it to use the unique ID of the matched SharePoint item.
Boost Your Productivity with WPS Office
While Power Automate handles complex automated workflows across Microsoft apps, you may be looking for a simpler, cost-effective solution for your daily document needs. WPS Office provides a lightweight, comprehensive office suite that is fully compatible with Microsoft formats without the heavy subscription fees.
- 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open Your Files: Launch WPS Office and open your existing Microsoft Office documents directly; they will retain their original formatting.
- 3. Start Working: Use the familiar interface to edit, save, and share your documents effortlessly.
Frequently Asked Questions
How do I find the Parent Message ID in a Teams reply using Power Automate?
In your Power Automate flow, when a reply triggers the flow, the dynamic content menu will include a 'Reply to ID' or 'Conversation ID' property. This ID matches the original parent message that started the thread.
Why isn't the SharePoint 'Delete item' action working in my flow?
Ensure that the flow is passing the correct SharePoint Item ID (not the Teams Message ID) to the Delete action. You must first use the 'Get items' action to cross-reference the Teams Message ID and retrieve the specific SharePoint Item ID.
Can I test my Power Automate flow before making it live in my Teams channel?
Yes. You can use the 'Test' button in the upper right corner of the Power Automate interface. Select 'Manually' to trigger the flow yourself by posting a test reply in the specified Microsoft Teams channel.
