“not operator along with the custom named condition operators is not allowed” Operator <> or NOT In. In and Exactin For example in an Items of Gallery : With(
{
userlevel_isnot_banker: First(colSession).UserLevel <> "Banker",
isnotteamhead: First(colSession).CurrLevel <> "RO",
isnotbanker: First(colSession).CurrLevel <> "Banker",
ro: First(colSession).CurrTeam,
banker: First(colSession).CurrBanker,
},
Filter(
WAM_Trade_Summarizes,
FinalDate_yyyymm in ComboBoxTradeFinalDate.SelectedItems,
(isnotteamhead || RO_gb=ro),
(isnotbanker || GroupBanker_gb=banker),
(userlevel_isnot_banker || (
Statement_prod_type_gb <> "Extra Rate" &&
Statement_prod_type_gb <> "Management fee" &&
Statement_prod_type_gb <> "Error"
))
)
)
![[PowerApps] Display Dates in a Combo Box, Distinct not Showing all Records, Filter on Date won’t…](https://miro.medium.com/v2/resize:fill:224:224/0*VSbhtLWtbBLk8i2p.png)
![[PowerApps] Display Dates in a Combo Box, Distinct not Showing all Records, Filter on Date won’t…](https://miro.medium.com/v2/resize:fill:160:112/0*VSbhtLWtbBLk8i2p.png)
