Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

If statement - many conditions at the same time

Hi, I know that there are several posts in this, but somehow I don't find answers to my issues. If you could help me on below or redirect to appropriate post.


I have to check many (I even think if not too many, but it appears that people need this because they don't read instructions) conditions rom Combo Box at the same time as in the attachment.


As where the line is in "selected", there should be info to select chosen code. Where "selected" section is missing it should say that code is incorrect. Where "Typed" and "selected" are matching database record - there should be no message. Is tat even possible to check so many conditions?scenarioooos.png



Super User
Super User

Hey! Can you use a Switch, maybe? 

Super User
Super User

It looks to me like you are setting up two comboboxes as the basis for doing filters/lookups on a table in your database. Do you want to have some sort of result come up that depends on the choices in the comboboxes? If so, add a column to your table that contains the result. Then, use the selections off the comboboxes to do a filter/lookup for your result(s). You can include code so that if there are no matching records, some sort of error indication is given to the user. This method offers more flexibility than hardcoding If/Switch statements.


Hope that helps,


Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Hi, not really. This is action based. Depends on what is the input in combo box 1 (both selected nd just typed in), appropriate prompt must appear. And as there are so many scenarios a column in excel is 'too static' for that.

Will try that and share results 😉 Thanks

Helpful resources

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (1,776)