I have asked sort of the same question earlier but a bit too complicated I am afraid.
So I try to make is as simple as possible.
In table Children a relation is defined many to one to table Parents.
Table Childrens now says there is a relation many to one, there is a lookup field Parent
Table Parents now says there is a relation one to many, relation is called Parent
In a gallery of parents I want to show the number of children a parent has
Whatever I do it will not work. ThisItem.Parent is valid (shows as GUID in a label). In another gallery showing Children I have one Child with a valid Parent. ThisItem.Parent.Parent shows the right GUID
The identifiers are correct / not red underlined but there is a red line under "=" (invalid argument type)
In my case the names ot tables and fields are different but I wanted to make this as simple as possible.
Should this code work?
If so then some disambiguation is probably in order and I would like to know how I can disambiguate this statement as much as possible.
I also find that the code
insode will not work
But outside the gallery
The cra27_ bit is added by PA. My code was Parent.Parent (relation name.field name) Autodisambiguation?
Solved! Go to Solution.
If I understand your query correctly, you want to show the count of child records in the parent.
Gallery2 is Parent gallery
Gallery4 is Child gallery
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.