ComboBox function

[Imade]

Hello,

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

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

[mdevaney]

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

[Imade]

Yes of course @mdevaney  :

it a SharePoint list with 2 column choice

Site de rattachement :

PlateForm :

[mdevaney]

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

[mdevaney]

@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!

[Imade]

@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

[Anonymous · Accepted solution]

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.

[Imade · Accepted solution]

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