web

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

News and Announcements icon

Power Platform CommunityForums Power Apps distinct filter is not...

Power Apps

Unanswered

distinct filter is not showing my option when I edit in the form

(0) Share

Report

Report

Posted on by Gorilla_8

I have a gallery that pulls the data and saves it correctly in the database, but when pulling the edit form it is not displayed correctly

Here is my code:

My database is SharePoint and the column is a single line text

Items property:

Distinct(Filter(MycollectionNameHere; AREA<> Blank() /*"NULL"*/);AREA).Result

DefaultSelectedItems:

{Value:LookUp(MycollectionNameHere;NOME=ComboBox1_38.Selected.Result).AREA}

Why is this happening?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Gorilla_8 ,

I think you need

{ Result: LookUp( MycollectionNameHere; NOME=ComboBox1_38.Selected.Result ).AREA }

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
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

The result is only blank

Was this reply helpful? Yes No
WarrenBelz 156,458 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Gorilla_8 ,

That is the correct code according to what you posted. I suspect your Lookup is not valid. Please do some trouble shooting on this basis.

Was this reply helpful? Yes No

Join the conversation