How do I change the choices for one field, based on the selection of another field?

(0) Share

Report

Posted on by noahh97

I have a form with these 'choice' fields,

Select Organization: (Organization 1, Organization 2)

Select Location: (Location 1, Location 2, Location 3, Location 4, Location 5)

If a user selects "Organization 1" They should only be able to select (Location 1, Location 2)

And if they select "Organization 2" They should only be able to select (Location 3, Location 4, Location 5)

----

Using this code I've almost got it to work, but will only show 1 Location, not all 3.

In my Location card 'Items'

If(DataCardValue30.Selected.Value = "Organization 2",LookUp(Choices([@'List'].Location),Value="Location 1" && "Location 2" && "Location 3"), Parent.Default)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@noahh97

Are these actual Choice columns in your datasource, or are they somehow related?

Are you trying to make this relationship in your app itself as hard-coded conditions or something else?

Was this reply helpful? Yes No
noahh97 21 on at

Like (0)

Report

Yes they are choice columns in the Sharepoint list.
and yes trying to make these hard coded conditions, so that users cannot select an Organization with the wrong values for Location

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@noahh97

Since you're hard-coding, there is no real reason to rely on the Choice column values as they exist in the list because you have no relationship between them, and you're putting it in by hand.

So...with that in mind, change your Select Organization dropdown Items property to:

Table( {Org: "Organization 1", Locations: ["Location 1", "Location 2"]} {Org: "Organization 2", Locations: ["Location 3", "Location 4", "Location 5"]} )

And then change your Location dropdown Items property to:

yourOrganizationDropdownName.Selected.Locations

This will give you what you are looing for.

Was this reply helpful? Yes No
Guicord101 151 on at

Like (1)

Report

Hi!
I have the same situation as the post in my app and your code worked except for 1 point:
After the user selects the option the data from the "organization" dropdown is not sent to sharepoint. Any idea what it could be?

Was this reply helpful? Yes No
maxbett 3 on at

Like (0)

Report

The same thing has happened with my project. It hasn't returned the first datapoint needed. Did you find a fix?

Was this reply helpful? Yes No
Guicord101 151 on at

Like (0)

Report

Hi! I used the cascading data
https://www.youtube.com/watch?v=Qzpjq008cBY

it worked for me

Was this reply helpful? Yes No