SOLVED

How to generate key value pairs for choices or something like that?

%3CLINGO-SUB%20id%3D%22lingo-sub-1538597%22%20slang%3D%22en-US%22%3EHow%20to%20generate%20key%20value%20pairs%20for%20choices%20or%20something%20like%20that%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1538597%22%20slang%3D%22en-US%22%3E%3CP%3EWithin%20my%20Microsoft%20Form%20project%20I%20will%20have%20a%20list%20of%20names%20that%20my%20end-user%20can%20choose%20from.%20I'm%20assuming%20the%20%22choice%22%20option%20is%20the%20best%20for%20the%20job.%20i.e.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Kensley%3C%2FP%3E%3CP%3E%26nbsp%3B-%20John%3C%2FP%3E%3CP%3E-%20Alice%3C%2FP%3E%3CP%3E-%20Sally%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20Microsoft%20Form%20to%20somehow%20associate%20John%20to%20%3CA%20href%3D%22mailto%3Ajdown%40company.com%2C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ejdown%40company.com%2C%3C%2FA%3E%26nbsp%3BAlice%20to%20%3CA%20href%3D%22mailto%3Aawalker%40company.com%2C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eawalker%40company.com%2C%3C%2FA%3E%26nbsp%3BSally%20to%20%3CA%20href%3D%22mailto%3Asman%40company.com%2C%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Esman%40company.com%2C%20%3C%2FA%3Eetc...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20it%20the%20closest%20thing%20I%20can%20do%20to%20achieving%20this%20from%20within%20Microsoft%20Forms%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20end%20goal%20is%20to%20send%20my%20Form%20data%20to%20Power%20Automate%20so%20that%20the%20values%20(the%20email%20addresses%20mentioned%20above%20based%20on%20a%20single%20selection)%2C%20will%20be%20added%20into%20a%20custom%20flow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20should%20I%20do%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1538597%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539582%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20generate%20key%20value%20pairs%20for%20choices%20or%20something%20like%20that%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539582%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F509342%22%20target%3D%22_blank%22%3E%40kensleylewis%3C%2FA%3E%26nbsp%3Byou%20can't%20do%20this%20in%20forms%20but%20you%20CAN%20do%20it%20in%20the%20flow%20in%20Power%20Automate%20because%20Forms%20knows%20who%20has%20submitted%20the%20form-%26nbsp%3B%20assuming%20the%20responders%20are%20all%20within%20your%20organisation%20they%20don't%20need%20to%20enter%20their%20name%20or%20email%20address.%20It%20looks%20like%20you%20are%20sending%20the%20email%20to%20the%20responder%20so...%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EYour%20trigger%20will%20be%20the%20Forms%20%3CEM%3EWhen%20a%20new%20response%20is%20submitted%3C%2FEM%3E%3B%3C%2FLI%3E%3CLI%3EYour%20first%20action%20will%20be%20the%20Forms%20%3CEM%3EGet%20response%20details%3C%2FEM%3E%3B%3C%2FLI%3E%3CLI%3EYou%20will%20then%20add%20an%20Office%20365%20Users%20action%20of%20%3CEM%3EGet%20user%20profile%20(v2)%3A%3C%2FEM%3E%3C%2FLI%3E%3CLI%3EIn%20your%20%3CEM%3ESend%20an%20email%20(v2)%3C%2FEM%3E%20action%20the%20%22To%22%20field%20will%20be%20%3CSTRONG%3EMail%2C%3C%2FSTRONG%3E%20selected%20from%20the%20Get%20user%20profile%20section%20of%20the%20dynamic%20content.%3C%2FLI%3E%3C%2FOL%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%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539667%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20generate%20key%20value%20pairs%20for%20choices%20or%20something%20like%20that%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539667%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eahhh!!!%20your%203.%20and%204.%20is%20what%20I've%20been%20missing%20out%20on%20all%20day!%26nbsp%3B%20Many%20thanks%20on%20helping%20me%20to%20expand%20my%20mind%20on%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1539681%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20generate%20key%20value%20pairs%20for%20choices%20or%20something%20like%20that%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1539681%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20responded%20too%20fast%20to%20your%20answer.%26nbsp%3B%20I%20have%20one%20question...in%20step%203%2C%20how%20do%20I%20know%20that%20the%20Office%20365%20users%20action%20will%20associate%20to%20any%20person%20that%20was%20selected%20from%20the%20Microsoft%20Form%20choice%20list%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%20for%20saving%20the%20day!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Within my Microsoft Form project I will have a list of names that my end-user can choose from. I'm assuming the "choice" option is the best for the job. i.e.

 

 - Kensley

 - John

- Alice

- Sally

 

I want Microsoft Form to somehow associate John to jdown@company.com, Alice to awalker@company.com, Sally to sman@company.com, etc...

 

What it the closest thing I can do to achieving this from within Microsoft Forms?

 

The end goal is to send my Form data to Power Automate so that the values (the email addresses mentioned above based on a single selection), will be added into a custom flow.

 

What should I do?

2 Replies
Highlighted
Best Response confirmed by kensleylewis (Contributor)
Solution

@kensleylewis you can't do this in forms but you CAN do it in the flow in Power Automate because Forms knows who has submitted the form-  assuming the responders are all within your organisation they don't need to enter their name or email address. It looks like you are sending the email to the responder so...:

 

  1. Your trigger will be the Forms When a new response is submitted;
  2. Your first action will be the Forms Get response details;
  3. You will then add an Office 365 Users action of Get user profile (v2):
  4. In your Send an email (v2) action the "To" field will be Mail, selected from the Get user profile section of the dynamic content.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Highlighted

@Rob Elliott 

 

ahhh!!! your 3. and 4. is what I've been missing out on all day!  Many thanks on helping me to expand my mind on this.