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
Hello @HothaifahHijazi ,
Do you have the filter criterias linked to your Dr Name in your database?
What's the datasource?
Datasource is a table for the weekly distribution of clinics in the hospital
as in the attachment :
it seems that your attachment is missing @HothaifahHijazi
sorry and here the attachment
Ok so it should look like this :
Filter(ExcelFileDataSource, And(drpDay.Selected.Value = Day, drpRoomNo.Selected.Value = RoomNo, drpTiming.Selected.Value = Timing)
Do I need to run this formula in Datasource or in item ?
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
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Check out the new Power Platform Community Connections gallery!