Get Teams conversation associated with Lists item

[Spinner]

I'm trying to set up a simple issue tracker using the template in Microsoft Lists.

Items in Microsoft Lists now have the ability to have an associated conversation, as shown in the screenshot.

What I'd like is:

1. a dedicated Issue channel in a Microsoft Teams (done)
2. a flow that takes new conversations in the Issue channel and based on the message content, creates a new issue in the list (done)
3. for the flow to replace the new issue item's associated conversation with the conversation that was already started in the channel

Part 3 is where I'm struggling. I can't find where the association between the item and its conversation is stored. It doesn't appear to be in a visible column in the backing SharePoint list. Any ideas where I can find this, so I can use it in a flow?

EDIT: I've discovered that you can add the same list to multiple channels and have different conversations for the item in each channel. This means, presumably, that the association is not being stored in the SharePoint list, but is being stored somewhere in the Teams channel - perhaps in a message.

EDIT 2: According to this Microsoft representative, "if you comment on a list item, those comments are stored within the list schema itself; think of it as an additional column of data per row." How, then, can one access that data?

[FCGALLEG]

Hi Spinner, 

The lists are saved in sharepoint:

Lists and SharePoint

Lists data is stored in the SharePoint Online team site. To learn more about how SharePoint Online interacts with Teams, see How SharePoint Online and OneDrive for Business interact with Teams.

I would like to share this document with you.

https://docs.microsoft.com/en-us/MicrosoftTeams/manage-lists-app

Regards,

JAvier

[Spinner]

@FCGALLEG  Thank you for the reply, but as I indicated in my original message, I already know that the list is held in SharePoint. What I'm trying to find is where the link between a list item and a Teams conversation is held.

[chasestreetdev · Accepted solution]

This question has been driving me crazy too, because it's such a great way to keep comms about a workflow organized without having to create weird new columns. You can absolutely replace the Message Id in a Conversation object that's stored in SharePoint and associated with the list item... it's just not documented by Microsoft for some reason. 

You can make an HTTP request to SharePoint to designate which message thread will show up in the conversation tab. I attempted to write up the whole process. It seems complicated at first, but it works consistently and I'm now using it to make my business's comms about list items run more smoothly -- I'm basically using this exactly the way you just described.

[Spinner]

Thanks @chasestreetdev - that looks good. I hope Microsoft set up an 'official' way to do this but this should suffice in the meantime.

(Very minor point: in the section on finding channel ID, I think you mean "at sign" rather than "ampersand".)

[chasestreetdev]

@Spinner Thanks for the catch, I'll fix it now! That's what I get for trying to write at 1am. The whole thing makes me wonder what other fun undocumented tricks there are...

[dcadavid]

Hi there, the link to your solution has been broken, would you mind re-posting?

[Demo4]

thanks a lot, unfortunately the link isn't working. Is there any way to share your solution another way or just post the http request? Thanks in advance 🙂

[Spinner]

@Demo4 @dcadavid You can still access a copy through archive.org. In brief, you need to make a POST request to the URI _api/SP.TeamChannelManager.SaveConversations('').

[Demo4]

Thank you @Spinner, did it work for you? I don't get an error but the conversation object isn't updated/ linked to the message...

[CoachOffice365]

I also couldn't access the page but found this one instead: https://medium.com/chase-street-development/conversation-thread-for-a-teams-list-item-e94155aa2e3a It seems to be the same one, but in the members' section of Medium. But for me it worked to access it for free (I was allowed 2 free views apparently). 🙂

[samuels]

Thanks for the renewed links. We have a Microsoft list, when starting a conversation sometimes for no reason the connection between the message and the list item does not work and any attempt to start a conversation from the Item will end up in a new post, and going to the list item the conversation will be always empty. I wanted to use the valuable information here to be able to fix this instances.
I first tried in a Test list and channel I created and all worked really smooth, I can attach any message I want from the channel and replace the conversation with another one if I want. But then I created the same automation for the real list and channel and it does not work as expected.
- Getting the channel and message links (to get the IDs) is not so easy as, apparently, because it is a private channel it does not give the link option but I am sure I got them right by emailing the link.

- Running the HTTP request providing the right Message ID, Teams ID and Channel ID the response is that all went ok but the desire message does not get attached to the List Item, instead it fixes the issue about no post getting stick to it, so I can start a new conversation from the Item and now it is possible to answer and all will be fine. But if I want to attach the first post with already some replies it got in the Posts tab I cannot do it, any attempt will clear the conversation in the Item and start from scratch. I am set as owner on both channel and list. Any ideas about would could be wrong with my automation?