I'm working on an integration, where I'm trying to connect a group chat in MS Teams with Excel.
It should work this way:
- Whenever someone sends a message (trigger point), the Power Automate trigger should search for the body of said message in column A from an Excel Table from our SharePoint and reply with a cell value from the same row, but different column (if it finds a result).
- I understand that there can be several types of messages, but my logic will be to lookup for only 13-digit numeric number and ignore the rest.
- I'm trying to use the trigger 'When a new message is added to a chat or channel.
- Once The 13-digit number is identified then lookup for same in excel and retrieve a value from same row but different column.
- Post the retrieved value back in the chat group.
I just can't get it to return the exact message I send to the group.
I tried the 'Enter data from the previous step' button, but it is only letting me choose between:
• Message Conversation ID
• Message ID
• Message Link
None of them work. AIs aren't helping either...
Which expression should I use to define the message's body as input for the next action? If possible, at all.
I know it should be easier using a channel, but it would defeat the purpose of the automation. Thank you in advance Vish!
