Dropdown results.

(0) Share

Report

Posted on by RL-26071304-0

126

Hello.

I have an Excel table called "Tabela_ACTIVITIES".

In this table I have 3 columns: "DEPARTMENT", "TIMELINE", "ACTIVITIES".

On PowerApps, I have 3 dropdowns: one for "DEPARTMENT", another one for "TIMELINE" and a third one for "ACTIVITIES".

What I would like to do is this.

When I select "DEPARTMENT" and "TIMELINE", the "ACTIVITIES" dropdown should just show the activities regarding my previous choice.

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hey!

You can use Filter to that. Write this on Items property of your combobox.

To timeline:

Filter(DataSource, Department = Dropdown1.Selected.Value).Timeline

To Activities:

Filter(DataSource, Timeline = Dropdown2.Selected.Value, Department = Dropdown1.Selected.Value).Activities

It sould be something like that

Also, not sure but I think that excel does not work with multi filtering so, if needed, you should create a collection with that data and after that, use that collection instead

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
RL-26071304-0 126 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your help.
I also would like to know if there is a way to show in DEPARTMENT dropdown non repetitive items from the same table.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You can use function Distinct

Distinct(Datasource.Department)

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
RL-26071304-0 126 on at

Like (0)

Report
Copy link

Link copied!

How can I use the DISTINCT function with this one
"Filter(Tabela_DEP_TIM_ACT, DEPARTMENT = Dropdown1_3.Selected.Result).TIMELINE" ?

If I don't use it, I get many repetitive fields.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Distinct(Filter(Tabela_DEP_TIM_ACT, DEPARTMENT = Dropdown1_3.Selected.Result).TIMELINE)

Was this reply helpful? Yes No