trying to make a flow that adds teams channel messages into excel only when keywords are mentioned

[krakerr]

Hi,

I am trying to create a flow that triggers only when using the words "kAMST or mAMST" to then add the messages with these triggers in it to a excel file trough add a new row.

flow setup: when keywords are mentioned (keywords: kAMST, mAMST)-> get messages ->apply to each, with message lists as selected output (keeps automatically inserting itself) -> add a row into a table.

the problem I am running into is that when triggerd the flow copy's EVERY message in the history of the entire channel. obviously this is not the intent.

for the flow see attachments. 

if anyone has any tips on how to make it stop spamming my entire history and only just send the 1 message if it contains the keyword, it would be greatly appreciated.

thanks in advance

[grantjenkins · Accepted solution]

Hopefully this is what you're looking for.

See full flow below. I'll go into each of the actions.

When keywords are mentioned is the same as what you currently have.

Get message details uses the first message id returned using the following expression.

first(triggerOutputs()?['body/value'])?['messageId']

Add a row into a table uses the following expressions for the AMST and message, and userID.

//AMST and message
outputs('Get_message_details')?['body/body']?['content']

//userID
outputs('Get_message_details')?['body/from/user']?['DisplayName']

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

[marenmor]

I use the exact same flow and have two questions.

1. I want the flow to add a row in an excel table whenever someone types a 6 digit case number in the group chat. The case number is random, so I can't specify a number as the keyword to search for. So group members will have to type another keyword together with the number, i.e. "deb 123456". Or - isthere a way to make it so you don't have to?

2. I use the exact same expressions, and this is what the table looks like after the flow runs. How do I get rid of the <p>? Ideally I only want the number in this column.

[marenmor]

Yet another question: is it possible to make it so that group members only have to type the case number? That "deb" will be default first word (maybe even greyed out) in new chat message?