several conditions in filtering

[HothaifahHijazi]

Dear Friends, 

i want to display Dr Name based on the controls of day, Room.No and Timming ( see the attachment) 

what is the formula can do this 

[Filsdegandalf]

Hello @HothaifahHijazi ,

Do you have the filter criterias linked to your Dr Name in your database?

What's the datasource?

Regards

[HothaifahHijazi]

Datasource is a table for the weekly distribution of clinics in the hospital

as in the attachment :

[Filsdegandalf]

it seems that your attachment is missing @HothaifahHijazi 

[HothaifahHijazi]

sorry and here the attachment 

[Filsdegandalf]

Ok so it should look like this : 

Filter(ExcelFileDataSource, And(drpDay.Selected.Value = Day, drpRoomNo.Selected.Value = RoomNo, drpTiming.Selected.Value = Timing)

Regards,

[HothaifahHijazi]

Dear Fildegandalf,

Do I need to run this formula in Datasource or in item ?

thanks,

Hothaifah 

[Filsdegandalf]

Hi,

You have to put this formula as the data source of ur gallery

Regards,

[HothaifahHijazi]

appreciated your responses

kindly, see the attachments :

the formula i used :

Filter(Table1,And(WeekDay = Dropdown1.Selected.Result,RoomNo=Dropdown2.Selected.Result,Timing=Dropdown3.Selected.Result)

no value available after " Selected"

and it display nothing