Thanks for your help on this. I'm having the same issue as the poster and although I try to understand how to change my formulae to add Blank()" not null I'm struggling. I'm not an advanced user. Here is my formulae: Sort(ForAll(Distinct(Table1,SVP), {Result: ThisRecord.Value}),Result). This is for the first drop down box that shows only UNIQUE names. This formulae keeps giving me this warning that is driving me insane: "Error when trying to retrieve data from the network: Expression "SVP eq null" is not supported. clientRequestId:"