distinct return a special value

(0) Share

Report

Posted on by MaximeGr

Hello

for a gallery i use

AddColumns(RenameColumns(Distinct(SortByColumns(Filter([@Gares];StartsWith(Title;TextSearchBox1.Text));"Title";If(SortDescending1;Descending;Ascending));Title);"Result";"Country"); "Photo"; SampleImage)

this from a sharepoint

i want to replace SampleImage by the data "Image"

and how take the first image when i have more than 1 same City ?

For example you see Cherbourg 3 times but only one picture

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@MaximeGr

For the Items property of the gallery:

SortByColumns( Filter( GroupBy( Gares, "Title", "DATA" ), IsBlank(TextSearchBox1.Text) || StartsWith(Title,TextSearchBox1.Text) ), "Title", Ascending )

In your Gallery place a Label with the Text property: ThisItem.Title and an image control with its Image property::

First(ThisItem.DATA).Picture

Was this reply helpful? Yes No
MaximeGr 27 on at

Like (0)

Report
Copy link

Link copied!
thanks
i replace , with ; because in our version we don't use ,

SortByColumns( Filter( GroupBy( Gares; "Title"; "DATA" ); IsBlank(TextSearchBox1.Text) || StartsWith( Title; TextSearchBox1.Text ) ); "Title"; Ascending )
and for the picture : First(ThisItem.DATA).Image

Thanks 🙂

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

Like (0)

Report
Copy link

Link copied!

Je t'en prie!

Was this reply helpful? Yes No
MaximeGr 27 on at

Like (0)

Report
Copy link

Link copied!

can i ask something else ?
in the second screen how to find the City selected result ? (example Cherbourg)

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

Like (0)

Report
Copy link

Link copied!

@MaximeGr

You can GroupBy(Gares, "Ville", "DATA")

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

Like (0)

Report
Copy link

Link copied!

@MaximeGr

You can GroupBy(Gares, "Ville", "DATA")

Was this reply helpful? Yes No