Answered

I need to list the values of an attribute in a dropdown menu. I've tried making a query between tree tables and also just like consulting these values. None of them work.

(0) Share

Report

Posted on by BirdieG

I have these three tables in Dataverse: Participants, Medicaments and CMAIs. The tables are connected like this: Participant has a Primary Name Column named participant_code which identifies each participant. Medicaments has a lookup column named participant that references the participant table. And what I'm trying to do is getting the different (distinct) values of the participant attribute in the table Medicaments.

I'm creating a new form for CMAIs and I want to values to be listed in a dropdown menu.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @BirdieG

Try this:
Distinct(Medicaments, participant)
This code would give you the different values of the participant attribute in the table Medicaments.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
BirdieG 15 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't know why it doesn't work. I've trying the whole day.
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

The error message “Expected a different collection record structure” typically occurs when Power Apps expects a certain structure of data, but the actual data provided doesn’t match that structure.

In this case you will need to define the schema of the input property appropriately in the component.

Steps you can follow:
1) Keep a note of all the keys that you want to pass in the component.
2) Add proper schema in the input property inside the component.

Note: You can use ShowColumns/DropColumns functions to get only required columns. Remove attachments columns before passing the values.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Error-Expected-a-different-collection-record-structure-While/td-p/1003079