cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JakobDahl
Level: Powered On

Chaining operation doesn't work - Expected an operator

Hello everyone,

 

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

chainingoperation.png

Kind Regards

Jakob

1 ACCEPTED SOLUTION

Accepted Solutions
Thomas_B
Level: Powered On

Re: Chaining operation doesn't work - Expected an operator

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

View solution in original post

2 REPLIES 2
Thomas_B
Level: Powered On

Re: Chaining operation doesn't work - Expected an operator

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

View solution in original post

Highlighted
JakobDahl
Level: Powered On

Re: Chaining operation doesn't work - Expected an operator

Perfect, that worked! Smiley Wink

 

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

Have a nice day! Smiley Very Happy

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,844)