Unanswered

Fetch Unique Values from a Lookup column

(0) Share

Report

Posted on by paul_george

I have a requirement to fetch unique column values from a lookup column from a Dataverse table in a PCF component. The table will have huge amount of records(can go more than million)

for eg. Please find the sample Table

Column A	Column B (Lookup)	Column C (Lookup)
Column A Value A	Column B Value A	Column C Value A
Column A Value B	Column B Value A	Column C Value A
Column A Value C	Column B Value A	Column C Value B
Column A Value D	Column B Value B	Column C Value C
Column A Value E	Column B Value A	Column C Value D

I am filtering the table based on Column B and need to fetch the distinct values from Column C

For eg. If I filter Column B = 'Column B Value A'

Expected Result should be

Column A	Column B (Lookup)	Column C (Lookup)
Column A Value A	Column B Value A	Column C Value A
Column A Value C	Column B Value A	Column C Value B
Column A Value E	Column B Value A	Column C Value D

I need to implement it using either WebAPI or FetchXml

For eg. If I filter Column B = 'Column B Value A'

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Shashank Bhide 942 Moderator on at

Like (0)

Report

difficult for me to understand the table structure, because according to your logic there should be 4 out rows not 3
having said that, if the data volume is going to be large, then you've to be very careful and show the data in pages, because one Dataverse query can return max 5K records, so you've to include paging in your PCF control, also if you loop through the pages and collect the record in PCF, that may crash the browser if the data is really huge besides taking a long time.

Was this reply helpful? Yes No
paul_george 2 on at

Like (0)

Report

I need distinct values of colum c. If you look at the table, value of column c of first and second row are same. Hence only first row is considered.

Was this reply helpful? Yes No