Answered

Need to display "Distinct" values in a drop box but still access other fields in the selected row.

(0) Share

Report

Posted on by nhale

Is there no way to select a distinct row as opposed to a single column table when using the Distinct function? I must be missing something.

I have a dropdown box that needs to populate with all patients last names on a schedule for a given day. They have multiple appointments on a given day so the dropdown box populated by this code:

SortByColumns(Filter('[dbo].[vAppointments]', FLDDATEINT = Value(Text(_dateSelected,"[$-en-US]yyyymmdd"))),"FLDLNAME",Ascending)

...lists the patients last name multiple times but once selected allows me access the fields of the selected record from other controls via dropdown_lastname.selected.SomeOtherField.

If I change the above code using the Distinct statement it populates the dropdown box correctly but creates a one column table "result" that does not allow me to use as a pointer to the other fields on the selected row. Please help. Thanks.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @nhale ,
The following (you will need to put in your Distinct field name) will put all the other fields in a table called Fields, so for instance if you wanted the Patient field, the reference would be Fields.Patient.
SortByColumns( AddColumns( Distinct( Filter( '[dbo].[vAppointments]', FLDDATEINT = Value( Text( _dateSelected, "[$-en-US]yyyymmdd" ) ), YourDistinctFieldName ), "Fields", LookUp( '[dbo].[vAppointments]', Result = YourDistinctFieldName ) ), "Result", Ascending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
WarrenBelz 156,754 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @nhale ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
nhale 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks this works. It's a little slow loading so I may to refine further but appreciate the help.