Answered

Condition Support

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a Gallery. I have a Toggle. I need a condition.

If the Gallery returns ONLY one item, and that item CQTitle is 'Bus Driver' the Toggle.Visible should default to 'false' else 'true. The following is not giving me the desired result.

I have this in the Toggle Visible:

(CountRows(ECMmbrCQSmryGallery.AllItems.CQTitle) =1 & (ECMmbrCQSmryGallery.Selected.ECMmbrCQTitleFld.Text="Bus Driver")

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Change your formula to the following:

(CountRows(ECMmbrCQSmryGallery.AllItems)=1 &&(ECMmbrCQSmryGallery.Selected.ECMmbrCQTitleFld.Text="Bus Driver")

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I put this in; I can still see the control I want hidden when the condition present.

Condition should say Gallery returns one line, with Park Structural Fire Coordinator only, default the field 'Compliance Status' label to Visible.false (or hidden). There are several 'free-floating' field that don't need to be seen when this condition is true.

(CountRows(ECMmbrCQSmryGallery.AllItems)=1 &&(ECMmbrCQSmryGallery.Selected.ECMmbrCQTitleFld.Text="Park Structural Fire Coordinator"))

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous

So from your ScreenShot, that formula is valid...There is one row in the Gallery and the selected (assumed because there is only one row) has "Park Structural Fire Coordinator" in it (assumed that is the ECMmbrCQTitleFld control).

However, You are saying you DON'T want that control visible if that condition is met, so change your formula to the following:

!( (CountRows(ECMmbrCQSmryGallery.AllItems)=1 && (ECMmbrCQSmryGallery.Selected.ECMmbrCQTitleFld.Text="Bus Driver") )

Was this reply helpful? Yes No