Apologies as I first asked this inside another poster's question because it's the same issue! But my comment/issue appears as an answer so I don't think it will be "answered"
I built a Power App with 5 dependent drop down boxes that worked great until last year. The app connects to an Excel database where many values are duplicated, so I am using Distinct to pick UNIQUE values for a column called SVP:
Sort(ForAll(Distinct(Table1,SVP), {Result: ThisRecord.Value}),Result)
.
This formulae keeps giving me a warning that is driving me insane: "Error when trying to retrieve data from the network: Expression "SVP eq null" is not supported. clientRequestId:"
How can I get rid of it, or can I?
Thanks for any insights!
All The drop down boxes in the Power App still work but I get 3 or 4 warnings (for 3 or 4 different drop down boxes) "Error when trying to retrieve data from the network: Expression "SVP eq null" is not supported. clientRequestId:"
I would like the warning to go away...