Eu tenho uma base de 50000k de registros e não estou conseguindo espelhar os dados, já fiz todos os metodos possiveis, não esta reconhecendo minha coluna de id como numero, conseguem me ajudar?
The issue if you are doing a Value function which is not delegatable, so do this
With(
{ID_ESPHELHOToNumber: Value(ID_ESPELHO) },
Now add your Concurrent In here, BUT change where you have Value(ID_ESPELHO) replace that entire thing with ID_ESPHELHOToNumber
);
That should solve your problem as now you are creating the value outside of your filter, which will be delegatable.
Example
ClearCollect(dados1,
Filter(Base_URR_1, ID_ESPHELHOToNumber >= And ID_ESPHELHOToNumber < 3999)
);
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.