web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery to display dis...

Power Apps

Answered

Gallery to display distinct results with Textbox

(0) Share

Report

Report

Posted on by adrianlochan

53

Hello,
I am trying to display distinct results in a gallery via textbox input.

The text box allows for either the SIN or Last Name to be used to search the MFDANotes table. My table is sitting in dataverse.

This is what I have so far in the Gallery Items
Filter(MFDANotess, StartsWith(SIN, FilterBox.Text) || StartsWith(Last_Name, FilterBox.Text))

I've tried:

Distinct(Filter(MFDANotess, StartsWith(SIN, FilterBox.Text) || StartsWith(Last_Name, FilterBox.Text)), SIN)

with no result.

Thanks

Adrian

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 154,951 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @adrianlochan ,

This will get you unique records on the combination of Last_Name and SIN with all the other fields in the Group in the Data Table field.

GroupBy( Filter( MFDANotess, StartsWith( SIN, FilterBox.Text ) || StartsWith( Last_Name, FilterBox.Text ), "Last_Name", "SIN", "Data" ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@adrianlochan ,

I took a different approach and put this formula in the OnChange property of the Textinputbox. I put a magnifying glass icon next to the box to prompt the user to leave the textinput box.

ClearCollect( rslt, Distinct( Filter( MFDANotess, StartsWith( SIN, FilterBox.Text ) ), SIN ) ); Collect( rslt, Distinct( Filter( MFDANotess, StartsWith( Last_Name, FilterBox.Text ) ), Last_Name ) )

The Items property of the Gallery was simply rslt and a single label control with Text property Result.

Was this reply helpful? Yes No

Join the conversation