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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,062)