Add Row Into Excel File With Details From Teams Channel Message

[nabaiscodes]

I need to build a flow that creates a new row in an Excel file, when a message with a specific keyword is posted to a Teams channel.

The flow should work as following:

• Message with keyword "New function" is posted to Teams channel
• Message contains specific words such as "Function name", "Purpose", "Location", etc
• New row is created in Excel file, with the header columns "Function name", "Purpose", etc, filled in with the details from the message
• Members receive an alert message, for example "New function created" (and, optionally, an email)

What's the best flow to achieve this?

[FLMike]

@nabaiscodes 

There are loads of examples of exactly how to do this if you search.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

But high level

1. Use the Trigger for Teams for certain keywords are said "New function" I guess

2. Parse the message however you want to grab things out, using a Compose for each item retrieved

3. Have an excel file in SharePoint or OneDrive, making sure it has a table around the Data/Headers

4. Use an Add a row to a Table action for Excel to write the data

5. Send an Email to whomever you like (you would have to figure out where you store the emails or just hard code)

[v-yetonggu-msft · Accepted solution]

Hi @nabaiscodes ,

Since the 'When keywords are mentioned' control cannot recognize phrases, please separate the phrases with commas or delete the spaces in the phrases.

I did a test for your reference.

In my scenario:

split(split(outputs('Html_to_text')?['body'],'Function name:')[1],'Purpose:')[0]
split(split(outputs('Html_to_text')?['body'],'Purpose:')[1],'Location:')[0]
split(split(outputs('Html_to_text')?['body'],'Location:')[1],decodeUriComponent('%OA'))[0]

My Teams message:

My Excel table:

Best Regards,

Sunshine Gu