cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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 😀

1 ACCEPTED SOLUTION

Accepted Solutions
Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous,

 

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 #MicrosoftCopilotStudio content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter


View solution in original post

29 REPLIES 29
Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous,

 

You could use a flow action for that. In that action you could use an expression with the length function to count the number of characters. The output of that can be used in the if condition in the topic.

 

Below is an example of that approach.

 

1. Add an action for a flow

 

charactercount.png

 

2. In that flow you can use the length function in a compose.

length(triggerBody()['text'])

 

countnumbersflow.png

 

3. Send the charactercount back to the topic.

output.png



Happy to help out! 🙂

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


Anonymous
Not applicable

Hi Dennis. Appreciate your speedy response. It looks like its going to work, but I am struggling setting the action to have it look like yours does in the example, it looks like this when I try it:-

 

 

PowerInput.PNG

I cant seem to get it like your example where it just has InputNumber (text) gets vaue from NumberVar (text) as its making me type a value in the NumberVar box.

 

Do you also have an example of the flow settings I can work off please? Just want to get it set up where a number is input that is 5 or above, it gives one option, then if it gives 4 or below another, but not sure how to set this in the flow as its my first time of doing this. Sorry if this is asking too much! I think once I have this part sorted, I could then edit the length function. Hope the issue I am having makes sense and again, appreciate if you could help further on this one, thanks for your first response as I said, this looks like its going to do the job, but my inexperience in setting up the PVA Flow's is making me stumble unfortunately😓

 

Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous,

 

Happy to help you out with the rest of the configuration. Can you share a screenshot of the setup of your current flow you are using?

 

In my example the flow has the three actions. In the first action I only have one text input field.

 

By looking at your screenshot you might have two text inputs in your flow Power Virtual Agents trigger action (InputNumber & NumberVar)? 

 

flowinputnumber.png

 

 



Happy to help out! 🙂

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


Anonymous
Not applicable

HI Dennis. Again thanks for your speedy response and offer to help me. I have since looked at your flow charted and edited mine, does this look like its on the correct set up?

 

 

 

 

 

PVA Input Flow.PNGI cant seem to get the option to edit the length input (where you have edited the expression for the trigger response), so it looks different to yours. I think once I have that sorted, then put my number in the equal to condition, should be practicaly there? Again, thanks for taking the time to help me and I hope that screen shot makes sense and you can rectify the issue.

 

 

Kieran 😀

Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous,

 

You should be able to type the expression in the expression tab. 

 

Btw, I am using experimental features, that is why my expression editor interface looks a bit different.

 

expressioneditor_newerversion.png



Happy to help out! 🙂

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


Anonymous
Not applicable

Hi Dennis. Thank you so much! That seems to have sorted it. However, When I have the condition from the Power Automate, it branches off on 'All other conditions' rather than me being able to set two conditions (one will be of the characters equal to 5, one equal to 4). I have attached the screen shot for more information.

 

All other conditions.PNG Appreciate you getting me this far. Once I have this part sorted and can have the condition for both, I think it will be sorted. When I tested one before with the condition set to equal 5, I input a number with 5 characters in however it branched off to the all other conditions and gave the other response.

 

 

 

Thanks 😀

Expiscornovus
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous,


I see that your condition is not configured. Can you make sure you select the CharacterCount text variable and add 5 below the is equal to.

 

Below is my configuration and how it looks when I test it with 5 characters.

 

counttesttopic.png

 

And this would be a test with 6 characters (btw, I added an additional message action in the all other conditions section).

 

not5charactersbut6.png



Happy to help out! 🙂

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


Anonymous
Not applicable

Thank you Dennis! Yeah I put that in and when I put a number with 5 in it stated that it was not 5 characters, but 9? Not sure how its done that when it was equal to 5. I have put the screen shots below. However, When the user puts in a number that equals 5, I want it to give a response of providing informaiton, it will say something along the lines of "this is supported by us" then if the user types a number that is 4 or less, I want it to give a response saying this is supported by another organisation, but not sure how I can do that now with the character count? If you understand what I am after and can assist with this, would be perfect as I think its nearly there, just need it to give the two response depending on the user putting a 5 character number or a 4 character number. See screen shots below to what I can now see when I tested with the bot:-

 

 

