Answered

Combine 2 Dataverse Tables using a collection

(0) Share

Report

Posted on by GabiBragaglia

Hello,

I want to combine two Dataverse tables in Microsoft Power Canvas Apps using a collection. I have these two tables:

I want to show the 'Name' column from the table 'Organisational Units' in the table 'Organisational Positions' and name these column 'Staff'. However, my formula is not working:
ClearCollect(
Collection;
AddColumns(
'Organisational Positions';
"Staff";
LookUp(
'Organisational Units';
'Organisational Unit' = 'Organisational Positions'[@'Organisational Unit']; Name
)
)
)

The "=" Symbol is underlined in red. Can someone help?
Thanks a lot in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @GabiBragaglia,

In case you are using a LookUp the DataTable control will display the unique id by default. However, you can actually change which column is displayed.

(1) Select that particular column in the DataTable

(2) Select the Text property (which will most likely be ThisItem.'Organisational Unit'.'Organisational Unit' )

(3) Change this to the correct column ThisItem.'Organisational Unit'.Name

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
GabiBragaglia 6 on at

Like (0)

Report
Copy link

Link copied!

Hi @LaurensM,

it worked perfectly! Thank you so much 🙂

Was this reply helpful? Yes No