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 Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,274)