cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HothaifahHijazi
Level: Powered On

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
Level: Powered On

Re: several conditions in filtering

Hello @HothaifahHijazi ,

 

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

 

What's the datasource?

 

Regards

HothaifahHijazi
Level: Powered On

Re: several conditions in filtering

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

as in the attachment :

 

 

Filsdegandalf
Level: Powered On

Re: several conditions in filtering

it seems that your attachment is missing @HothaifahHijazi 

HothaifahHijazi
Level: Powered On

Re: several conditions in filtering

sorry and here the attachment 

Filsdegandalf
Level: Powered On

Re: several conditions in filtering

Ok so it should look like this : 

 

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

Regards,

HothaifahHijazi
Level: Powered On

Re: several conditions in filtering

Dear Fildegandalf,

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

thanks,

Hothaifah 

Highlighted
Filsdegandalf
Level: Powered On

Re: several conditions in filtering

Hi,

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

Regards,
HothaifahHijazi
Level: Powered On

Re: several conditions in filtering

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 296 members 6,424 guests
Please welcome our newest community members: