Answered

Dataverse for Teams table relationships and Power Apps Collections not working

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey everyone,

I am having trouble using Power Apps Collections to extract data from Dataverse for Teams. More precisely, I have a table Demandes (parent) that is related to a table Article (child). When I try to collect the Articles of a specific Demande (say, the first row), I have the following:

ClearCollect(Test; First(Demandes).Articles)

However, if I use the ShowColumns function (as a workaround), it seems to work much better:

ClearCollect(Test; ShowColumns(First(Demandes).Articles;"cr9a3_codefranchise";"cr9a3_numeroteinte"))

Am I doing something wrong? Or is this normal?

Thank you for helping me out. Have a nice day!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

This is normal behaviour and I understand why this can be confusing. Calling ShowColumns is the correct approach to this issue.

Power Apps applies 'explicit column selection' to retrieve only the columns that are necessary. This is a performance optimisation. At the time when you call ClearCollect, Power Apps doesn't know whether you need cr9a3_codefranchise, so it doesn't retrieve data for that column. Explicitly specifying cr9a3_codefranchise through ShowColumns indicates that you require that column, which explains the behaviour that you see.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @timl for your answer! I understand your point but, in that case, how can we manage to correctly extract data from a Lookup column (say, the "Created By" column)? Because ShowColumns does not seem to work for this case. Could you guide me in dealing with this correctly?
Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous

Unfortunately, I'm not sure if it's possible to include 'field' columns in a call to ClearCollect. The only thing I can suggest is to call AddColumns and to include the specific fields that you extract from the 'Created By' column. For example:

ClearCollect(Test; ShowColumns(AddColumns(First(Demandes).Articles; "PrimaryEmail"; 'Created By'.'Primary Email' ); "cr9a3_codefranchise"; "cr9a3_numeroteinte"; "PrimaryEmail" ) )