Two filters for a control for 2 different SharePoint lists

[sowmya_pv]

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 .

[sowmya_pv]

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 .

[PatrickMSFT]

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

[sowmya_pv]

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.