Filled value depending on another value

%3CLINGO-SUB%20id%3D%22lingo-sub-2044538%22%20slang%3D%22en-US%22%3EFilled%20value%20depending%20on%20another%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2044538%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20if%20it%20is%20possible%20but%20I%20have%202%20columns%2C%20in%20a%20Sharepoint%20List%3A%3C%2FP%3E%3CUL%3E%3CLI%3EColumn%201%20with%203%20choices%3A%20Refused%2C%20Accepted%2C%20Studied%3C%2FLI%3E%3CLI%3EColumn%202%20with%203%20choices%3A%20Waiting%2C%20In%20progress%2C%20Treated%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20an%20user%20chooses%20%22accepted%22%20or%20%22studied%22%20in%20column%201%2C%20I%20want%20the%20column%202%20to%20automatically%20turn%20on%20%22In%20progress%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20dont%20know%20how%20to%20do%20this%20using%20power%20apps%2C%20can%20you%20help%20me%20please%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2044538%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2046172%22%20slang%3D%22en-US%22%3ERe%3A%20Filled%20value%20depending%20on%20another%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2046172%22%20slang%3D%22en-US%22%3EIf%20you%20have%20customized%20the%20form.%20You%20can%20go%20to%20the%202nd%20drop%20down%20and%20unlock%20it.%20Then%20for%20the%20default%20and%20I%20think%20it%E2%80%99s%20values%20or%20items%20property%20you%20would%20put%20an%20statement%20saying%20if(dropdown1.value%20%3D%20%E2%80%9Caccepted%E2%80%9D%20%7C%7C%20%E2%80%9Cstudied%E2%80%9D%2C%20choices(%E2%80%9Cin%20progress%E2%80%9D)%2Cchoices(%E2%80%9Cwaiting%E2%80%9D%2C%E2%80%9Din%20progress%E2%80%9D%2C%E2%80%9Dtreated%E2%80%9D))%20in%20the%20values%2Fitems%20property.%20%3CBR%20%2F%3E%3CBR%20%2F%3EThen%20for%20default.%20if(dropdown1.value%20%3D%20%E2%80%9Caccepted%E2%80%9D%20%7C%7C%20%E2%80%9Cstudied%E2%80%9D%2C%E2%80%9Cin%20progress%E2%80%9D%2C%E2%80%9D%E2%80%9D)%3CBR%20%2F%3E%3CBR%20%2F%3EYou%E2%80%99ll%20have%20to%20lookup%20exact%20format%20for%20these%20functions%20but%20that%E2%80%99s%20the%20overall%20way%20to%20do%20it.%20On%20phone%20I%E2%80%99m%20bed%20so%20can%E2%80%99t%20really%20look%20in%20that%20deep.%20Hopefully%20this%20helps.%3C%2FLINGO-BODY%3E
Visitor

Hello everyone,

 

I don't know if it is possible but I have 2 columns, in a Sharepoint List:

  • Column 1 with 3 choices: Refused, Accepted, Studied
  • Column 2 with 3 choices: Waiting, In progress, Treated

 

If an user chooses "accepted" or "studied" in column 1, I want the column 2 to automatically turn on "In progress".

 

I dont know how to do this using power apps, can you help me please

1 Reply
If you have customized the form. You can go to the 2nd drop down and unlock it. Then for the default and I think it’s values or items property you would put an statement saying if(dropdown1.value = “accepted” || “studied”, choices(“in progress”),choices(“waiting”,”in progress”,”treated”)) in the values/items property.

Then for default. if(dropdown1.value = “accepted” || “studied”,“in progress”,””)

You’ll have to lookup exact format for these functions but that’s the overall way to do it. On phone I’m bed so can’t really look in that deep. Hopefully this helps.