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

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
Highlighted
Anonymous
Not applicable

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
Highlighted
Skilled Sharer
Skilled Sharer

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

Highlighted
Anonymous
Not applicable

Re: Drop-Down Items not Showing with Filter

Hey @panand99,

 

I tried your solution:

 

OnVisibleOnVisible

Items of dropdownItems of dropdownSadly the drop-down is still empty.

 

KR,

 

Chris

Highlighted
Skilled Sharer
Skilled Sharer

Re: Drop-Down Items not Showing with Filter

 

Please try this 

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

Highlighted
Anonymous
Not applicable

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.

Highlighted
Anonymous
Not applicable

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
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,795)