Answered

How to display Gallery data only after selecting dropdown menu after exporting and importing solution ?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am currently having beginner level skills in development of Power apps solution, therefore looking for solution for the below issue in this community of experts.

I am creating a gallery in power apps along with a dropdown. The gallery should only display data when a field is selected from dropdown menu. Dropdown fields values also contain blank values, but the gallery should able to show the other fields related to the blank values. By default gallery data will show blank values or gallery should be invisible for the users if no values have been selected.

The properties of dropdown are set as :

Item : Employee

Value : employee_name

Default: Blank()

The properties of gallery are set as :

Items: Filter(Employee,

employee_name = Dropdown.Selected. employee_name)

Visible : If(

!IsBlank(Dropdown1.Selected.employee_id),

true,

false)

Default : Blank()

I can achieve the desired result in DEV environment but when I export the solution from DEV and IMPORT the solution to TEST environment, the gallery is showing the list of all employees by DEFAULT.

Can anybody help me to achieve the desired solution ?

Thank you in advance !

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

LucasAnjos on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ankibano ,

What if you try using an If statement in the items property of the gallery ? Just like you put in the visible property.

If( !IsBlank(Dropdown1.Selected.employee_id),
Filter(Employee, employee_name = Dropdown.Selected. employee_name),
false)
If this is not your problem, please let me know, I'd be glad to help.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ankibano

There is no need for the If().

!IsBlank(Dropdown1.Selected.employee_id)is either true or false by itself.

@@Drrickryp

Department of Redundancy Department
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LucasAnjos ,

Thank you for your reply

the formula is providing the below error
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp ,

Thank you for reply !
Eventhough removing IF() did not help to get desired result.
LucasAnjos on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @ankibano , is this a new error ? Because it is the same code that you were using before, I just put it into a if statement.

Nevertheless, we can try something else. Are you trying to filter a sharepoint list? We could try put this data in a collection (if you're not using it already). This could improve performance and would be easier to manipulate.

If it is a sharepoint list, we could do something like this:

In the OnSelect property of the button that navigates to this screen, use this code:
ForAll(Employee, //this must be the name of your sp list
Collect(
colEmployee,//name of the collection
{
Name: ThisRecord.Name // change "name" for exactly the same column name of your sp list
}))

You can include more columns in your collection, if you need, just add " ; " to break the line.

Remember: you will always add data to this collection when you click on that button, so I suggest to use Clear ( colEmployee ) in the "back" button, for example.

If you add a collection like this, I'm sure that code that we talked before will work just fine.
Verified answer

LucasAnjos on at

Like
a
(0)

Report
Copy link

Link copied!

I forgot to include this in the formula:

If( !IsBlank(Dropdown1.Selected.employee_id),
Filter(Employee, employee_name = Dropdown.Selected.Value),
false)
you should use dropdown.selected.value to use the value inside the dropdown.
LucasAnjos on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @ankibano , is it working?
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Thank you for your contribution !

I forgot to mentioned that I was using Filter(Employee, employee_name = Dropdown.Selected.Value || Blank()) and in my dataset we have blank values for employee name.

We were connecting to datasources using custom connector.

After removing the Blank from FILTER function, the solution started working