web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to collect data (f...

Power Apps

Answered

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

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank You,
That works.

JasonF

Was this reply helpful? Yes No

Join the conversation