Canvas Apps Nested Galleries When They are Master Detail (Circular Reference)

(0) Share

Report

Posted on by MattFreeman

I have a Gallery which is displaying Parent Table (Absences)

Inside for every row I created a detail Gallery which shows Record From a Child Table (Absense Approvals)

So far it looks easy, I use this formula in the child Gallery:

Filter('Absence Approvals', 'Absence Approvals (Views)'.'All Absence Approvals', Absence = Future_Vacations_Gallery.Selected)

But I get the error of "This formula creates a circular reference between properties.

I don't know, it looks like a bug, cause I am not referencing this Gallery I am referencing the parent one.

I even tried to store the value of the selected Item from parent gallery in a variable and try to lookup here, But I have no idea how to do that, since this is a LookUp column and I failed filtering it.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MattFreeman ,

Please post the formulas in text, so that we can easily modify on them.

Anyway, the formulas you need please try below:

Filter(Filter('Absence Approvals', 'Absence Approvals(Views)'.'All Absence Approvals'), Absence = ThisItem.Absence)

Best regards,

Was this reply helpful? Yes No
MattFreeman 11 on at

Like (0)

Report
Copy link

Link copied!

Thank you @v-jefferni

Sure, for future I will always write the code in text, (my bad)

But the solution you offered did not help in this matter.
You see the parent Gallery is already of type Absence, so I should use the "Selected" property.
Yet this also didn't help.

I rewrite the question in a better form for others as well.

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

Like (1)

Report
Copy link

Link copied!
Hi @MattFreeman ,

For the main Gallery, it includes Absences I presume a Text column. Then in this Gallery, you placed a sub-Gallery for each item, so the sub-Gallery filter should base upon a specific value as criteria. There shouldn't be and "selected" because each row of the main Gallery has a value of absence, no need to select. The ThisItem property means the row of main Gallery. So, ThisItem.Absence represents the Absence of current row of the main Gallery.

Maybe I write the formula as below would be more specific:

Filter(Filter('Absence Approvals', 'Absence Approvals(Views)'.'All Absence Approvals'), (Absence column name of 'Absence Approvals' table) = ThisItem.(Absence column name from Absence table))

Note that the two columns should be Text type with my assumption. If either of them is not, the formula will be different.

Best regards,

Was this reply helpful? Yes No
Verified answer

MattFreeman 11 on at

Like (0)

Report
Copy link

Link copied!
At the end, using Selected property on Parent did not work at all.
What actually worked, was to use a TextLabel in the grid, how?

This is the final formula for the detail gallery:
Filter('Absence Approvals', 'Absence Approvals (Views)'.'All Absence Approvals', Absence.Name = row_absencename.Text)
And row_absencename is a Label I put in the Master gallery and is simply bound to the absence name.
Funny enough this works and has a good performance,
Cause I noticed using a seperate variable for keeping SelectedItem had a hard performance impact cause all Detail grids were getting updated, but this way affects only the current record.

Thank you @v-jefferni , for your help,
See if you have something else to add to this and then I will close the topic.

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

Like (0)

Report
Copy link

Link copied!

Hi @MattFreeman ,

It seems the two columns are not with Text type, that makes sense.

Best regards,

Was this reply helpful? Yes No