web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : ukYGP1u/rBCWr4g/mbhVCk
Copilot Studio - General
Unanswered

Extract data from trigger phrases

Like (0) ShareShare
ReportReport
Posted on 3 Oct 2021 17:42:32 by 2

Hello,

 

I created my first bot to get info about customers cases and it works correctly with the trigger "case" and then I give the case number.

 

My question is : is it possible to trigger with "case 12345" and detect the topic "case" then extract 12345 from the trigger phrase and reply with the info about this case ? This would merge 2 messages into 1.

 

I hope my goal is clear, thank you for any help,

Best regards,

Charles-Antoine

Categories:
  • fchopo Profile Picture
    7,972 Moderator on 08 Oct 2021 at 09:35:11
    Re: Extract data from trigger phrases

    Hi @Charles_Antoine 

    You could use Regular Expression entities: Regex (regular expression) entity support in Power Virtual Agents | Microsoft Power Virtual Agents

    The idea would be to create an entity (Case ID) based on a regular expression: Create and use entities - Power Virtual Agents | Microsoft Docs so PVA can detect it.

    Hope it helps!

    Ferran

     

  • DiegoPeres Profile Picture
    327 on 03 Oct 2021 at 18:24:02
    Re: Extract data from trigger phrases

    @Charles_Antoine 
    I'm Sorry, follows the example:

    System sends the text:
    Incident INC123456 was opened
    VarString = System text
    Compose= substring(variables('VarString'),12,9)
    Output Compose: INC123456


    Did I answer your question?😉
    Please consider accepting it as the solution to help other members find you faster.


    Like my answer?


    Like it! 👍



    Thanks!
    Diego Peres,
    Connect with me: Linkedin

     

  • DiegoPeres Profile Picture
    327 on 03 Oct 2021 at 17:47:44
    Re: Extract data from trigger phrases

    Hi @Charles_Antoine;

    I use Power Automate to do this, example:
    I have a trigger that servicenow sends me the incident number in a string " INCXXXXXXXXX incident was created",
    with that I compose a Json, where I use a substring to get only the "INCXXXXXXXX" because that is what I do the incident validations with.

     


    Did I answer your question?😉
    Please consider accepting it as the solution to help other members find you faster.


    Like my answer?


    Like it! 👍



    Thanks!
    Diego Peres,
    Connect with me: Linkedin

     

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

Announcing our 2025 Season 2 Super Users!

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 169 Super User 2025 Season 2

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 150

#3
sandeep_angara Profile Picture

sandeep_angara 75 Super User 2025 Season 2

Loading complete