Howdy all,
My team is responsible for (among other things) fielding requests from several other internal groups via Teams. In an effort to gather data related to types of requests, volume of chats, etc. we're using Power Automate to create a SharePoint list item for every Teams message created in a few channels. We're then loading that SharePoint list into a Power App, where our team can collect certain data about the chat (like the nature of the request, actions we took, etc.).
This solution is currently working well, but I'm running into a problem within Power Apps. When we create the SharePoint list item, we save the message ID as well as the Teams and Channel IDs. I can use the "MicrosoftTeams.GetMessagesFromChannel()" call in Power Apps to get a list of messages, presumably the most recent X number of messages, and then use LookUp to filter out to the correct message using the chat ID. However, because this is a pretty opaque function I don't know how many messages are loaded. Any message from a previous date (or even sometimes from earlier in the same day) will fail to load message details.
In the Teams connector documentation, there's a
Get Message Details function available, but I cannot for the life of me figure out how it works. The parameters don't make sense - for all other functions, the connector asks for the Team ID and Channel ID (like the GetMessagesFromChannel function I'm currently using). The GetMessageDetails function just asks for "messageID" and "threadType" and I can't find a way to get the IDs I have to fit. If anyone has been able to successfully use this function to load the details of a specific message, I would greatly appreciate your assistance!
