DataCards Conditional Visible based on Multi Select Combo Box

(0) Share

Report

Posted on by Will_Y

I am using a SharePoint list to connect to my PowerApps.

I have a drop down choice of three items

Report Type:

Symptomatic

Tested Positive

Close Contact

Then I have three date fields based on what is chosen in the multi-select drop down. I only want the date fields shown for the selected items. For example if the user selects "Symptomatic" AND "Tested Positive" then I want to have the dates for those two only displayed. Whereas if they select "Tested Positive" only then, I only need to see that one date field.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Can you show a sample of the list showing the columns involved?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (1)

Report
Copy link

Link copied!
Hi @Will_Y ,

You can use conditions like below.
If("Foo" in DataCardValue7.SelectedItems.Value,true,false)

like below for visible properties for DataCard.

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
Will_Y 46 on at

Like (0)

Report
Copy link

Link copied!

Best I can do to explain. PA1 shows the drop down multi-select box in PowerApps. PA2 shows what happens if I select any one of the three choices, I only see one date box show. PA3 (I manipulated the image to make is show what I want) shows how I would like it to display, allowing multiple sections and making visible the date boxes accordingly. Basically I need to put a date to each of the items selected. And the user can select any or all of the items. I have each date box setup with the code:

visible=If(DataCardValue13_1.Selected.Value="Symptomatic", true, false)
visible=If(DataCardValue13_1.Selected.Value="Tested Positive", true, false)
visible=If(DataCardValue13_1.Selected.Value="Close Contact", true, false)

I believe I need a AND OR formula here but not sure how to make it work.

DataCardValue13_1 is the report type data value (multi-select drop down menu).

Thanks!

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (0)

Report
Copy link

Link copied!
Hi @Will_Y

As I understood is.
If the Report Type Is blank or Selected only one Value you Need to Display Only First Datepicker.
SO For First Scenario you can yous like that -
If( IsBlank(DataCardValue13_1.Selected) || DataCardValue13_1.Selected.Value="Symptomatic", true, false).
But if User Select More then One Report Type then you need two another Datepicker else visibility is Hidden for them.

For the Second Scenario, you can use like below.

visible=If(DataCardValue13_1.Selected.Value="Tested Positive", true, false) visible=If(DataCardValue13_1.Selected.Value="Close Contact", true, false)

Was this reply helpful? Yes No
Will_Y 46 on at

Like (0)

Report
Copy link

Link copied!

When I tried that, the date picker for symptomatic is shown when I select symptomatic, but not shown when I select symptomatic AND tested positive or symptomatic AND close contact.

Was this reply helpful? Yes No
Vijay Tailor 2,961 on at

Like (1)

Report
Copy link

Link copied!

That the Reason you have to use In condition.

Please check the below code
If("Foo" in DataCardValue7.SelectedItems.Value,true,false)

Was this reply helpful? Yes No
Will_Y 46 on at

Like (0)

Report
Copy link

Link copied!

Thank you. I guess I don't understand the condition "Foo" or how to make that work for my scenario.

Was this reply helpful? Yes No
Verified answer

Vijay Tailor 2,961 on at

Like (2)

Report
Copy link

Link copied!

This is COndition applicable for your scenario.

If( IsBlank(DataCardValue13_1.Selected) || "Symptomatic" in DataCardValue13_1.SelectedItems.Value, true, false)

If("Tested Positive" in DataCardValue13_1.SelectedItems.Value, true, false)

If("Close Contact" in DataCardValue13_1.SelectedItems.Value, true, false)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This worked for me 🙂 Thank you so much.

Was this reply helpful? Yes No
Will_Y 46 on at

Like (1)

Report
Copy link

Link copied!

I failed to copy over the tested positive and close contact you provided. It absolutely worked! Thank you for all your help.

Was this reply helpful? Yes No