I've had tremendous help and support from many in this community (especially @WarrenBelz ) to get this far updating our power apps application, but have hit another roadblock.
In my app, I am filtering and displaying rows from a Sharepoint List that contain a specific Manager's name in the dropdown menu (ManagerDropDown). If the dropdown is empty, then it would display all content, regardless of the Manager. This part is working great. The other parts that are working great are the Checkbox (FlagCheckbox), which displays additional rows that have this value set to "true" and the SearchInput1 search box.
However, what I cannot seem to get working is when any row from the same SPList has a value set to "true" for the "CU_DirectorHold" field (Type: Yes/No) in SPList. What I would like to do is also display that row/content that matches the selected Director's name in the "DirectorDropDown" dropdown list when the value "CU_DirectorHold" is "true" in SP (regardless of what's in the "ManagerDropDown" dropdown list)
Below is the sub-set of the filter code that is working so far, with the exception of the last "If" statement. That code is not working properly and I'm not exactly sure how to include that. I started with adding "&& OR" ( along with the If statement) but nothing returns any value:
Filter(
Filter(
LargeSPList,
Or(
IsBlank(ManagerDropDown.SelectedItems),
IsEmpty(ManagerDropDown.SelectedItems),
CU_Manager in ManagerDropDown.SelectedItems
) && Or(
If(
FlagCheckbox.Value = true,
Flag = true,
If(
FlagCheckbox.Value = false,
Flag = true || Flag = false
)
)
//// Below If statement does not work
) && Or(
If(
CU_DirectorHold = true,
CU_Director in DirectorDropDown.SelectedItems
)
)
),
SearchInput1_1.Text in Title || SearchInput1_1.Text in Notes
)
would anyone have any ideas how I can code this portion?
Many thanks in advance!
