Answered

A field appears only if three other fields are set to specific values

(0) Share

Report

Posted on by Colsen

I have a PowerApps form that pulls fields from a SharePoint list. I would like for the Major Incident question (highlighted in my screenshot) to ONLY appear if the following fields are set to these specific values:

Type of Request = KBA Request
What type of KBA request are you submitting = New KBA
- or if this same field = Update KBA
Is this a standard or emergency request = Emergency

This is the formula that I thought would work in the Visibility Property field for the MI question, but it's not working.

If(DataCardValue61.Selected.Value="KBA Request"||DataCardValue104.Selected.Value="New KBA"||DataCardValue104.Selected.Value="Update KBA"||DataCardValue62.Selected.Value="Emergency", true, false)

TIA for the help!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Colsen

DataCardValue61.Selected.Value="KBA Request"|| DataCardValue104.Selected.Value="New KBA"|| DataCardValue104.Selected.Value="Update KBA"|| DataCardValue62.Selected.Value="Emergency"

Lose the If(), the above reduces to either true or false.

Was this reply helpful? Yes No
jriemsma 11 on at

Like
a
(0)

Report
Copy link

Link copied!

A double pipe || is an OR. You need a couple of && AND statements right?

If(DataCardValue61.Selected.Value="KBA Request" && DataCardValue104.Selected.Value="New KBA"||DataCardValue104.Selected.Value="Update KBA" && DataCardValue62.Selected.Value="Emergency", true, false)

Was this reply helpful? Yes No
Colsen 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Your formula is close, but it's not fully working.

I copied and pasted your formula in the visible property field and it works perfectly when I select Update KBA, but when I select 'New KBA' that MI field appears when the standard/emerg. request field is blank and when I select standard. (see photo attached)

I thought maybe changing the order may work so I tried the below formula and the reverse happened. When I select New KBA everything worked perfectly and Update KBA became the issue.
If(DataCardValue61.Selected.Value="KBA Request" && DataCardValue62.Selected.Value="Emergency" && DataCardValue104.Selected.Value="New KBA"||DataCardValue104.Selected.Value="Update KBA", true, false)

Was this reply helpful? Yes No
Colsen 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the reply, but unfortunately, this didn't work.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Colsen

Please consider changing your Formula to the following:

DataCardValue61.Selected.Value="KBA Request" && DataCardValue104.Selected.Value in "New KBA|Update KBA" && DataCardValue62.Selected.Value="Emergency"

@Drrickryp had the point that you don't need all the redundant If...true...false syntax. The above formula will result in either true or false. There is no point to see if something is true and then return true...it already is true!

I hope this is helpful for you.

Was this reply helpful? Yes No
Colsen 10 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes - Thank you very much. Your formula worked.

Was this reply helpful? Yes No