Character Confirm.PNGCharacter Confirm 2.PNGError.PNG

Thanks for your help Dennis, hopefully nearly there after this one. Appreciate your thorough help with this one, it means a lot 😀

Anonymous
Not applicable

Apologies. I put a duplicate screen shot in on my latest reply. Below is the screen shot showing the testing with the bot where it said 'Not 5 characters, but 9'

 

 

Error.PNG

Helpful resources

Announcements

Exciting News for Copilot Studio Community! 🌟

Get ready to experience a whole new level of engagement with the Copilot Studio Community beginning this June! We’re thrilled to announce significant enhancements to our Community Blogs and Forums, designed to foster collaboration, creativity, and connection in the Community. 🚀💡   What’s New? 🌟 Revamped Community Blogs: Dive into a more intuitive and enriched blogging experience, where sharing knowledge and insights is easier and more enjoyable than ever. Enhanced Forums: Engage in discussions, ask questions, and connect with peers through our improved forums, now with better navigation and user-friendly features.  Why Check It Out? ✔ Stay Informed: Keep up with the latest trends, tips, and tricks from Copilot experts and fellow community members.Expand Your Network: Connect with like-minded professionals and build lasting relationships within the community.Share Your Voice: Contribute your own stories, solutions, and successes to inspire and educate others.   Stay tuned for more details as we approach the launch date. We can’t wait for you to join us in this new chapter of the Copilot Studio Community. Together, let’s make it a hub of innovation and inspiration!   

Celebrating the May Super User of the Month: Laurens Martens

  @LaurensM  is an exceptional contributor to the Power Platform Community. Super Users like Laurens inspire others through their example, encouragement, and active participation. We are excited to celebrated Laurens as our Super User of the Month for May 2024.   Consistent Engagement:  He consistently engages with the community by answering forum questions, sharing insights, and providing solutions. Laurens dedication helps other users find answers and overcome challenges.   Community Expertise: As a Super User, Laurens plays a crucial role in maintaining a knowledge sharing environment. Always ensuring a positive experience for everyone.   Leadership: He shares valuable insights on community growth, engagement, and future trends. Their contributions help shape the Power Platform Community.   Congratulations, Laurens Martens, for your outstanding work! Keep inspiring others and making a difference in the community!   Keep up the fantastic work!        

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   😊Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!      

Welcome to the Copilot Studio Community!

You are now a part of a vibrant growing group of peers and industry experts who are here to network, share knowledge, and even have a little fun!   If you have not yet registered, please visit here to learn how to register!   Now that you are a member, you can enjoy the following resources:   The Microsoft Copilot Studio Community Forums If you are looking for support with any part of Microsoft Copilot Studio, our forums are the place to go. They are titled "Forums" and there you will find technical professionals with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Copilot Studio Community forums! Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered!   Microsoft Copilot Studio Ideas Do you have an idea to improve the Microsoft Copilot Studio experience, or a feature request for future product updates? Then the "Copilot Studio Ideas" section is where you can contribute your suggestions and vote for ideas posted by other Community members. We constantly look to the most voted Ideas when planning updates, so your suggestions and votes will always make a difference.   News & Announcements The Copilot Studio Community News & Announcements is your stop to get all the latest news around Community events and announcements. This is where we share with the Community what is going on and how to participate!   Copilot Studio Samples, Learning and Video Galleries We have galleries that can assist you with information on creating a bot in our Webinars and Video Gallery,  and the ability to share the bots you have created in our Bot Sharing Gallery.  Check out the awesome content being shared there today!   Again, we are excited to welcome you to the Microsoft Copilot Studio Community family! Whether you are brand new to the world of bot creation or you are a seasoned Copilot Studio veteran, our goal is to shape the Community to be your ‘go to’ for support, networking, education, inspiration and encouragement as we enjoy this adventure together!   Let us know in the Community Feedback if you have any questions or comments about your Community experience. To learn more about the Community and your account be sure to visit our Community Support Area boards to learn more!   We look forward to seeing you in the Copilot Studio Community!The Copilot Studio Community Team

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Users online (5,025)