Using column of one table in another table

(0) Share

Report

Posted on by Muhammad Anas Naeemi

390

Hey community,

I want to ask that I can I use column of one table into another table in power portals. In my case, I want to use "Full Name" column of "Contact (out of the box)" table into one of my custom table. I have tried creating a lookup field but its giving me relation with the table and not with the column itself. Kindly help.

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Pradeep Rai 5,489 Moderator on at

Like (1)

Report

RE: Using column of one table in another table

Hi,

Do you want set the value of FullName field to your custom entity field?

If yes and user is a logged in user then you can use the liquid syntax to get values as described in below link:

Was this reply helpful? Yes No
Suggested answer

Naveen Ganeshe 3,397 User Group Leader on at

Like (1)

Report

RE: Using column of one table in another table

Hello,

You can create a custom field for fullname and copy over the fullname from contact using process, flow or plugin.

Was this reply helpful? Yes No
Muhammad Anas Naeemi 390 on at

Like (0)

Report

RE: Using column of one table in another table

Hey Naveen how can I do that? Can you please explain me in detail

Was this reply helpful? Yes No
Suggested answer

Naveen Ganeshe 3,397 User Group Leader on at

Like (1)

Report

RE: Using column of one table in another table

Hi Anas,

You can write a system workflow on the change of the lookup field of contact from the custom entity and fill the custom fields of full name.

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

RE: Using column of one table in another table

Hi Muhammad,

Yes, the lookup field is based on the relationship between two tables, and it can show primary column of the related table on the column.

The lookup can show full name of the contact on another table:

If you insist on getting "Full Name" column of "Contact, you can create one custom calculated field to get full name based on the relationship you just created.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/define-calculated-fields

Was this reply helpful? Yes No
Verified answer

Muhammad Anas Naeemi 390 on at

Like (1)

Report

RE: Using column of one table in another table

Hey everyone, thank you everyone for the response. I have achieved my desired functionality. I created a Meta Data for the field and auto-populated it.

Was this reply helpful? Yes No
Naveen Ganeshe 3,397 User Group Leader on at

Like (0)

Report

RE: Using column of one table in another table

Good to hear that.

Was this reply helpful? Yes No