cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Two filters for a control for 2 different SharePoint lists

Hi , I have an 'desk booking app' developed where , 'the desks which are already booked for a particular day shouldn't be displayed in the search box , as here we used 'combo box' control as a search box function'. Also as we have used a particular 'filter function' for a SharePoint list for other function , to display the 'desks' based on roles(manager or employee), in 'items' property of 'combo box' control.

 

so here , I tried using another filter function , using different  SharePoint list , but that is giving me an error , may be the syntax error or not really sure . so , will you please help with syntax using '2 filter functions with 2 different SharePoint lists' or how can this be achieved 'the desks which are already booked for a particular day shouldn't be displayed in the search box , as here we used 'combo box' control as a search box function'. please find the screenshot for the reference, the control is ' desk name' in screen shot .

 

Kindly help me here, as I have tried in many ways of getting it done , but couldn't achieve it .

3 REPLIES 3
Helper I
Helper I

Could anyone provide solution for this particular requirement or say any alternative process for this?? as I was struck while using ' 2 different filter options for 2 different lists' or how this can be achieved . Kindly do mention what can be done here. For 'the desks which are already booked for a particular day shouldn't be displayed in the search box , as here we used 'combo box' control as a search box function'. As this is for office use , to book desks.

Please find the attachment of the formulas which I have tried & didn't get proper response & facing errors. Awaiting for the response .

Microsoft
Microsoft

sowmya_pv,

 

There's a bit to unpack here but it reads to me like you need to interact with the Visible property:

https://www.spguides.com/show-hide-fields-based-on-dropdown-selection-powerapps/

 

I hope this helps!

 

Patrick

Hi,

Thank you for the reply .  Have gone through the link , yes 'visible' property in the case of showing/hiding fields , conditional hiding.

 

But expecting for' filtering the control based on items/ desks which are already booked'. Like the value(desk) which are entered in the SharePoint list , shouldn't appear/ display for others to choose that option. As I have got a clue regarding 'filter' function but that's already has been used for a different SharePoint list , the booked data of desks in another list , so how that can be achieved here.

 

Kindly suggest any idea regarding that.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (34,278)