Skip to main content

Notifications

Community site session details

Community site session details

Session Id : d3s5n1UzP39Qyhmu/KvkEd
Power Apps - AI Builder
Suggested answer

Cascading fields

Like (2) ShareShare
ReportReport
Posted on 9 Sep 2024 06:17:24 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:
  • ED-03090921-0 Profile Picture
    277 on 09 Sep 2024 at 12:45:26
    Cascading fields
    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.
     
  • Suggested answer
    Michael E. Gernaey Profile Picture
    41,969 Super User 2025 Season 1 on 09 Sep 2024 at 12:23:22
    Cascading fields
    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,

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - AI Builder

Overall leaderboard