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.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!