cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver II
Resolver II

working with entity relation field names, do not get it

I have an entity DierlijstItems (plural, single=DierLijstItem) with a many to one relation to entity Dierlijsten (plural, single=DierLijst).

In a gallery displaying Dierlijsten I want to check for each items if it appears in DierLijstItems.

 

IsBlank(LookUp(DierLijstItems;DierLijst=ThisItem.DierLijst)

I get an error on the "=" like I am comparing different variable types.

To be clear: DierLijst is not a column of DierLijsten I defined, but it does exist: If I put a lable on the item ThisItem.DierLijst I get a Guid

Since I made a relation between to two tables DierLijst is also a valid identifier in DierLijstItems. If I make a gallery of DierLijstItems I can use ThisItem.DierLijst.SomeFieldOfDierLijst.


Putting it on another way

Table Children (there is no explicit relation column, the relation has just been defined with the entity,parent does yield a guid on thisitem.parent in a gallery)
Table Parent

Relation many to one

How many children does a parent have? the parent is an item in a gallery

CountRows(Filter(Children;Parent=ThisItem.Parent))
or

CountRows(Filter(Children;Parent=ThisItem))

 

This does not work, PA says I am comparing different data types.

What syntax to use please??
I used to work with integer id field in delphi with no problem.

The fact that I only need to state a relation suggest that powerapps solve the rest for me. But how?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver II
Resolver II

Re: working with entity relation field names, do not get it

3 REPLIES 3
Highlighted
Community Champion
Community Champion

Re: working with entity relation field names, do not get it

Bumping for visibility 

 

@TopShelf-MSFT 

Highlighted
Resolver II
Resolver II

Re: working with entity relation field names, do not get it

Highlighted
Community Champion
Community Champion

Re: working with entity relation field names, do not get it

Thanks for the follow up @HansHeintz!

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,423)