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

Drop-Down Items not Showing with Filter

Hi all,

 

I am currently working on an application to manage meetings. On one of the screens I would like to use a drop-down where the items within it are filtered based on meetings that haven't been saved and filter out the meetings that are still in the future:

 

Sort(Filter(Meetings, Saved = "No", 'Start Time' < Today()),'Start Time',Descending)

 

"Saved" is a Yes/No Column, "Start Time" is the beginning (hour +date) of the meeting. As can be seen this is then sorted by the 'start time' of the meeting in a descending way. Only problem is that this doesn't work. I get a delegation error, however, I only have about 10 items in my meetings list on SharePoint. And when I use the following formula (without filtering out the future meetings):

 

Sort(Filter(Meetings, Saved = "No"),'Start Time',Descending)

 

Then it works without a problem! Only thing is I don't want to be able to select future meetings here.

 

Kind regards,

 

Chris

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisBenT
Level: Powered On

Re: Drop-Down Items not Showing with Filter

Ok, now I tried filtering on the date first and then on the Saved column and oddly enough this works.

View solution in original post

5 REPLIES 5
panand99
Level 10

Re: Drop-Down Items not Showing with Filter

Hello Chris,

 

You can use Collection of your list instead of direct list.

First you have to create a collection - OnVisible of screen  - ClearCollect(collMeetings,'Meetings') 

 

Then, Your formula should be:

 

Sort(Filter(collMeetings, Saved = "No", 'Start Time' < Today()),'Start Time',Descending).

 

Please mark this solution as solved if it solved your issue.

 

Thanks,

Prashant

ChrisBenT
Level: Powered On

Re: Drop-Down Items not Showing with Filter

Hey @panand99,

 

I tried your solution:

 

image.pngOnVisible

image.pngItems of dropdownSadly the drop-down is still empty.

 

KR,

 

Chris

panand99
Level 10

Re: Drop-Down Items not Showing with Filter

 

Please try this 

Sort(Filter(collMeetings, Saved = "No", 'Start Time' < Today()).Start Time,'Start Time',Descending).

ChrisBenT
Level: Powered On

Re: Drop-Down Items not Showing with Filter

I tried this as well and it didn't work. Plus, when doing so the all my other items referencing the drop down had an error all of a sudden.

ChrisBenT
Level: Powered On

Re: Drop-Down Items not Showing with Filter

Ok, now I tried filtering on the date first and then on the Saved column and oddly enough this works.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,523)