Get message from teams (multiple values) and return data to the chat

[Robotech12]

Hil, thank you all;

I have a working flow that takes an OPP-XXXXXXXXXX(10 digits) from a group teams chat, and then returns the Deal details such as : Status, Date, Owner (from an Excel file)

Message examples:

I need to discuss OPP-XXXXXXXXXX

I want to review OPP-XXXXXXXXXX

but I am not sure how to indicate Power Automate to look up for 2 Opp, for instance when a message such as below is received:

"I want to discuss OPP-XXXXXXXXXX and OPP-XXXXXXXXXX"

For the moment the flow just looks and returns for 1 OPP ,  but not for 2 or more. Is there a way to do it?

[ChristianAbata]

hi @Robotech12  for the first OPP it's good to use find text action but for the second I'll recommend you to use lastindexof 

[Robotech12]

Thank you @ChristianAbata , but I forgot to add, would this method work it there 3 or more? thank you

[ChristianAbata]

hi @Robotech12  for more you need to first count how many times the word appear here: Solved: Counting a specific word on a text (Power Automate... - Power Platform Community (microsoft.... and you could use that number to then use nthindex to get the possition 

[Robotech12]

Thank you, I am updating the flow, but not sure in which part to put it? would it be possible to guide? @ChristianAbata 

Specifically the part from:

: Solved: Counting a specific word on a text (Power Automate... - Power Platform Community (microsoft.... 

thank yiu