Skip to main content

Notifications

Power Automate - General Discussion
Answered

Power Automate Reply Text Keyword From MS Team

(1) ShareShare
ReportReport
Posted on by 17

I need create flow reply value form excel online to post ms team

 

Ex. Input value "A" to chat

 

Flow automate start searh keyword "A" 

Found value "A" next step get value in row A form excel reply post ms team

 

Ex. Result

- - - - - - 

A

code :

title :

address :

  • BigChao Profile Picture
    BigChao 17 on at
    Re: Power Automate Reply Text Keyword From MS Team

    @trice602 The data I enter and want to search is a combination of numbers and letters, not sure if such flow can work or not. Because your example uses all numbers. For example, "AB12-4567".

  • Verified answer
    BigChao Profile Picture
    BigChao 17 on at
    Re: Power Automate Reply Text Keyword From MS Team

    Thank you for support @trice602 

    Error clear ,i'm not choose message id 

    - - - -

    I have more questions on the Filter Array part, not sure where we can find the "content" variable.

    tmp_52e6a1e5-e277-469e-9f15-ef602f28714c.png

    tmp_0017f3e5-578f-4ec8-8df3-22da3cca9a7f.png

    tmp_0525229f-1cbe-419b-99ce-1e80639a59ba.png

  • trice602 Profile Picture
    trice602 11,729 on at
    Re: Power Automate Reply Text Keyword From MS Team

    Hi @BigChao ,

     

    I got that error the first time also.  Make sure you are selecting the MessageId in the Get Message action.  Always glad to help! Tom

     

    trice602_0-1691934394551.png

     

  • BigChao Profile Picture
    BigChao 17 on at
    Re: Power Automate Reply Text Keyword From MS Team

    Thank you @trice602 

    I try flow you recommend

    flow error get message detail ms team

     

  • trice602 Profile Picture
    trice602 11,729 on at
    Re: Power Automate Reply Text Keyword From MS Team

    Here's the high-level summary of the flow and adaptive card.  Always glad to help! Tom

    trice602_0-1691876895613.png

     

  • Verified answer
    trice602 Profile Picture
    trice602 11,729 on at
    Re: Power Automate Reply Text Keyword From MS Team

    Hi @BigChao ,

     

    Here you go!  Please mark as a solution!  Always glad to help!  Tom

     

    Ok, in my test, I have an Excel table with a table of data, similar to what you are looking for.

     

    trice602_0-1691874525264.png

     

    Here's the entire flow.

     

    trice602_1-1691874583447.png

     

    The next step is to Parse JSON from the Get Message Detail action.  You can copy the JSON and paste it into the Generate from sample by clicking the button.

     

    trice602_2-1691874696635.png

     

    Next you list rows present in a table (self-explanatory) and then you need to use Filter Array.  That's because we need to find the record from the Teams message.  In my example, I am looking up the work order number or an ID number in the ID_No column in my Excel table.

     

    trice602_3-1691874802672.png

     

    Next I Parse JSON from my Filter Array so I can use downstream.  That's so I can paste the actual values returned in my Filter Array from my Excel table row for a given ID#.

     

    trice602_4-1691874863491.png

     

    The last step is to reply with an adaptive card

     

    trice602_6-1691874989657.png

     

    You can get some sample card ideas here: Types of cards - Teams | Microsoft Learn 

     

    Here's a view of my Excel result variables that I am using in my adaptive card message response:

     

    trice602_7-1691875071992.png

     

     

    And this is what my card looks like.  Granted my adaptive card is ugly and I spent ZERO time on it but wanted to get the automation working to return the Excel row for the query.  In this example, the end-user typed in the message 12345 and it returned this row from Excel.

     

    trice602_9-1691875246372.png

     

     

    trice602_8-1691875167757.png

     

     

    Please mark as a solution!  Always glad to help! Tom 🤖

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard