cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Resolver III
Resolver III

Filter dropdown on combination of columns

Hello Y'all,

 

I have a SP list with 2 columns

Available Dates

Available Times

 

i build an app where these dates are normal dropdown values, instead of dates.

i want to filter the 'Available Times' in the 'Available Dates' and only give back when there is no combination of that date and time existing in the list.

 

For example,

 

if i choose the 1st of december, and there already have a row that has that date, with the time 09:00, i want this time to NOT show up in the dropdown.

 

Endgoal: 

 

Have every row be unique, so we have one date and one time per row.

 

Hope you can help, thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @PVosEska ,

 

Thanks, please try this:

Filter(Choices(Interviews. 'Available Times'), !(Value in Filter(Interviews, DateCombobox.Selected.Value in 'Available Dates'.Value).'Available Times'.Value))

 Best regards,

Sik

View solution in original post

3 REPLIES 3
Community Support
Community Support

Hi @PVosEska ,

 

What are the date types of these two columns? What are the items properties of drop-down controls? Can you share some screenshots with your apps?

 

You can refer to this formulas, It doesn't mean this formulas is absolutely right, the exact expression needs more details you need to post. However you can get some reference. 

Filter(<Items of Times drop down>, !(<Field of Times drop down> in Filter('SP list',  DateDropDown.Selected.Value in 'Available Dates').'Available Times'))

The table which needs to be filtered should be Items of dropdown, and logical test statment is to filter out the SP list items first that contains Date drop down selected date, then judge and get all Time dropdown items, that is not in just filtered SP list items.

Hope this can help.

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

 

Sorry, i thought i gave most of the details

 

they are 2 simple choice columns

In PowerApps, they are comboboxes.

 

The formula's for the items are 

 

Choices(Interviews.Available Dates)
Choices(Interviews.Available Times)

 

 

I'm not using forms or anything, just individual boxes.

 

I added the pictures as an attachment.

Hi @PVosEska ,

 

Thanks, please try this:

Filter(Choices(Interviews. 'Available Times'), !(Value in Filter(Interviews, DateCombobox.Selected.Value in 'Available Dates'.Value).'Available Times'.Value))

 Best regards,

Sik

View solution in original post

Helpful resources

Announcements
secondImage

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.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (71,504)