Unanswered

Show Current Events from Drop Down in List

(0) Share

Report

Posted on by patty6

Hello!

I have created a drop-down that is attached to a list of events. It currently is a Choice() field. It is currently displaying all events including previous events. I want the drop-down only show events that are greater than the current date.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Hi @patty6 ,

Assuming your data source is SharePoint, your Choices column is Single selection only, and by "Current Date" you mean a selected date (e.g. from a Date Picker control), you could try the below (non-delegable) expression on the Items property of your Dropdown control:

Distinct( Filter( 'Your Data', 'Your Choice Column'.Value, 'Your Date Column' > DatePicker1.SelectedDate ), 'Your Choice Column'.Value )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
patty6 18 on at

Like (0)

Report

by Current Date, the user would not select it would be automatic.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Sample principle except you will use Today():

Distinct( Filter( 'Your Data', 'Your Choice Column'.Value, 'Your Date Column' > Today() ), 'Your Choice Column'.Value )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No