Drop down based on Radio

(0) Share

Report

Posted on by MNJ116

Hello,

I have the following scenario,

- Radio buttons that represents Gender (M,F,D)

- SharePoint List with 3 Columns (Job M, Job F, Job D)

P.S. in German language the noun changes based on gender for example

M: Mitarbeiter (Worker)

F: Mitarbeiterin (Worker) ...etc

Therefore, I want to update the drop down Items based on Radio button selection.

I tried if statement for drop down items, but it didn't work.

I also tried creating a collection based on the Radio selection

If(Self.Selected.Value= "M",
ClearCollect(colJobs,
{Job:SPLIST.JobM}),
If(Self.Selected.Value= "F",
ClearCollect(colJobs,
{Job:SPLIST.JobF}),
If(Self.Selected.Value= "D",
ClearCollect(colJobs,
{Job:SPLIST.JobD}),
Blank()))))

in Drop down items I placed colJobs or colJobs.Job however that also didnt work.

Any suggestions?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

TheRobRush 11,128 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Heres a simple way, ignore the collecting radio selection stuff.

Add dropdown, and make it a switch liek so (change my names to match yours)

Switch( ///The Name of my radio is radio2 Radio2.Selected.Value, ///its options are 1 2 & 3 ///if it is 1, i take the title column from EventArchive list, and rename it Dropdown 1,RenameColumns(ShowColumns(EventArchive, "Title"),"Title","Dropdown"), ///if 2, i take the schoolname column from EventMaster list, and rename it Dropdown 2,RenameColumns(ShowColumns(EventMaster, "SchoolName"),"SchoolName","Dropdown"), ///for 3, i take the tonightseventdate col. from eventdate list, and name it Dropdown RenameColumns( ShowColumns(EventDate, "TonightsEventDate"),"TonightsEventDate","Dropdown") )

I then set the Value on right bar to dropdown and its good to go
neuronic 177 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, you have three genders (M,F,D). So i guess you are using three radio buttons?
If so, it can get complicated because you would have to ensure they do not give conflicting information.
Did you trigger clearCollect by adding the code to the on Change property of the button?
It is awkward if the jobs are in three columns. Could all the jobs go in one column & then add a gender column?
MNJ116 25 on at

Like
a
(1)

Report
Copy link

Link copied!

This worked like charm.
Thanks
MNJ116 25 on at

Like
a
(1)

Report
Copy link

Link copied!

Thought of doing that. But The accepted solution solved it.
Thanks any ways