Answered

Hide button based on value in dropdown

(0) Share

Report

Posted on by joshieboy

519

I have a dropdown field called IsSubmission_IIN and it is a Yes/No field. A button is also on the form that is hidden, if the dropdown field is blank OR if the field value is No. This is the formula I have on the visible property of the button:

If(IsBlank(IsSubmission_IIN),true,false)Or If(IsSubmission_IIN.Selected.Value="Yes",true,false).

This seems to be working in preview mode of the app but once I publish the app and try it on a form, the form loads with the hidden button already displayed, and only becomes hidden if I change the value in the dropdown to No, or if I remove the value and leave it blank again. I'm not sure what can be causing this behavior.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @joshieboy ,

You just need this

Len(IsSubmission_IIN.Selected.Value)=0 || IsSubmission_IIN.Selected.Value="No"

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
joshieboy 519 on at

Like (0)

Report

Hi @WarrenBelz - thanks for your prompt response. I am getting the same behavior with the above formula. The Yes/No field is a choice field from SharePoint. I'm not sure if that makes a difference. But when its blank the button still shows, it hides if its set to No, and shows if it sets to Yes. The blank is the only issue where it should also hide the button

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report
Hi @joshieboy ,

I must admit I struggled a bit with exactly what you needed - this should do it if you simply want to show it if the dropdown is "Yes"

IsSubmission_IIN.Selected.Value="Yes"

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
joshieboy 519 on at

Like (0)

Report

Ah yes yes @WarrenBelz - I can't believe this was so simple. Thank you. Works well now.

Was this reply helpful? Yes No