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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (1,895)