Unanswered

Make a "Comment" field Visible if ANY selection is made from a Drop Down in Sharepoint list.

(0) Share

Report

Posted on by Newatthisstuff

I am looking for a little guidance with a Sharepoint list. I created a form with a dropdown list named Reason Code with 13 options. I am trying to make a text box named Comment visible when any of the Selections are made. I got it to work with one Selection by using

If(DataCardValue11.Selected.Value = "Training",true,false), but I need to make it visible with any Selection.

I've tried

If(DataCardValue11.Selected.Value = ("Training", "Other"),true,false) with parenthesis and brackets. Neither worked.

Any help would be appreciated. I have attached 2 screen shots. One with the "Comment" box closed (default). One with the "Comment" box open due to "Training" being selected.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
You might try ISBLANK

If(!ISBLANK(DataCardValue11.Selected.Value),true,false)

*Edit* I just tested this and for my dropdown it worked with the following:

If(!IsBlank(Dropdown2.Selected.Result),true,false)

Was this reply helpful? Yes No
Newatthisstuff 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for responding. How do I find the Dropdown name? (ex. Dropdown2) What property do I put that on? I put the original code on the Comment data card under Visible so it would trigger off of the Reason Code data card selection Training.

Was this reply helpful? Yes No
Newatthisstuff 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I got it to work using
If(IsBlank(DataCardValue11.Selected.Value),false,true). Thank you for pointing me in the right direction.

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Glad you got it to work! You can help others to find the answer in the future by marking it as a solution. ^__^

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Newatthisstuff, glad you were able to get it to work.

As a quick tip: in the majority of cases you can remove the If() statement when it returns true or false.
Especially once your app becomes more complex, these small improvements do add up.

//returns true if it is not blank, else false !IsBlank(DataCardValue11.Selected.Value)
This will have the same effect as If(IsBlank(DataCardValue11.Selected.Value),false,true) but requires less code and increases readability.

I hope this helps!

Was this reply helpful? Yes No