Answered

List, powerapp form, conditional, show fields if dropdown column in list has specific data in

(0) Share

Report

Posted on by slewis1972

Hi All

Struggling here so need a hand. So, got a Sharepoint list that has a dropdown column for selection eg poster, photograph, banner etc

I have some columns in form I only want top show based on certain selections eg if they select poster, it shows the poster size.

Anyway, using the visability option in powerapps, and set the visability on the poser size box to:

If(Value(DataCardValue1)='Poster',true)

I get an error. Trying different formats but no go so above could be wrong. Problem I am facing is that the dropdown selection is in the list. and never used that way before with a dropdown but need to in this scenario.

Any help appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

mdevaney 29,989 Moderator on at

Like (0)

Report
@slewis1972
If you are using a dropdown control this code should be what you put in the Visible property instead.

DataCardValue1.SelectedText='Poster'

If you are using a combobox control instead youll need to use

DataCardValue1.Selected.your_column_name='Poster'

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

Was this reply helpful? Yes No
slewis1972 47 on at

Like (0)

Report

Thanks but I get invalid argument type when I place that in the invisable proerties box.

Its definately a dropdown box as triple checked the properties of the column. This column is in the actual list and not a separate dropdown in the powerapp form.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report
@slewis1972
Can you please show a screenshot with this code in the Visible property and the error message showing? I think this will help me understand what is going on.

DataCardValue1.SelectedText='Poster'

Was this reply helpful? Yes No
slewis1972 47 on at

Like (0)

Report

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report
@slewis1972
I didn't notice we were using single quotes on the word Poster. Lets try changing them to double quotes.

DataCardValue1.SelectedText="Poster"

Was this reply helpful? Yes No
slewis1972 47 on at

Like (0)

Report

Same issue, also thought similar and been trying to see what took and atleast changed the error.

Column is defintely in the actual list
Display choices using: Drop-Down Menu
Radio Buttons
Checkboxes (allow multiple selections)

Appreciater your help, been driving me mad all morning.

Was this reply helpful? Yes No
Verified answer

slewis1972 47 on at

Like (0)

Report

Sussed it...

DataCardValue1.Selected.Value = "Poster"

Seems to have worked I think.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@slewis1972
Glad we fixed it! Lets close this topic.

Was this reply helpful? Yes No