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.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Next Wednesday, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 52 members 4,186 guests
Recent signins:
Please welcome our newest community members: