cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Need help to sort a date/time column from SP to ascend

Hello!

 

I got this problem where I try to sort on a date/time column (Last contact) from an SP list in Powerapps and for some reason it doesnt work.

 

This code gives no errors but the gallery is just blank:

If('Toggle'.Value;
Filter(
   Sort(
   'Logg';
'Last contact';Ascending);
Agreementarea.Value in "Location1" & "Location2";
Status.Value in "Ongoing" & "Finished"
   );
Filter(
   Sort(
   'Logg';
'Last contact';Ascending);
       Agreementarea.Value in 'Filter agreementarea'.SelectedItems.Value ;
       Status.Value in "Ongoing" & "Finished"
   ))

 

 

What i'm trying to accomplish is that you can filter with a dropdown meny called "Filter agreementarea" or toggle a button and instant get all choices in the agreementarea shown in the gallery

10 REPLIES 10
Anonymous
Not applicable

@v-siky-msft Thank you, this worked! I really appreciate your help with this 😃

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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