Unanswered

Need help with the RegEx in pva

(0) Share

Report

Posted on by CooolinG

Hello there,

Forgive me for maybe asking in the wrong place, but I have been struggling with writing the Regex for what should be a very simple entity in microsoft PVA.

I'm trying to create an entity that searches for a pattern of 'Z.123456' with the Z being case-insensitive. So far, everything points towards (?i)[Z.][0-9]{6} being the right pattern, but sadly it's only returning the result when I input a lowercase z. I have been trying this for the better part of a week without any succes. What am I doing wrong here?

Thank you in advance

Categories:

Building Copilot Studio chatbots in Microsoft Teams

I have the same question (0)

All responses (12)

Answers (0)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
Since you only want the one character to be case insensitive I don't think you want the square brackets around the Z. This worked for me

(?i)Z.[0-9]{6}

Was this reply helpful? Yes No
CooolinG 10 on at

Like (0)

Report

Thank you for replying. Unfortunately I am still getting the 'I did not understand that' return when I try this option. That's what's bothering me so much about this, everywhere I look results in me thinking the Regex will work, but once I enter it in PVA it doesn't.

Could it be something with the specific Regex PVA uses? (Just spitballing, I'm not that good at this)

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

I tested and it works for me. Here's my Regex entity

And here's the testing of the bot with an unsuccessful run and two successful entries.

Was this reply helpful? Yes No
CooolinG 10 on at

Like (0)

Report

How strange.. I'll add some screenshots too, to show you what I mean. Excuse it being in another language, but here they are:

My return message. Translated it say something along the lines of: "Unfortunately, I didn't understand that." And then it asks again.

This is my Entity regex:

I'm really not seeing what I am doing different from you. Apologies.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

Can you show me the configuration of your Regex entity and the authoring canvas where you are checking. The message is the same as the one I get when I enter a value that doesn't match the regex expression.

Was this reply helpful? Yes No
CooolinG 10 on at

Like (0)

Report

Is this what you mean by authoring canvas?

And this by configuration of my regex entity? Pardon me but I'm not an english native so I might misinterprit some things.

Was this reply helpful? Yes No
CooolinG 10 on at

Like (0)

Report

It does recognize results with a lowercase 'z', if that information helps in any way.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
It looks like you are using the exact same pattern and steps that I am and it works perfectly for me. Unless the separators or punctuation are different in Europe, and I don't think it is for Regex, I don't see why its not working for you. Especially since it recognizes the lower case z but not the Uppercase one.

The other pattern you could try would be

[z,Z].[0-9]{6}

It doesn't use the case insensitive option. Instead it says it starts with either a z or Z, followed by a period and 6 digits.

Was this reply helpful? Yes No
CooolinG 10 on at

Like (0)

Report

I suppose I'm just giving up on PVA then. Even your last suggestion does not yield results.. It must be something within my PVA settings, because as we've tested, every solution that SHOULD work, sadly doesn't. Thanks for all your help so far. I hope there's a solution to be found somewhere.

Was this reply helpful? Yes No
Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @CooolinG & @Pstork1,

Don't know if it helps.

But I can reproduce the issue when I create a bot with the same custom regex entity and pattern within a PVA with Dutch (NL) language.

When I create the entity in a PVA with English (US) language the regex pattern (?i)Z.[0-9]{6} works fine with Z.123456.

Was this reply helpful? Yes No