cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KieranHIM
Helper I
Helper I

If condition for amount of numbers

Hello. Wondering if anybody can help with this. I have created a BOT, but I am struggling with an IF condition. I have created the bot on the non coding side. I basically want the BOT to give two different responses to what a user inputs. The user will be asked to confirm a number. If this number is 5 characters or above, the user will be advised one thing and if the user inputs a number using 4 characters or below, they will be advised another scenario by the BOT. Just cant seem to be able to set a condition for this, only giving me the option to set a word as a condition.

 

 

Would appreciate if somebody could provide some feedback on how to do this 😀

29 REPLIES 29
KieranHIM
Helper I
Helper I

Hi @Expiscornovus 

 

 

Thank you, I have changed this now to just have trigger phrases such as 'Emis' and 'CDB Code' etc. However, it is still getting stuck in the middle:-

Stuck.PNG

My compose inputs look like this:-

 

 

Compose1.PNG

The if's stated for each one are:-

 

 

Compose - 

if(lessorequals(length(triggerBody()['text']), 4), 'This appears to be an Emis CDB Org code support by Emis help. Please contact them directly.', if(equals(length(triggerBody()['text']), 5), 'This looks like one of our community codes''6 characters or more'))
 
Compose 2 - Peek Code reads 
{
    "inputs""@triggerBody()['text']"
}
 
Can you spot why it can be still causing it even after this? Thanks for your help Dennis, sorry I am dragging this out and if it is painful for you!
 
 
Kieran😁

 

 

Expiscornovus
Super User
Super User

Hi @KieranHIM,

 

I see that the response of the bot is 'To connect with a person now, click on the following link'. That looks a lot like a response from the Escalate topic.

 

Are you by any chance using the '20198' text as a trigger phrase in the Escalate topic in the same bot?



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


KieranHIM
Helper I
Helper I

Hi @Expiscornovus 

 

I have checked my trigger responses on the escalate topic, but its just the preset ones that teams has given, so not sure why its doing it, I havent set any numbers as trigger phrases elsewhere now, so puzzled as to why its doing it 😶 Would you agree everything that I have shown you looks fine, or do you think there could be something else causing this now that I may have missed?

 

 

Thank you for you help so far again!

 

 

Kieran😀

Expiscornovus
Super User
Super User

Hi @KieranHIM,

 

Thanks for checking the trigger phrases in the escalate topic.

 

I just noticed in the screenshot of your previous reply that the expression in the Power Virtual Agents Template flow is still using the EMIS text instead of the numbers.

 

If you are using CharacterCount is equals to 4 logic you also have to make sure that in the output of your flow it is sending that same number and not the EMIS text. Otherwise the condition action in the topic can't match it and it will always go the all other conditions branch.

 

Can you make sure that you are using this in the compose action:

if(lessorequals(length(triggerBody()['text']), 4), '4', if(equals(length(triggerBody()['text']), 5), '5', '6 characters or more'))

 

I would also add a message action under the All other conditions. 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


KieranHIM
Helper I
Helper I

Hi @Expiscornovus 

 

 

Sorry I thought I updated that, obvuously not! I have updated it now and that expression has been updated. However, on the compose for the output, just want you to check something if thats OK?

 

 

Output Compose.PNG

Should I be inputting the if statement that is in the first compose into the Output?😀

 

 

Thanks Dennis 

 

 

Kieran

Expiscornovus
Super User
Super User

Hi @KieranHIM,

 

Thanks for updating the flow.

 

The value for the CharacterCount field in the Return value(s) to Power Virtual Agents should be the Outputs field from the Compose action with the expression.

 

So, what you currently have in your screenshot looks ok already  🙂



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Hi @Expiscornovus 

 

 

Thank you for that, I think its all set for that as the expression feield in Compose 1 reads 

if(lessorequals(length(triggerBody()['text']), 4), '4', if(equals(length(triggerBody()['text']), 5), '5''6 characters or more'))
 
Compose 2 has InputNumber set with:- 
 
{
    "inputs""@triggerBody()['text']"
}
 
Return Value has CharacterCount with Outputs set as 'Compose' . However, its still coming up with the message 'To connect with a person now, click on the following link: <link>. Not sure why its doing this if all the above is set and is correct? When I confirm a 4 or 5 digit number, its just getting stuck on the Action where its stating the Power Automate input, just doesnt seem to be getting further than that. See below:-
 
Input.PNG
 
Also, below is the code for the output, just incase there is an error in there, but I cannot see one?
 
{
    "kind""VirtualAgent",
    "inputs": {
        "statusCode"200,
        "body": {
            "charactercount""@{outputs('Compose')}"
        },
        "schema": {
            "type""object",
            "properties": {
                "charactercount": {
                    "title""CharacterCount",
                    "x-ms-dynamically-added"true,
                    "type""string"
                }
            }
        }
    }
}
 
 
I am thinking its a simple mistake, but just not sure why its getting stuck at the bit when everything else is set?🤔
 
 
Thanks for this Dennis, this has been a over a couple of days and really grateful for you sticking with me to see it out.
 
 
Kieran
Expiscornovus
Super User
Super User

Hi @KieranHIM,

 

I had a look again at the screenshot of your confirm question. It looks like you typed the NumberVar instead of selecting it from the menu. It doesn't have the gray formatting like in my screenshots.

 

grayformatting.png

 

Can you select it from the menu?

 

canyouselectthevariable.png



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


KieranHIM
Helper I
Helper I

Ah @Expiscornovus  so sorry I must have jumped the gun and typed it all out instead of waiting for the drop down to come. Thats worked. I can now tweek this with certain responses and additonal conditions to certain codes, as I want it to recognise a code that is supported, dont want it to just accept any 5 digit code. Could I just have a list of the ORG codes with 5 digits and have it pull that through and recognise when one of them is being put in, same with the 4 digit codes?

 

 

I think apart from me tweaking that, unless you have any suggestions of how I can do that, I am very happy with this solution and really appreciate your time in helping me sort this honestly, its really helped me out in my new role! Very pleased 😁

 

Kieran

Expiscornovus
Super User
Super User

Hi @KieranHIM,

 

Great to hear that it worked! 😃 Happy to help.

 

Regarding your new question about matching codes in a list, yes that would be possible. I would add more logic to the flow to support that requirement.

 

But maybe it is better to open up a new thread. This way we can help you separately with that new question. Saves other people going through the different pages of this conversation thread 😁

 

 



Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Virtual Agents Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Virtual Agents!

Top Solution Authors
Users online (3,097)