cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LinnZawWin
Level: Powered On

Using the ClearCollect() Function in PowerApps does not Pull any Lookup Columns from Common Data Service (CDS) Data Source

When I Collect from CDS Data Source into Collection in canvas app designer, the lookup fields are not being populated even though I can see the lookup values when I bind the data source to the data table.
This is the sample formula that I used

ClearCollect(ContactCollection, ShowColumns(Contacts, "fullname", "createdby"))

And this is the output collection without any data in the lookup column.

Empty%2BCollection

Sometimes, the lookup columns show up and most of the times, they do not.

Is that a bug? And is there any fix/workaround solution for it?

3 REPLIES 3
Dual Super User
Dual Super User

Re: Using the ClearCollect() Function in PowerApps does not Pull any Lookup Columns from Common Data Service (CDS) Data Source

@LinnZawWin 

 

Yes this definitely is a bug

I have observed the same thing as well

 

Most of the times I need to connect to the Lookup entity as well and then query to fetch the associated data

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

v-siky-msft
Level 10

Re: Using the ClearCollect() Function in PowerApps does not Pull any Lookup Columns from Common Data Service (CDS) Data Source

Hi @LinnZawWin

 

Yes, I also face the same issue.

Sometimes the table logo is displayed, sometimes it is empty, sometimes it can be invoked, sometimes it cannot reference the value.

It is really werid.

I ready to post this issue to Microsoft product team. If this issue is solved, I would reply here.

 

Best regards,

Sik

LinnZawWin
Level: Powered On

Re: Using the ClearCollect() Function in PowerApps does not Pull any Lookup Columns from Common Data Service (CDS) Data Source

Thank you @v-siky-msft 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 341 members 6,488 guests
Please welcome our newest community members: