cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Imade
Helper I
Helper I

ComboBox function

Hello,

 

I would like to have specific values when I select specitif city on the field.

2021-01-27 00_55_44-Litiges - Enregistrées (non publiées) - Power Apps.png

 

So in the DefaultSeletedItems of "PlateForme" i put this function :

(DataCardValue3 is "Site de Rattachement")

 

 

If(
    DataCardValue3.Selected.Value="Bondoufle";
    {
        Value: "STEF/ POUR LE MANS""||STEF/POUR TOURS"||"STEF/POUR NANTES"
    } 
)

 

 

I don't know how to do it on several cities and display only the platforms attached to that city.

when i use the "&" function it work but it field automaticly the field

 

 

Could you please help me 🙏


Thank you in advance

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

Hi @Imade ,

 

I think a relationship between these two dropdowns should be established, and to establish the relationship, you need to go to your SharePoint list and create the records for them, for example, you have a city that has 5 platform, then 5 records need to be created.

 

And then in your platform dropdown, you can use Filter function in the property Item to find the related values.

View solution in original post

Thanks to both of you my problem is solved
if it helps, I used this video :

https://www.youtube.com/watch?v=40-QCkdXijo

 

Best Regards,

Imade

View solution in original post

7 REPLIES 7
mdevaney
Super User
Super User

@Imade 
Can you please share a sample of your data?  This way I can see how the relationship is defined and give a suggestion.

Yes of course @mdevaney  :

it a SharePoint list with 2 column choice

 

Site de rattachement :

Imade_0-1611705906733.png

 

PlateForm :

Imade_1-1611705918069.png

 

 

 

 @Imade 
OK, can you please post some sample records so I can tell you how to code it?

mdevaney
Super User
Super User

@Imade 
By the way, what you are trying to do is called a cascading dropdown.  In my opinion they are easier without Choices values.  Happy to help!

@mdevaney 
What I want to do is when a city is selected only the values of that city will be displayed in the following field.
I don't have any matches on my list
I would like to say if this selected value, you only display this. And then the user chooses the value

Hi @Imade ,

 

I think a relationship between these two dropdowns should be established, and to establish the relationship, you need to go to your SharePoint list and create the records for them, for example, you have a city that has 5 platform, then 5 records need to be created.

 

And then in your platform dropdown, you can use Filter function in the property Item to find the related values.

View solution in original post

Thanks to both of you my problem is solved
if it helps, I used this video :

https://www.youtube.com/watch?v=40-QCkdXijo

 

Best Regards,

Imade

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,307)