Collect data into a single collection from two entities in CDS

(0) Share

Report

Posted on by P_SA

220

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

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
P_SA 220 on at

Like
a
(0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
P_SA 220 on at

Like
a
(0)

Report
Copy link

Link copied!

getting this error

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

The 'worker' inside the brackets has to have the first letter capitalised ( this is in entity right ? 'Worker')

Was this reply helpful? Yes No
P_SA 220 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes Worker is there in both entities... I changed it capitalized... still i face the same error.

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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]

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@P_SA,

Please try this:

AddColumns('Worker fixed compensation ',"FullName",Worker.'Full Name')

The database relationship call of CDS is very convenient, just use <LookUp field>.<RelatedEntityField> to call any fields in related entity.
Sik

Was this reply helpful? Yes No