Skip to main content
Community site session details

Community site session details

Session Id : m/PdMln767gD0LS3K6ozHM
Power Apps - Microsoft Dataverse
Answered

How to collect data (field values) from a CDS lookup Field

Like (0) ShareShare
ReportReport
Posted on 1 Nov 2019 05:42:14 by

Hi Everyone,

I thought this would be simple, but apparently not. Here is scaled down version of the CDS entity structure:

saletyp.JPG

I was just looking to collect the table data into a collection:

Clearcollect(SalesDetailCollect, 'Sales Detail')

However the resulting collection has no data for 'Sales Category"

Any ideas of what I am doing wrong?

 

Thanks in advance.

  • Community Power Platform Member Profile Picture
    on 02 Nov 2019 at 16:29:02
    Re: How to collect data (field values) from a CDS lookup Field

    Thank You,

    That works.

     

    JasonF

  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on 01 Nov 2019 at 22:46:51
    Re: How to collect data (field values) from a CDS lookup Field

    Hi @Anonymous 

    You can add the data in the lookup field by using the AddColumns() function.  

     

    ClearCollect(SalesDetailCollect, AddColumns('Sales Detail',"SalesCategory",Lookup('Sales Types',SalesCategory=SalesType))

     

     The reference for table shaping functions is https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-shaping 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete