Hello, I have a gallery named gal_x and data source is tbl_x also I have another gallery gal_SUBx and data source is tbl_SUBx. These two are connected with SQL key as XId. In gal_SUBx I am creating some locations for tbl_x. In gal_X I have a text label named Label142 and its Text properties with Concenate
Concatenate(
If(ThisItem.YYY, "YYY, ", ""),
If(ThisItem.AAA, "AAA, ", ""),
If(ThisItem.ZZZ, "ZZZ, ", ""),..
Then, I have a problem when I am trying to filter gal_x. I added a dropdown drp_7 and added YYY,AAA,ZZZ as items. drp_7 OnChange properties is: Set(XXXSelected, drp_7.selected.value).
Finally, when a added filter option to gal_x's Item properties like that:
Filter(
tbl_IATF,
(drp7.Selected.Value = "All" && XXXSelected = "All") || (drp7.Selected.Value <> "All" && XXXSelected in Label142.Text) )
There is an error:
This rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value.
Thank you!

Report
All responses (
Answers (