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