Conditionally filtering options from Radio control

(1) Share

Report

Posted on by ShanePhillips

111

Hello all, I swear I posted this yesterday morning but do not see my post in the forum or in "My Activity".

I'd like to conditionally filter options from a radio button. The set up is that I have a primary radio selection, and based on the option selected in radio1, radio2's options are filtered by if there are any of those options still available.

If the specific combination of Radio1's option and Radio2's option are out of stock, then filter that radio (or grey out) that Radio2 option as being available.

That condition will apply to each Radio2 option for each Radio1 option selected. I can do this with an If statement one at a time, but haven't figured out how to do it across multiple options.

Is this possible? This is for a sign up sheet but it's basically a order picker. I can't find my answer but I may not be using the correct keywords in my searching.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

ronaldwalcott 3,888 Moderator on at

Like (0)

Report
Copy link

Link copied!

The Radio options are provided by a list or other source of data. What is the If statement you are using and what do mean by doing it across multiple options?

If I select option A in Radio1 then can't you adjust the values in Radio2? I think it could be done by storing the radio items in a collection with a column indicating which options are active based on the option chosen in Radio1.

I may be misunderstanding your requirements.

Was this reply helpful? Yes No
ShanePhillips 111 on at

Like (0)

Report
Copy link

Link copied!

Hi Ronald, thanks for responding. This is actually part of that signup sheet question I'd posted recently that you responded to as well.

Option 1 radio control could be set to Item in the below table.

Option 2 radio control could be set to Size.

If user selects Red Tshirt and there are no more smalls available, small is removed from the option 2 radio control because it's out of stock.

Honestly I'm not sure what the best option for setting up the data source would be either. I could make a table of each line item, and do a count and remove options via an IF statement, or I patch in user names into a column and I have a row for each option combo and only display blank options in the control.

Was this reply helpful? Yes No
ronaldwalcott 3,888 Moderator on at

Like (0)

Report
Copy link

Link copied!

One way is you would have a table with the t-shirts then another table linked to it with the sizes and quantity available.

Create a collection for the radio button based on the t-shirts.

Create a collection for the second radio button based on the availability of the size.

Was this reply helpful? Yes No
ShanePhillips 111 on at

Like (0)

Report
Copy link

Link copied!

Can you explain to me the benefits of two collection tables, and are you recommending two source tables? Why not one table? I've looked into collections and am learning, but I don't understand yet how this helps solve. Thanks in advance.

Was this reply helpful? Yes No
ronaldwalcott 3,888 Moderator on at

Like (0)

Report
Copy link

Link copied!
I don't know your complete design so I am only proposing a possible solution.

You said that you wanted two radio controls. The options in a radio control are normally unique hence using two collections.

I am presuming that your workflow is

Select a colored t-shirt from the radio button (your first radio button can therefore use a collection containing the types of t-shirt colours)

When the t-shirt is chosen you can check your inventory and select the sizes that have stock and add those sizes to the collection used by the size radio control

You now know the type of shirt and the size chosen by the user

Have you started working on a solution or are you in the concept phase?

Was this reply helpful? Yes No
ShanePhillips 111 on at

Like (0)

Report
Copy link

Link copied!

I've started working on it but am still very much learning and cannot say I have a model in place. Thank you for taking the time to help me learn.

You have the workflow correct. To add to that, if I'm all out of sizes then that tshirt color is removed from the first radio control.

Was this reply helpful? Yes No
Suggested answer

ronaldwalcott 3,888 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have you been though the learn modules yet? If you face a problem then you can ask it here but I don't believe that anyone will have the time to walk through the entire solution design and how to program it.

Please like the replies if they were of any help. Thanks.

Was this reply helpful? Yes No
ShanePhillips 111 on at

Like (0)

Report
Copy link

Link copied!

Yes I have worked through many of them. They don't necessarily teach the best way to set up a model from scratch if you've never done it before, though I'll dig back through them.

Was this reply helpful? Yes No
CU10021449-0 on at

Like (0)

Report
Copy link

Link copied!

Yes, it is possible to conditionally filter radio button options based on the selection of another radio button. The best way is to use a dynamic filtering function where Radio2 options update automatically when a Radio1 option is selected. You can use JavaScript in most form builders or platforms like Roblox UI scripting to loop through Radio2 options and disable or hide the ones that are out of stock based on the selected Radio1 value. This avoids writing separate if statements for every combination and makes your form cleaner and more scalable.

Was this reply helpful? Yes No
Suggested answer

Power Platform 1919 2,219 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @ShanePhillips ,
Can you please try this way: (TShirtInventory is a sample collection)
In Radio Control 1: Keep Items as per screen shot

In Radio Control 2: Keep Items as per screenshot:

Sample demo:

Was this reply helpful? Yes No