getting 2 different value in one record (In one row 2 drop downs to be selected)

%3CLINGO-SUB%20id%3D%22lingo-sub-2148731%22%20slang%3D%22en-US%22%3Egetting%202%20different%20value%20in%20one%20record%20(In%20one%20row%202%20drop%20downs%20to%20be%20selected)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2148731%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20sure%20above%20subject%20not%20is%20not%20too%20much%20clear.%3C%2FP%3E%3CP%3EI%20will%20explain%20as%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20sharing%20a%20MSForms%20link%20within%20the%20organization%20to%20capture%20there%20skills.%3C%2FP%3E%3CP%3ESo%20I%20need%20there%20response%20with%2C%20which%20skill%20they%20have%20and%20how%20many%20years.2%20Input%20fields%20in%20one%20go.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESkills%20set%20is%20defined.%20(May%20be%20around%2030)%20.%20Experience%20list%20is%20also%20defined.(4%20Options).%3C%2FP%3E%3CP%3EI%20need%20to%20have%202%20dropdowns%20close%20by.%20And%20of%20course%20a%20user%20would%20have%20many%20skills.So%20many%20records%20should%20be%20entered%20(One%20record%20meant%20is%20-%20One%20particular%20skill%20with%20its%20experience).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20visualize%20in%20a%20picture%20as%20follows.%20(As%20above%20a%20user%20can%20add%20more%20skill%20records%20)%3C%2FP%3E%3CP%3EIf%20there%20is%20no%20solution%20from%20MS%20Forms%20is%20there%20any%20work%20arounds.%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22experience.png%22%20style%3D%22width%3A%20482px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F255992i8563E185272C41A8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22experience.png%22%20alt%3D%22experience.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Skill.png%22%20style%3D%22width%3A%20429px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F255993i6CB9C1BB36557AEF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Skill.png%22%20alt%3D%22Skill.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2148731%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2148997%22%20slang%3D%22en-US%22%3ERe%3A%20getting%202%20different%20value%20in%20one%20record%20(In%20one%20row%202%20drop%20downs%20to%20be%20selected)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2148997%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F971964%22%20target%3D%22_blank%22%3E%40suresh_abe123%3C%2FA%3E%26nbsp%3BYou%20can%20do%20this%20easily%20with%20Forms%20if%20you%20use%20likert%20scale%20questions%20with%20each%20skill%20as%20a%20statement%20and%20the%20experience%20along%20the%20top.%20You%20can%20have%20up%20to%2020%20statements%20in%20each%20likert%20scale%20question%20so%20with%20approximately%2030%20skills%20you'll%20need%20to%20have%202%20likert%20questions%20in%20your%20form.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22skillsMatrix.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256014i78B984185841757C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22skillsMatrix.png%22%20alt%3D%22skillsMatrix.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am sure above subject not is not too much clear.

I will explain as below.

 

I am sharing a MSForms link within the organization to capture there skills.

So I need there response with, which skill they have and how many years.2 Input fields in one go.

 

Skills set is defined. (May be around 30) . Experience list is also defined.(4 Options).

I need to have 2 dropdowns close by. And of course a user would have many skills.So many records should be entered (One record meant is - One particular skill with its experience).

 

If I visualize in a picture as follows. (As above a user can add more skill records )

If there is no solution from MS Forms is there any work arounds.

 experience.pngSkill.png

 

1 Reply

@suresh_abe123 You can do this easily with Forms if you use likert scale questions with each skill as a statement and the experience along the top. You can have up to 20 statements in each likert scale question so with approximately 30 skills you'll need to have 2 likert questions in your form.

 

skillsMatrix.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User