If Statement with multiple conditions

(0) Share

Report

Posted on by ezi79

166

I have got a combo box which contains values and is multi select enabled. The user can choose one or two items.

I want to show or hide buttons based on the user's selection. The user can choose any two items from the following list:

Project A

Project B

Project C

SAP A

SAP B

No Budget

Budget

Contact award

So for example, if someone chooses any item which includes "project" the project button will become visible and

if someone chooses any item which includes "SAP " the SAP button becomes visible. If they any of the SAP and Project items selected both buttons will be visible

As there are 56 possible combinations using two items from the list above and since there is no difference between the form which will load if Projects A, B or C are selected (and the same for SAP A and B), is there a way I can do this easily without having to cover all 56 combinations?

So far I've tried setting a variable if someone chooses "SAP A" and "Project A" and set it to true using the following statement as an example:

If("SAP" in Data cart selected Items true , Set(var, true))

However, the above statement still reruns the value "False" instead of "True".

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (3)

zmansuri 6,048 Super User 2024 Season 1 on at

Like (1)

Report

Set each button Visible property like this. All combination will be available

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
@ezi79 Place this code in the visible of the Project Button.
IsMatch(Concat(ComboBoxIsMatch.SelectedItems.Value, Value), "Project", Contains & IgnoreCase )

Similarly change the text "Project" to "SAP" etc., and place them in the corresponding buttons. This will take care of all the combinations.

Hope this helps!

Was this reply helpful? Yes No
Verified answer

v-albai-msft on at

Like (1)

Report
Hi @ezi79 ,
You can use Find function to check the result. I did a test on my side for your reference.
1. My combo box is called "ComboBox6":
2. Set Visible property of Project button to:
If(!IsBlank(Find("Project",Concat(ComboBox6.SelectedItems, Value&","))),true,false)

3. Similar, set Visible property of SAP button to:
If(!IsBlank(Find("SAP",Concat(ComboBox6.SelectedItems, Value&","))),true,false)
Here is the result:
Best regards,
Allen

Was this reply helpful? Yes No
ezi79 166 on at

Like (0)

Report

Thank you so much its working saved me lots of time really appreciated

Was this reply helpful? Yes No
ezi79 166 on at

Like (0)

Report

Thank you so much this solution also working for my scenario

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@ezi79 Glad to help!

Was this reply helpful? Yes No
ezi79 166 on at

Like (0)

Report

I got another combobox within the same form and choices are different than the combo box above
combobox contains items such as and user should only select one item
- PIC paper
- Programme & project authority drawdown
- Programme & project risk drawdown
- Project initiation & business case
- Budget change control
- Unbudgeted transaction

How do I combine this formula IsMatch(Concat(ComboBoxISMatch.SelectedItems.Value,Value), "Project", Contains & IgnoreCase with the values above so if I choose one of the items above it will also make project button visible?

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (1)

Report
@ezi79 The key in the formula I gave you is the text within quotes. E.g. "Project" or "SAP". If you want to check for multiple texts, you can use this formula (add as many as you want),
Or(IsMatch(Concat(ComboBoxIsMatch.SelectedItems.Value, Value), "Project", Contains & IgnoreCase ), IsMatch(Concat(ComboBoxIsMatch.SelectedItems.Value, Value), "Programme", Contains & IgnoreCase ), IsMatch(Concat(ComboBoxIsMatch.SelectedItems.Value, Value), "Budget", Contains & IgnoreCase ) )

Please remember to give a 👍 and accept the solution as it will help others in the future.

Was this reply helpful? Yes No