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

nested filter/first/sort/distinct formula no longer works

The following formula used to work with no problem, but it is now showing in error state. It seems to be the Sort syntax that is being flagged as incorrect, but nothing has changed.

 

Filter('Course details',new_swn=SWNTextInput.Text,new_course_start_date=First(Sort(Distinct('Course details',new_course_start_date),Result,Descending)).Result)

 

Course details = entity

new_course_start_date = column name in the Course Details entity

new_swn = column name in the Course Details entity

SWNTextInput = text input cell within the app

 

Any ideas?

2 REPLIES 2
Borton
Level: Powered On

Re: nested filter/first/sort/distinct formula no longer works

Can you provide more info on the error that you are getting (invalid arguments, ect)? Looking at it im not really sure why it wouldn't work now, I could only think to rewrite it another way.

Filter('Course details',new_swn=SWNTextInput.Text,new_course_start_date=First(Sort('Course details',new_course_start_date,Descending)).new_course_start_date)

Im not really sure the Distinct() does anything if you are only using the first result.

Caroline
Level: Powered On

Re: nested filter/first/sort/distinct formula no longer works

@Borton yes, it is an invalid arguement type on the sort function.

I tried your variant, and got the same error.