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 .
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 .
There's a bit to unpack here but it reads to me like you need to interact with the Visible property:
I hope this helps!
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.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!