Unanswered

Power Apps hide field based on table value yes/no

(0) Share

Report

Posted on by Dodovi

I'm trying to make invisible a label when a field choice is NO

The field choice is a simple Yes or No value, I already tried with this function DataCardValue7.Selected.Value = "YES" but for powerapps this is an error

I have tried all possible solution except the one you are going to provide me.

The function is in the Visibile Property and for this reason the datacardvalue7 value has to be yes for my idea to work.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Prabhakar_S 735 Moderator on at

Like (1)

Report
Hi @Dodovi ,

If your field is a choice field with options "Yes" and "No," and you want to make a label invisible based on the selection, the code you've entered is correct in the Visible property:

DataCardValue7.Selected.Value = "Yes"

It might be due to that "Yes" is spelled exactly as it is in your choice field. Power Apps is case-sensitive, so "Yes" and "YES" are treated as different values.

If you're still encountering issues, ensure that your DataCardValue7 is indeed a choice field, and its Selected property is used correctly. If it's not a choice field, and you're dealing with a text input or other control, you might need to adjust your formula accordingly based on the control type and how you store the "Yes" and "No" values.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

Was this reply helpful? Yes No
Dodovi 8 on at

Like (0)

Report

I Have tried using YES and Yes, but it doesn't work. You were suggesting to adjust the formula accordingly based on the control type, how should i do that?

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Hi @Dodovi,

When using a SharePoint list as your form datasource, the Yes / No field will most likely be a Toggle. In this case you can use the following Visible property for your label:

DataCardValue7.Value

When using Dataverse and the default Yes / No choice column, you will have to refer to the option set name, this will be similar to 'ColumnName (TableName)':

DataCardValue7.Selected.Value = 'ColumnName (TableName)'.Yes

When writing your column name Power Apps intellisense will most likely display the choice set name. For example: My testing table is called 'Sign Ins' with a column named YesNo, my option set name would be 'YesNo (Sign Ins)'.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No