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



Community Champion
Community Champion

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

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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
Top Kudoed Authors
Users online (1,871)