Answered

Book a room with filter

(0) Share

Report

Posted on by Sanu

Hi all,

I'm new in Powerapps. I just created app with "Book a room" template. But, I need som help.
I would like to use this app only for booking a special room "Parkering". And don't want show other rooms available.

I have tried many different filters, but none of them work for me. Can someone give me a good guide.

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (1)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

On Visible property of RoomSelectScreen should be modified and look like this:

If(
!NoRoomsList,
ClearCollect(
AllRooms,
Filter(
Office365.GetRoomsInRoomList(RoomsListsGallery.Selected.Address).value,
Name = "Parking"
)
)
);

Was this reply helpful? Yes No
Sanu 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Gabibalaban,
Thank you for your quick respons. But, its not working for me.
I think some think issue in "RoomsListsGallery"???

And not showing any rooms
Any tips??????

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

There is another place we should modify the code (because you don't have room lists defined in your tenant):

So, go to OnStart property of the app and replace the code:
ClearCollect(AllRooms, Office365.GetRooms().value)
with
ClearCollect(AllRooms, Filter(Office365.GetRooms().value,Name="Parking"))

Please leave the previous modification unchanged, in case you'll define some room lists in your tenant.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sanu ,

Could you please share a bit more about your scenario?

Do you want to only display the "Parkering" room in your 'Book a Room' template app?

If you want to only display the "Parkering" room as available room in your 'Book a Room' template app, I think the Filter formula you specified is correct. Please modify the formula within the OnVisible property of the RoomSelectScreen as below:

Please note that, the OnVisible property of the screen would be fired only when you switch from another screen to current screen. So please consider save your canvas app, and then re-load your canvas app, then check if the issue is fixed.

Note: Please make sure you have fired the OnVisble property of the RoomSelectScreen in your canvas app properly.

Regards,

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xida-msft , @Sanu

I'm pretty sure that the solution proposed above will not meet your expectation.
Please be aware that you don't have defined room lists inside the tenant. To meet your goals the modification should be made also here:

Was this reply helpful? Yes No
Sanu 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello again,
I did exactly as you said, but no response. I get the list of all available rooms anyway.

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Please read my last post ... The problem is from OnStart property of the app.

Was this reply helpful? Yes No
Sanu 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Now I have modified both "OnStart" & "OnVisible", but no luck ☹️

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sanu ,

I agree with @gabibalaban 's thought almost. Also please consider modify the corresponding formula within the OnStart property of App. Then re-load your canvas app. Check if the issue still exists.

In addition, also please consider re-create a new canvas app in Tablet Layout based on your 'Book A Room' template, then check if the same issue still exists..

Regards,

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

You made the modification elsewhere.
Here we talked about AllRooms collection, not RoomLists collection.

Please see the attach !

Was this reply helpful? Yes No