Answered

Distinct in If formula for gallery

(0) Share

Report

Posted on by weebot

Hi,

I have a gallery with report records on it but currently it is show up as multiple records. How do I show only distinct records?

Below is my formula: It looks at the input search text box for any data, if no data, show everything
If(IsBlank(SearchBox.Text),

SortByColumns('app.database',"cdr_date",SortOrder.Descending),

SortByColumns(Search('app.database',SearchBox.Text,"crew","cdr_ref","service_order","location"),"cdr_date",SortOrder.Descending)).

Secondly, I have another gallery which pulls in the report LxWxD data. How can i filter that gallery so when I select the distinct report in the first one, it will show all the rows of LxWxD data (for example if it has three rows of record for that)

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

JayMagness 1,663 on at

Like (0)

Report
Copy link

Link copied!

Please do not forget to close this and give the solution.

Was this reply helpful? Yes No
JayMagness 1,663 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Yes there is the process I follow is to add lookups for the fields you want

Was this reply helpful? Yes No
weebot 21 on at

Like (0)

Report
Copy link

Link copied!

Thanks all! Now I realized the distinct only bring in the one value - for example cdr_ref. Is there a way to bring in more such as crew, cdr_ref, service_order, location?

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft on at

Like (1)

Report
Copy link

Link copied!
Hi @weebot ,

In fact, you do not need if and isBlank to judge the SearchBox, and the first gallery can also be sorted by your given criteria. You can make some adjustments to Search statement by setting Items in the first gallery:
Distinct(SortByColumns( Search( 'app.database', SearchBox.Text, "crew", "cdr_ref", "service_order", "location" ), "cdr_date", SortOrder.Descending ),LxWxD)

Then set the Items of the second gallery to:
Filter('app.database',LxWxD=Gallery3.Selected.Value)

Note: The name of our data source may be different, please use your data source name.

Best regards,
Rimmon Li

Was this reply helpful? Yes No
JayMagness 1,663 on at

Like (0)

Report
Copy link

Link copied!

HI,
If your formula above works to get the data, then you can do the following:

Distinct( "Your formula" ),"The field to list")

Distinct function in Power Apps - Power Platform | Microsoft Learn

Was this reply helpful? Yes No