web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Drop Down in Form

Power Apps

Unanswered

Drop Down in Form

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I am building a call notes application that several departments will use. I have got the form setup and a portion is 3 drop downs. The first drop down will be the department which for ease we will say is Agent, Back office, and Coordinator. I have the drop downs setup to pull from a table and am trying to make it show table 7 for example if in drop down one we click agent or table 8 if we select back office in the top drop down. I know it would be a if( formula but I struggle with getting it to work. Any assistance would greatly be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

If I read you right, you want to show the data differently depending on the selected dropdown value in Dropdown-1 (top dropdown).
1. if user select "agent" the data should be pulled from table7
2. if user select "back office" the data should be pulled from table8

If my understanding is right onChange property use the below formula:
if(topdropdown.selected.value="agent", ClearCollect(collTableData,Filter(table7,Title="agent"), if(topdropdown.selected.value="backOffice", ClearCollect(collTableData,Filter(table8,Title="backOffice")))
Assign that collection to a gallery to see the results.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Actually, based on your description, I still have some questions.

1)What are the 3 drop downs' Items? What are the 3 drop downs used for?

You only said you use the first drop down to display department(Agent, Back office, and Coordinator).

You want to display different tables based on the selection of this drop down.

2)Where do you want to display the table based on the selection of the department drop down?

3)How do you create table7 or table8? Directly from data source?

4)What is the data type of department field?

For the limited information that you've provided, I agree with @KrishnaV . If his assumption is incorrect, please answer the questions above. Then I will give you my advice.

Best regards,

Was this reply helpful? Yes No

Join the conversation