Rule Filed Text Compare Problem

[giancarlo]

Hi

I have a simple rule for filter collect. The advise  blue exclamation and not function.

Refresh('[Access].[Clienti]');;Clear(Clienti1) ;;Collect(Clienti1;(Filter('[Access].[Clienti]'; CodiceUtenteSharepointCliente=Text(User().FullName) && FatturatoAnnoPrecTot=0  &&  FatturatoAnnoCorrente =0 )))

My field CodiceUtenteSharepointClient is in my table SQL

Ps.: i have tried also User().FullName

Thank 

[Meneghino · Accepted solution]

Buonasera Giancarlo.

I would suggest you place a text box. say TextBoxUtente, and set its Text property to User().FullName or User().Email (depending on what CodiceUtenteSharepointCliente contains)

Then you can try this

Refresh('[Access].[Clienti]');;Clear(Clienti1) ;;Collect(Clienti1;(Filter('[Access].[Clienti]'; CodiceUtenteSharepointCliente=TextBoxUtente.Text && FatturatoAnnoPrecTot=0  &&  FatturatoAnnoCorrente =0 )))

This is because otherwise the system may ask for the user identity on every row of your Clienti table, and so works slowly or not at at all.

I assume that CodiceUtenteSharepointCliente is a text field and contains the username or email of the users.

[giancarlo]

Ciao Meneghino

Thank You

Giancarlo