Unanswered

Filtering Gallery

(0) Share

Report

Posted on by DanBalach

I am building a canvas app to these details:

1) A booking summary form that creates an AutoNumber (BookingID) column that serves as an identifier for a travel booking.

2) I then have a booking detail form with a lookup field to the booking summary with the underlying table related to the summary table on the BookingID. This has a combo box to select the aforesaid BookingID and adds several records representing travel segments for the booking.

3) Below that, I have a gallery pointing to the datasource of the booking detail.

My need is for this gallery to filter records based on the BookingID selected in 2) above. I have tried several approaches without success in the filtering. Please suggest a method. Have attached an image showing the screen.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @DanBalach

For the Items property of our Gallery in #3, you can do something like:

Filter(datasourceName,'Booking ID' = dropDownBooking.Selected.Id)

Code is given on the presumption that the BookingID dropdown is named dropDownBooking

It would be helpful to let me know what type of column does the BookingID here in this gallery is so we can refine the code.

Was this reply helpful? Yes No
DanBalach 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your response. That field in gallery is:
ThisItem.BookingID.BookingNbr.
Bookingid is the field in BookingDetails and this is looking up to BookingNbr in the summary table. Field snapshot attached.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

Since you are using Dataverse and LookUp/relation is set, you can have your code like this

comboBox.Selected.nameOfTableYouWantToFilter

The comboBox to the control name of your BookingID drop down while nameOfTableYouWantToFilter is the name of the Table you want to filter. Can you please try it show me what happens?

Was this reply helpful? Yes No
DanBalach 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Cha_cha

I get an error on that formula.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Can you please show the error?

Also when you type just after "comboBox.Selected.", is it suggesting any column names?

can you send screenshot so I can provide further suggestions?

Was this reply helpful? Yes No
DanBalach 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Cha Cha

Thanks. Just trying a different approach on the lines you suggested in earlier post.

Was this reply helpful? Yes No