Answered

Unhide datacard based on choice from a collection?

(0) Share

Report

Posted on by DGWolfe

Hi all,

I have a simple new form capture. In order to save the user time, there are many questions hidden based on drop downs of other questions throughout the form. No issue here.

However, there is one datacard that is linked to a gallery which collects multiple selections and adds these into a collection, and passes the results back to the datacardvalue (the reason for this was that the choices are over 300 rows of data, so easier to just have a seperate list).

In this seperate list, there is a final option of "Other."

Ideally, if the user selects this option, a second hidden datacard should turn visible allowing the user to put free format text info into the field.

Given "Other" is captured via a checkbox in a gallery and held in a collection, I am a little unsure how to get the visibility aspect of the hidden card to accept "Other" in the collection and turn visible.

Everything I have tried to date has failed. Any suggestions?

Cheers,

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @DGWolfe ,

Try something like the below:

"Other" in Filter(Gallery1.AllItems, Checkbox.Value).ColumnName

This should return true if "Other" is in the items in the gallery which have been checked. Of course you will have to substitute the name of the gallery, the checkbox and the column name with the actual names your are using.

Was this reply helpful? Yes No
DGWolfe on at

Like (0)

Report

Sorry @BCBuizer I am a little lost what you mean?

The gallery has checkboxes inside. The user selects one to as many options as they want, and these options are stored in a collection, then they are concated into the datacardvalue.

I don't filter the gallery at all, as it's just checkbox tool.

Where would I put a filter option for visibility? I can't see how the filter would work in the visibility section of the datacard I want to hide?

DW

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @DGWolfe,

Gallery1.AllItems referencesall the items from the gallery, including the controls that are in there, so that's how you can reference the checkboxes inside the gallery. By then filtering Gallery1.AllItems for those items that have their checkboxes checked (Checkbox1.Value, which will return true when checked), you create a virtual table. By selecting the column which may contain the "Other" value and using the 'in' operator, you create a condition which will return true if "Other" has been selected in the gallery.

Hope this makes sense and you got to try this solution to see if it fulfils your requirements.

Was this reply helpful? Yes No
DGWolfe on at

Like (0)

Report

@BCBuizer sorry, I mean't I don't understand where I am supposed to be placing that filter formula you first wrote about.

All the formula's I have tried to date, are in the "Visible" part of the datacard I am trying to hide.

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @DGWolfe ,

The formula I posted is indeed meant for the Visible property of the datacard you only want to be visible when "Other" has been checked.

Was this reply helpful? Yes No
Verified answer

DGWolfe on at

Like (0)

Report
@BCBuizer Thanks! That makes complete sense now.

I did try that, but still no joy. I did use the "In" operator though, and repointed it to the datcardvalue of the field above and that did the trick!

Solution:
Hidden field:
Visible = If("Other" in DataCardValueXX,true,false)

DataCardValueXX is the datacard above, that collects all the options selected from the collection. 🙂

Thanks again!

DW

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @DGWolfe ,

Great to read you found the solution.

One little tip: the condition itself already returns a boolean, so there is no added value to using the If function:

Visible = "Other" in DataCardValueXX

Was this reply helpful? Yes No