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 Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps 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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (6,211)