Answered

Setting the Visible property of a Gallery field based on a LookUp with filter is not working. Not getting an error message.

(0) Share

Report

Posted on by cpill1220

Hello. I have Gallery being used for data entry with multiple dropdown and text input fields. I have 1 text input field that I want to set the Visible property for based on a SharePoint List column value, and to get the correct record from the SharePoint List I need to filter it on 2 of the Gallery dropdown selections. Here's what I've entered in the Visible property box for my text input field:

If(LookUp(Filter(Daily_Sheet_Filters, STATE=ddState_2.Selected.Result && ICODE = ddICode_2.Selected.Result),Anchored, true), true, false)

There's no error message on the formula, but the field's Visible property is remaining 'false' even when I select a STATE and ICODE in the designated Gallery dropdowns that have a corresponding "true" value in the SharePoint List's Anchored column. In SharePoint, the Anchored column presents as a checkmark (or no checkmark) and believe Power Apps sees that as true/false, right?

Thank you for any guidance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
the yes/no column can be finicky and really shoudl be avoided if you can, a simple text column set to "true" or "false" would give same functionality and be easier to use.

might try this for your formula in the Visible, see if it works.

Switch( IsEmpty(Filter(Daily_Sheet_Filters, And(STATE=ddState_2.Selected.Result,ICODE = ddICode_2.Selected.Result))), false, First( Filter( Daily_Sheet_Filters, And(STATE=ddState_2.Selected.Result, ICODE = ddICode_2.Selected.Result )) ).Anchored, false)

or even MAYBE this, not 100% sure if the anchored column will read properly for it but worth a try as very clean

!IsEmpty(Filter(Daily_Sheet_Filters, And(STATE=ddState_2.Selected.Result,ICODE = ddICode_2.Selected.Result, Anchored)))

as the visible code

Was this reply helpful? Yes No
cpill1220 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Wow. So grateful for the quick solution! The first formula did the trick. Thank you!

Was this reply helpful? Yes No