Chaining operation doesn't work - Expected an operator

[JakobDahl]

Hello everyone,

Can someone explain to me why the chaining operation below is invalid? - i've tried with both operators: (; and ;;)

Kind Regards

Jakob

[Thomas_B · Accepted solution]

Hi @JakobDahl

If i'm right you put this operation in an Item field which can't work like that.

In this kind of field you have to put a result or a table as only possible operation.

You could try something like this:

If(SortByNavn = true;

     Sort(

          Filter(Onboarding_1;Ansættelsesdato>Now());

          Navn;

          Ascending);

     SortByTitel = true;

     Sort(

          Filter(Onboarding_1;Ansættelsesdato>Now());

          Titel;

          Ascending);

     SortByAnsatdato = true;

     Sort(

          Filter(Onboarding_1;Ansættelsesdato>Now());

          Ansættelsesdato;

          Ascending);

)

Hope this will help you

[JakobDahl]

Perfect, that worked! 

I was indeed using this operation in an item field in a gallery, thanks for the explanation. 

Have a nice day!