cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoseCamilo
Frequent Visitor

Filtering a Drop Down by a Data Card

Hi,

I'm new on Power Apps and I created a Collection, on a button:

 

ClearCollect(
Envio;
{NIVEL:"Agente Inicial";ATIVIDADE:"Portal";PONTOS:"5"};
{NIVEL:"Agente Inicial";ATIVIDADE:"Minuto";PONTOS:"5"};

{NIVEL:"Agente Bronze";ATIVIDADE:"Portal";PONTOS:"5"};
{NIVEL:"Agente Bronze";ATIVIDADE:"Minuto";PONTOS:"5"};

{NIVEL:"Agente Prata";ATIVIDADE:"Portal";PONTOS:"5"};
{NIVEL:"Agente Prata";ATIVIDADE:"Minuto";PONTOS:"5"};
{NIVEL:"Agente Prata";ATIVIDADE:"GT";PONTOS:"20"};

{NIVEL:"Agente Prata";ATIVIDADE:"P&D";PONTOS:"10"};

 

{NIVEL:"Agente Ouro";ATIVIDADE:"Portal";PONTOS:"15"};
{NIVEL:"Agente Ouro";ATIVIDADE:"Minuto";PONTOS:"5"};
{NIVEL:"Agente Ouro";ATIVIDADE:"GT";PONTOS:"20"};
{NIVEL:"Agente Ouro";ATIVIDADE:"P&D";PONTOS:"10"}
)

 

On the Drop Down Atividade, I want to filter by the text on the Data Card Nível. Like: Filter(Envio;NIVEL="Agente Prata"), where the "Agente Prata" can be changed on the Data Card.

 

Is this possible?
Many thanks!

 

JoseCamilo_0-1664386004598.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Kristóf
Microsoft
Microsoft

How do you want to filter by "Data Card" if it is a text input, you can set a default value for it or type exactly the value of the text and you can set Items property on the dropdown like this:
Filter(Envio;ATIVIDADE;NIVEL = TextInput1.Text)  

View solution in original post

2 REPLIES 2
Kristóf
Microsoft
Microsoft

How do you want to filter by "Data Card" if it is a text input, you can set a default value for it or type exactly the value of the text and you can set Items property on the dropdown like this:
Filter(Envio;ATIVIDADE;NIVEL = TextInput1.Text)  

Hi, Kristóf.

Worked perfectly!

Many thanks!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,622)