Hello Experts , Can someone help me to collect data from two Entities. I am struggling to write formula for that. ?
the entity names are worker and worker fixed compensation ... I am not sure what else information should i provide . please let me know if more information is required.. thanks
Can you be more specific ? Are you trying to gather all data from worker fixed compensation entity or only a specific number of columns ? The relationship between the entities is one to one ?
Try this one, to add only one column:
ClearCollect(Result, AddColumns(worker,"AddedColumnName",LookUp(worker fixed compensation, ID=worker fixed compensation[@ID]).ColumnToBeImported))
If your database is a large one, you'll have to wait a while. So I'll recomand to Filter the data from the two entities with the ones you are really interested in and after that to do this operation locally.
I have two entities.
Entity 1 : Worker
Entity 2 : Worker fixed compensation
In Entity 1 , there is a field named " Full Name " . I have a gallery connected to Entity 2 ..
there is a common field in both entities called " worker " . In entity 1 it is a unique identifier and in entity 2 it is a lookup value....
I want display the full name in the gallery by doing a lookup on the entities.. How do i solve this ?
Put in Items gallery property the following:
AddColumns(Entity 2,"Full Name",LookUp(Entity 1, worker=Entity 2[@worker]).Full Name)
and then inside gallery insert a label with the Text property ThisItem.Full Name
Last try from my side: 😊
1. You have too many closing brackets (it's one, not two at the end) .
2. Change inside the lookup:
'Worker Fixed Compensation'[@Worker] with Workers[@Worker]
Please try this:
AddColumns('Worker fixed compensation ',"FullName",Worker.'Full Name')
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020