cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Charles_Antoine
New Member

Extract data from trigger phrases

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

3 REPLIES 3
DiegoPeres
Resolver II
Resolver II

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

 

DiegoPeres
Resolver II
Resolver II

@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

 

fchopo
Super User
Super User

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

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (1,415)