Unanswered

Linking Parent and child galleries through clicks in canvas app

(0) Share

Report

Posted on by Giver

I have a scenario where I want to look at the child records of an parent tables record. I.e. I have table called Timesheets and a child table called Timesheet Items

The Primary Key and Look up are both called Timesheet Item. For the life of me I can't get the following formula to work so that when I click through from gallery 1 (Timesheets) to Galley 2 (Timesheet Line Items) it filters only the Timesheet Line Items where the PK/LK is the same as the selected Timesheet. I am using the following formula:

Filter('Timesheet Line Items',AsType('Timesheet Item',[@Timesheets]).'Timesheet Item' = Gallery.Selected.'Timesheet Item')

Now I now that the concept behind this formula works as I tested it on an App with Accounts and Contacts using the following formula:

Filter(Contacts,AsType('Company Name',[@Accounts]).'Account Name' = BrowseGallery1.Selected.'Account Name')

Can anyone help me understand what I am doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Giver

SharePoint or Dataverse?

Was this reply helpful? Yes No
Giver 8 on at

Like (0)

Report
Copy link

Link copied!

Dataverse

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Giver

If you have established the relationships you can make the Items property of your child gallery

Gallery1.Selected.Timesheet

Was this reply helpful? Yes No
Sunil-Narnaware 681 on at

Like (0)

Report
Copy link

Link copied!

@Giver The 'AsType' is not required in your case because 'Timesheet' lookup that you created on Timesheet Items is not a polymorphic one.. Polymorphic means it can hold different types of records in one single lookup.. for example.. your second formula which you referred
Filter(Contacts,AsType('Company Name',[@Accounts]).'Account Name' = BrowseGallery1.Selected.'Account Name')
Needs to use AsType as Company Name can be Account as well as Contact.

In your case, what @Drrickryp has suggested, is the most simple way to filter your second gallery based on first gallery instead of using Filter Condition.
else you can use Filter like below

Filter('Timesheet Items', Timesheet.Name = Gallery1.Selected.Name) //Gallery1 points to Timesheet Table.. Right?

Replace with appropriate field names.. Please make sure the field names are appropriate.. I am little doubtful if your primary key name & lookup name are same.. so double check this..

Regards,
Sunil

Was this reply helpful? Yes No
Giver 8 on at

Like (0)

Report
Copy link

Link copied!

Hi Sunil,

Thank you for that explanantion. I have followed the suggested method but am still coming up with errors.

PK on Timesheet is: 'Timesheet Item' :
The lookup value to parent timesheet on timesheet line item is: 'Timesheet Item'

Her is the error:

Was this reply helpful? Yes No
Sunil-Narnaware 681 on at

Like (0)

Report
Copy link

Link copied!

@Giver What is the error you are seeing when you hover over = (underlined with red color) ? Can you please share that?

Was this reply helpful? Yes No
Giver 8 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Sunil-Narnaware 681 on at

Like (0)

Report
Copy link

Link copied!

Can you try this ? In Gallery galTimesheetItems' items property.. write 'galTimesheets.Selected.'Timesheet Line Items' and see if you can only see selected timesheet' timesheet line items in second gallery..

Was this reply helpful? Yes No
Sunil-Narnaware 681 on at

Like (0)

Report
Copy link

Link copied!

@Giver Can you try this ? In Gallery galTimesheetItems' items property.. write 'galTimesheets.Selected.'Timesheet Line Items' and see if you can only see selected timesheet' timesheet line items in second gallery..

Was this reply helpful? Yes No
Giver 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sunil , No luck although the formula is error free:

Was this reply helpful? Yes No