web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Suggested Answer

Cascading fields

(2) ShareShare
ReportReport
Posted on by 277
Hi
I building my app but I have a problem
 
I Have one field called "VSM concernée" which have 5 choices : Mesure, Niveau, Scie, Pince, Logisitique. And I have an another field 
"Responsable concerné" with 3 choices : Sandro, Antoine, Adrien. 
I want that if Mesure, Niveau, Scie are selected => Sandro in the second field
If Pince => Antoine
If logisitique => Adrien
 
I tried this formula, it's working but  I have this error "invalid argument type
Location: DataCardValue9"
 
Switch(DataCardValue3.Selected.Value;
    'VSM concernée (Table_Data_SAP_Worflow)'.Mesure;
       LookUp(Choices('Responsable concerné (Table_Data_SAP_Worflow)'); Value = 'Responsable concerné (Table_Data_SAP_Worflow)'.Sandro);
    'VSM concernée (Table_Data_SAP_Worflow)'.Pince;
        LookUp(Choices('Responsable concerné (Table_Data_SAP_Worflow)'); Value = 'Responsable concerné (Table_Data_SAP_Worflow)'.Antoine);
    'VSM concernée (Table_Data_SAP_Worflow)'.Logistique;
       LookUp(Choices('Responsable concerné (Table_Data_SAP_Worflow)'); Value = 'Responsable concerné (Table_Data_SAP_Worflow)'.Adrien)        
)
 
 
Just now when I selected "Mesure" in the first field, I have only the choice "Sandro" in the seconnd field like I want.
But what I want it's when I have "Mesure", it's select automatically "Sandro"
Can you help me to finish ?
Categories:
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,970 Super User 2026 Season 2 on at
    Hi
     
    I am the one who gave you what to do, which you didn't mark as the answer... so not really cool.
     
    The Error is because you are using the Datacard
    NOT the control as I said, you need to use the ComboBox1.Selected.Value , whatever the name of your 1st Combobox is, replace Datacardvalue9 with
     
    NOT the datacard, which has no value.
     
    Please mark answers as answers.
     
    Thanks,
  • ED-03090921-0 Profile Picture
    277 on at
    Hi FLMike
     
    I wanted accept your solution but I have this bug when I clicked on accepted "This charges continuously".(see below)
     
    And I don't undrestand what i'm supposed to change I have nothing else that the datacard, I don't have combobox.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 258

#3
Mohsin Ali Profile Picture

Mohsin Ali 231

Last 30 days Overall leaderboard