Answered

Distinct Filter of Gallery

(0) Share

Report

Posted on by Phineas

5,331 Moderator

How do I get this Distinct filter to work?

If(IsBlank(Event_Registration_Attendee_Name_Input_Fld.Text),Filter(Distinct(Event_Registration_Collection,Client_FullName,SortOrder.Descending,Filter(Distinct(Event_Registration_Collection,StartsWith(Last_Name, Event_Registration_Attendee_Name_Input_Fld.Text)))

Categories:

Building Power Apps

I have the same question (0)

All responses (16)

Answers (1)

Sort by

Pstork1 69,385 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I don't think there is a way to fix this. The problem is that Distinct() will return a one column table based on the column you are asking to be Distinct. So the column you want to filter on won't be in the results to be used for filtering.

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

But I can run a distinct filter in the gallery, yes.

I have an SPList. On that list the individuals name may appear more than once. I only need the individual to appear once in the Right gallery, once selected additional information from the same data source will appear in the Left gallery.

Was this reply helpful? Yes No
Pstork1 69,385 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

No you can't really use a distinct function in a gallery. Here's a quote from the docutmentation.

"The Distinct function evaluates a formula across each record of a table and returns a one-column table of the results with duplicate values removed. The name of the column is Value." Distinct function - Power Platform | Microsoft Learn

As I said the output of distinct is a one column table so the other columns aren't there in the results to be used as in the filter()

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,242 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Phineas ,

Firstly set the Default of Event_Registration_Attendee_Name_Input_Fld to "" (empty string) then the left gallery can be (I have only restored the columns I can see in your screenshot and assume you are using SharePoint)

AddColumns( GroupBy( Filter( Event_Registration_Collection, StartsWith( Last_Name, Event_Registration_Attendee_Name_Input_Fld.Text ) ), "Client_FullName", "Grouped" ), "TicketType", First(Grouped).'Ticket Type', "UniqueID", First(Grouped).'Unique ID", "_ID", First(Grouped).ID )

then the Item of the Form on the right

LookUp( Event_Registration_Collection, ID = Gallery1Name.Selected._ID )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Maaaan, you must have a BIG-O wizard hat!🤣

Thank you!

P.S. - Let me know if you find time and have an answer for my camera/attachment/folder sub-folder question.
My flow using just a local attachment file creates these two folder levels in the Library. This is also what I'd like the ability to do with the other flow. I tried to mimic the formula and merely change to the camera and attachment, that didn't work.

Thanks again!!!

Was this reply helpful? Yes No
WarrenBelz 155,242 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Phineas ,

I would need to see your other Flow - you need to use Create Folder in it to set up the required structure.

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Here it all is...

Below is attachment with file from laptop.

Attachment control has 'RegistrantFormImageCollection' in
the items.

Error - Trigger schema mismatch. The input body for trigger
'manual' of type 'Request' did not match its schema definition.
Invalid type. Expected string but got Null. '."}}

Below is attachment with image from Collection created
by camera control.

Camera OnSelect has -
Set( varName, GUID()
);
Collect(
RegistrantFormImageCollection,
{
DisplayName: varName & ".jpg",
Id: varName & ".jpg",
Value: NR_Camera_Control_2.Photo
}
);
Button code - UploadEventDocumentsFlow.Run(
Event_Registration_Document_Type_Dropdown.Selected.Value,TextInput3_31.Text
&" - "& Event_Registration_Photo_Gallery_Name_Fld.Text,
{ file: {
contentBytes: First(DataCardValue42_1.Attachments).Value,
name: Event_Registration_Document_Type_Dropdown.Selected.Value
&" - "& Event_Registration_Photo_Gallery_Name_Fld.Text
}
});

Power Apps V2 Flow -

Was this reply helpful? Yes No
WarrenBelz 155,242 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Phineas ,

Why are you using the attachment control at all here - you can just use the collection and if there is only one photo, you do not need the collection as I posted earlier. Also have you addressed the folder issue ?

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

I am using the attachment control because videos and posts use it.

What do I know.🤣

There is only one attachment at a time.

I thought about a gallery, but couldn't figure out how to change the name of the file for each photo taken, using the dropdown that named the photo. In my test all the images in the dropdown had the same 'name', which won't work.

I have not addressed the folder issue. How should I address the folder issue?

I thought it was working. The folder is being created. The file is being created. But I can't open the file once it is created.

Was this reply helpful? Yes No
WarrenBelz 155,242 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Phineas ,

I just ran this test Flow

And created a folder with the file successfully filed in it.

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No