News and Announcements icon

Power Platform CommunityForums Power Apps - Microsoft Dataverse How to collect data (f...

Power Apps - Microsoft Dataverse

Answered

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

(0) Share

Report

Report

Posted on by Community Power Pla...

Hi Everyone,

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

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.

All responses Img

All responses (2)

Answers Img

Answers (1)

Community Power Pla... on at

Like (0)

Report

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

Thank You,
That works.

JasonF
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
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

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Apps - Microsoft Dataverse

#1

mmbr1606 22 Super User 2025 Season 1

#2

stampcoin 19

#3

Michael E. Gernaey 15 Super User 2025 Season 1

Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans