Dropdown Box in Gallery showing the right number of items but blank lines

(0) Share

Report

Posted on by SLMR

518 Moderator

I have a dropdown box with a little bit more complicated filter, which works fine on App page.

I create exactly the same dropdown in a gallery and it shows the the right amount of items but the lines are blank.

I checked if it displays the right items, by changing the dropdown, as i know what values there should be and save the records. This all works fine. But i do not understand, wyhy i can not see anything in the dropdown in the gallery.

It was able to see all the values when the filter was not that complex. But i need this filter and the dropdown with the same filter outside the gallery does what it should.

Any idea where problem could be.

The Filter now looks like:

Filter(LookUp(Benutzers,Fullname=User().FullName).'Cases (cr8ec_Projekt_Zugehoering_ref)', Projekt.'Projekt (cr8ec_projektid)' in Filter(Projekts, Kunde.Kundennummer = SelectProjekt_kosten.Selected.Kundennummer).'Projekt (cr8ec_projektid)')

This part LookUp(Benutzers,Fullname=User().FullName).'Cases (cr8ec_Projekt_Zugehoering_ref) gives me all "Cases" a user is working for.

If i change the filter to:

Filter(Cases, Projekt.'Projekt (cr8ec_projektid)' in Filter(Projekts, Kunde.Kundennummer = SelectProjekt_kosten.Selected.Kundennummer).'Projekt (cr8ec_projektid)')

All items are visible.

As the complex filter generally works, but i just can not read the items, i do not understand what the problem is?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Pstork1 69,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

When you add a set of records to a dropdown it selects the first column it sees as the value to display. This can often lead to blank values being displayed. You can specify which field it uses as the value in the right side panel. the key is that you have to do it before you change the data set to a formula. So do the dropdown unfiltered first, set the value field in the dropdown in the panel and then paste you filter in. Once the Value field is set it won't change if the data source being filtered doesn't change.

Was this reply helpful? Yes No
SLMR 518 Moderator on at

Like (0)

Report
Copy link

Link copied!

Thanks for the quick answer
I set the value to the right value to display.
The setting of the dropdown in teh gallery is excatly the same as for the dropdown on the page outside a gallery. What drives me mad is that it works fine on the page but not on the gallery.
The problem is that not all values of the entity case should show up in combobox only values filtered on different criteria.
What i do not understand ist that with my first filter expression it works and if i expand it i show this behaviour.

But maybe this is a problem how i adress this work. I come from database with access or VB/C# .net as frontend and there it is very easy to use queries direclty on the db or within the code.

I think i will go the way to store same filtered information in collections so to amke further filtering not that complex.

There are some other things that i do not understand:
An item selection on another gallery that worked yesterday, does today no longer show values, although i did not change anything.
For these items i used:
ForAll( Distinct(AddColumns(LookUp(Benutzers,Fullname=User().FullName).'Cases (cr8ec_Projekt_Zugehoering_ref)',"Kunde",ThisRecord.Projekt.Kunde.Kundennummer),Kunde) As CC, LookUp(Kunde, Kundennummer = CC.Value) )

Is it intended to use collections for this kind of purpose?
I would think using collections is only a worke around if can not use Filtering in the right way.
Or is complex filtering over multiple tables not the best way?

Was this reply helpful? Yes No
Verified answer

SLMR 518 Moderator on at

Like (0)

Report
Copy link

Link copied!

For all that may experince the same problems.
I now filled collections using "prefilters" to make the next level filtering not that complex.
Now it is possible to filter the collection against another gallery and the dropdown in the other gallery behaves as it should.

But i completly not understand why it did not the worked the way i choose before.

Was this reply helpful? Yes No