Microsoft Forms (business account)

%3CLINGO-SUB%20id%3D%22lingo-sub-1192643%22%20slang%3D%22en-US%22%3EMicrosoft%20Forms%20(business%20account)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1192643%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Microsoft%20Forms%26nbsp%3B(business%20account)%20I%20have%20created%20a%20form%20in%20which%20it%20is%20possible%20to%20click%20on%20a%20number%20of%20names.%26nbsp%3BI%20would%20like%20to%20arrange%20the%20form%20so%20that%20the%20person%20whose%20name%20has%20been%20clicked%20will%20receive%20an%20email%20with%20a%20link%20to%20the%20completed%20form.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20idea%20if%20this%20is%20possible%20and%20if%20so%20can%20I%20'build'%20this%20in%20Power%20Automate%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1192643%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1192770%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20(business%20account)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1192770%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F567342%22%20target%3D%22_blank%22%3E%40Pol25%3C%2FA%3E%26nbsp%3Bwhat%20we%20always%20do%20with%20our%20Microsoft%20Forms%20at%20our%20company%20is%20-%20via%20a%20flow%20in%20Power%20Automate%20-%20to%20save%20them%20into%20a%20SharePoint%20list%20and%20then%20send%20the%20submitter%20an%20email%20with%20confirmation%20of%20the%20answers%20they%20gave%20in%20the%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%220-Form.png%22%20style%3D%22width%3A%20877px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173386i95C1064725BFAB6A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%220-Form.png%22%20alt%3D%220-Form.png%22%20%2F%3E%3C%2FSPAN%3E%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%220-trigger-getDetails-GetUser.png%22%20style%3D%22width%3A%20586px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173384iDA46E21A2D08F1F6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%220-trigger-getDetails-GetUser.png%22%20alt%3D%220-trigger-getDetails-GetUser.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20SharePoint%20list%20item%20is%20then%20created.%20You%20need%20to%20have%20a%20column%20for%20each%20question.%20Next%20we%20get%20the%20file%20path%20of%20the%20image%20we%20are%20going%20to%20add%20to%20the%20email.%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%221-createItem-getFile.png%22%20style%3D%22width%3A%20588px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173390iB71322761759B84F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%221-createItem-getFile.png%22%20alt%3D%221-createItem-getFile.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20flow%20uses%20parallel%20branching%20to%20(at%20the%20same%20time)%201)%20send%20the%20order%20to%20the%20person%20handling%20it%2C%20and%202)%20send%20the%20order%20confirmation%20back%20to%20the%20submitter.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20expression%20to%20display%20the%20image%20(in%20pink%20below)%20is%3A%26nbsp%3B%3C%2FP%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3EdataUri(body(%3C%2FSPAN%3E%3CSPAN%3E'Get_file_content_using_path'%3C%2FSPAN%3E%3CSPAN%3E))%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20we're%20adding%20an%20image%20to%20the%20email%20we%20need%20to%20use%20HTML%20tags.%20So%20before%20you%20start%20entering%20the%20body%20of%20the%20email%20click%20the%20code%20icon%20.%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%222-SendEmail.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173387i9FE80E040083AF85%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222-SendEmail.png%22%20alt%3D%222-SendEmail.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20email%20confirmation%3A%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%223-EmailResult.png%22%20style%3D%22width%3A%20587px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173388i04ADD44AD1642054%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%223-EmailResult.png%22%20alt%3D%223-EmailResult.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%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%26nbsp%3B%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-1219248%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Forms%20(business%20account)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1219248%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%3CPRE%3E%3CSPAN%3EThanks%20I%20think%20this%20will%20work.%20I%20will%20get%20started%20with%20this%20and%20let%20you%20know.%3C%2FSPAN%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

Good morning,

 

In Microsoft Forms (business account) I have created a form in which it is possible to click on a number of names. I would like to arrange the form so that the person whose name has been clicked will receive an email with a link to the completed form. 

 

Does anyone have any idea if this is possible and if so can I 'build' this in Power Automate?

 

Thanks in advance!

 

 

2 Replies

@Pol25 what we always do with our Microsoft Forms at our company is - via a flow in Power Automate - to save them into a SharePoint list and then send the submitter an email with confirmation of the answers they gave in the form.

 

0-Form.png

 

0-trigger-getDetails-GetUser.png

 

The SharePoint list item is then created. You need to have a column for each question. Next we get the file path of the image we are going to add to the email.

 

1-createItem-getFile.png

 

The flow uses parallel branching to (at the same time) 1) send the order to the person handling it, and 2) send the order confirmation back to the submitter.

 

The expression to display the image (in pink below) is: 

dataUri(body('Get_file_content_using_path'))

 

As we're adding an image to the email we need to use HTML tags. So before you start entering the body of the email click the code icon </>.

 

2-SendEmail.png

 

The email confirmation:

 

3-EmailResult.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User 

 

 

@Rob Elliott 

Thanks I think this will work. I will get started with this and let you know.