SOLVED

Display Office 365 Username when enter email address

%3CLINGO-SUB%20id%3D%22lingo-sub-1372278%22%20slang%3D%22en-US%22%3EDisplay%20Office%20365%20Username%20when%20enter%20email%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1372278%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20come%20we%20automatically%20display%20the%20Office%20365%20username%20and%20other%20profile%20field%20when%20user%20enter%20their%20email%20address%20into%20the%20MS%20Forms%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1372278%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMS%20Form%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1372451%22%20slang%3D%22en-US%22%3ERe%3A%20Display%20Office%20365%20Username%20when%20enter%20email%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1372451%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660245%22%20target%3D%22_blank%22%3E%40EugeneBoon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EForms%20cannot%20do%20O365%20look%20ups.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlternatively%2C%20if%20the%20form%20is%20organisation%20only%2C%20you%20can%20take%20the%20submitted%20form%20and%20use%20Power%20Automate%20to%20access%20the%20responders%20data%20and%20save%20it%20to%20SharePoint%2C%20manipulate%20it%2C%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20form%20is%20for%20anyone%20to%20fill%20in%2C%20you%20can%20capture%20the%20email%20address%20and%20use%20it%20to%20do%20an%20O365%20look%20up%20in%20Power%20Automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1372573%22%20slang%3D%22en-US%22%3ERe%3A%20Display%20Office%20365%20Username%20when%20enter%20email%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1372573%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%20Thank%20you%20for%20the%20respond.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20per%20your%20knowledge%2C%20with%20Power%20Automate%2C%20do%20you%20think%20it%20is%20able%20to%20do%20retrieve%20O365%20Info%2C%20while%20the%20users%20filling%20the%20MS%20Form%3F%20what%20we%20are%20trying%20to%20do%20is%20to%20have%20some%20field%20in%20MS%20Form%20auto%20filled%2Fpopulated%20with%20O365%20details%20for%20user%20inside%20organization%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3EFor%20user%20inside%20organization%3C%2FSTRONG%3E%3C%2FU%3E%3CBR%20%2F%3E1.%20User%20enter%20Name%20in%20MS%20Form%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Info%20such%20as%20other%20details%20Department%2C%20Contact%20Number%2C%20Email.%20Company%20Name%20auto%20populated%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3E%3CSTRONG%3EFor%20user%20outside%20organization%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%3CP%3E1.%20all%20field%20is%20manually%20entered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20i%20check%20the%20MS%20Form%20trigger%20for%20power%20automate%20is%20after%20the%20form%20submitted.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1372668%22%20slang%3D%22en-US%22%3ERe%3A%20Display%20Office%20365%20Username%20when%20enter%20email%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1372668%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660245%22%20target%3D%22_blank%22%3E%40EugeneBoon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20it%20wouldn't%20work%20in%20the%20form%20in%20real%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20use%20the%20Form%20and%20Power%20Automate%20when%20the%20form%20is%20set%20to%20my%20organisation%20only%2C%20I%20%3CU%3Eleave%20out%3C%2FU%3E%20questions%20like%20First%2FLast%20name%2C%20Department%2C%20Phone%2C%20etc%20as%20Office%20365%20already%20knows%20who%20that%20person%20is.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20they%20submit%20the%20form%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Use%20trigger%20%3CSTRONG%3EWhen%20a%20new%20response%20is%20submitted%3C%2FSTRONG%3E%20to%20flag%20the%20new%20submission.%3C%2FP%3E%3CP%3E2.%20Use%20action%20%3CSTRONG%3EGet%20response%20details%3C%2FSTRONG%3E%20to%20retrieve%20the%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22capture20200508154144228.png%22%20style%3D%22width%3A%20623px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189983i38572C310E5C15C9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22capture20200508154144228.png%22%20alt%3D%22capture20200508154144228.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E3.%20Then%20use%26nbsp%3B%3CSTRONG%3EGet%20user%20profile%20(V2)%3C%2FSTRONG%3E%26nbsp%3Bto%20source%20the%20persons%20Office%20365%20attributes%20to%20use%20as%20needed%20(use%20their%20email%20address).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E4.%20Add%20attributes%20as%20needed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22capture20200508153807053.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%2F189982i1587BAC7EC8CF4A6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22capture20200508153807053.png%22%20alt%3D%22capture20200508153807053.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20your%20form%20sounds%20to%20be%20configured%20for%20internal%2Fexternal%20responders%2C%20you%20would%20use%20the%20Email%20field%20to%20do%20the%20look%20up%20in%20the%20%3CSTRONG%3EGet%20user%20profile%20(V2)%3C%2FSTRONG%3E.%20You%20can%20also%20add%20a%20condition%20in%20to%20say%20if%20the%20email%20is%20external%2C%20do%20this%2C%20and%20if%20it's%20internal%2C%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know%20if%20this%20doesn't%20make%20sense%20and%20I'll%20be%20happy%20to%20step%20you%20through%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20luck%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1378703%22%20slang%3D%22en-US%22%3ERe%3A%20Display%20Office%20365%20Username%20when%20enter%20email%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378703%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3Bthanks%20for%20the%20feedback%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20made%20a%20valid%20point%2C%20for%20internal%20organization%20users%20we%20might%20not%20required%20them%20to%20fill%20in%20the%20info%20as%20we%20already%20have%20the%20o365%20and%20we%20just%20have%20populate%20it%20using%20flow.%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-1378717%22%20slang%3D%22en-US%22%3ERe%3A%20Display%20Office%20365%20Username%20when%20enter%20email%20address%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378717%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F660245%22%20target%3D%22_blank%22%3E%40EugeneBoon%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20internal%20staff%20are%20easy%20since%20Forms%20will%20do%20all%20the%20work%20for%20you.%20Very%20handy%20and%20the%20flow%20option%20I've%20described%20will%20help%20you%20take%20their%20O365%20attributes%20and%20do%20what%20you%20need%20to%20do%20with%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20wishes%20with%20this.%20Hope%20it%20all%20goes%20well%20for%20you%20and%20have%20a%20great%20week%20ahead!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

