cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
HansHeintz
Level 8

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
HansHeintz
Level 8

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

3 REPLIES 3
TopShelf-MSFT
Level 10

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

Bumping for visibility 

 

@TopShelf-MSFT 

HansHeintz
Level 8

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

TopShelf-MSFT
Level 10

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

Thanks for the follow up @HansHeintz!

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,165)