Filter Drop-down based on previous rows

[rakhie_urs]

Hi Friends,

I'm creating an app to manage my clinic appointments.

I have a table where users can fill there details and select a time slot from the drop-down which has a list of  available time slots.

Now I want to create a filter expression so that drop-down list only shows remaining slots on particular day. ( An expression which filters slots that are taken in previous rows )

Thanks in advance for your help.

[TeeSee1]

You need to show us your time slots table structure to suggest a filter expression for you.

Most likely something like this

Filter("your time slots table", [assigned] = "NO")

[rakhie_urs]

Appointment filling form Column settings.

I want an expression to be filled in suggested values.

 Referred table that contain list of time slots

 Sheet containing time slots

 

[TeeSee1 · Accepted solution]

I am not sure if your architecture is really scalable...

However, if you want to continue to use what you have then you can try the expression 

SELECT(Timings Physician[Physician], NOT(IN([Physician], [Related Appointment List][When you want to consult physician?]))) 

[rakhie_urs]

Thanks Mate, Your expression worked for me.👍