How come we automatically display the Office 365 username and other profile field when user enter their email address into the MS Forms?

5 Replies

Hi @EugeneBoon 

 

Forms cannot do O365 look ups.

 

Alternatively, if the form is organisation only, you can take the submitted form and use Power Automate to access the responders data and save it to SharePoint, manipulate it, etc.

 

If the form is for anyone to fill in, you can capture the email address and use it to do an O365 look up in Power Automate.

 

Cheers

Damien

@Damien Rosario  Thank you for the respond.

 

As per your knowledge, with Power Automate, do you think it is able to do retrieve O365 Info, while the users filling the MS Form? what we are trying to do is to have some field in MS Form auto filled/populated with O365 details for user inside organization

 

For user inside organization
1. User enter Name in MS Form 

2. Info such as other details Department, Contact Number, Email. Company Name auto populated

 

For user outside organization

1. all field is manually entered.

 

As i check the MS Form trigger for power automate is after the form submitted. 

best response confirmed by EugeneBoon (New Contributor)
Solution

Hello @EugeneBoon 

 

No it wouldn't work in the form in real time.

 

When I use the Form and Power Automate when the form is set to my organisation only, I leave out questions like First/Last name, Department, Phone, etc as Office 365 already knows who that person is.

 

When they submit the form:

 

1. Use trigger When a new response is submitted to flag the new submission.

2. Use action Get response details to retrieve the data.

 

capture20200508154144228.png

 

3. Then use Get user profile (V2) to source the persons Office 365 attributes to use as needed (use their email address).

 

4. Add attributes as needed.

 

capture20200508153807053.png

 

As your form sounds to be configured for internal/external responders, you would use the Email field to do the look up in the Get user profile (V2). You can also add a condition in to say if the email is external, do this, and if it's internal, do this.

 

Let me know if this doesn't make sense and I'll be happy to step you through it.

 

Good luck

Damien

@Damien Rosario thanks for the feedback,

 

You made a valid point, for internal organization users we might not required them to fill in the info as we already have the o365 and we just have populate it using flow.

 

 

Hi @EugeneBoon 

 

Yes, internal staff are easy since Forms will do all the work for you. Very handy and the flow option I've described will help you take their O365 attributes and do what you need to do with them.

 

Best wishes with this. Hope it all goes well for you and have a great week ahead!

 

Cheers

Damien