cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HothaifahHijazi
Regular Visitor

several conditions in filtering

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 

8 REPLIES 8
Filsdegandalf
Helper I
Helper I

Hello @HothaifahHijazi ,

 

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

 

What's the datasource?

 

Regards

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)

Regards,

Dear Fildegandalf,

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

thanks,

Hothaifah 

Hi,

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

Regards,

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 

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (2,934)