Get e-mail of user who triggered flow

[Anonymous]

I've created a flow that runs for selected SharePoint item list.

I should be able to get details about user who triggered flow from "For a selected item" action.

There are these properties available from "For a selected item" action, however when the Flow is attached to SharePoint Teams site,

it returns these properties in encoded way.

Everything works fine when same flow is attached to regular SharePoint stie.

I've noticed all these values come from header of the request, so I can get them using following formula:

triggerOutputs()['headers']['x-ms-user-email']

but it's far from user friendly and regular users have no chance to know they can get it this way. (And especially if it works for regular SPO sites).

Does anyone else face same problem or is it problem of our tenant only?

[ScottShearer]

@Anonymous 

I believe this is a bug - I can replicate the behavior.  I am reporting it in the "I found a bug" forum.

[v-alzhan-msft]

Hi @Anonymous ,

I could reproduce this issue on my side, don't know if it is a bug or if it is by design.

I would report this issue to product team and would reply here once I get the answer.

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-alzhan-msft]

Hi @Anonymous ,

I got the answer that it is by design.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ScottShearer]

@v-alzhan-msft 

It seems odd that this behavior is by design.  Can you provide an explanation as to why it was designed in that manner and how it can be worked-around?

[v-alzhan-msft]

Hi @ScottShearer ,

Sorry for I don't get the explanation.

I'm just know this would be same in the button flow.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

@v-alzhan-msftI believe it's not by design, but bug. See what's coming in header. Everything is there. That property takes encoded value instead of decoded and that's bug.

@ScottShearerworkaround for now is to take decoded property from header directly instead of using User email property. You can use

triggerOutputs()['headers']['x-ms-user-email']

---

[Anonymous]

I somehow have 'User Email' property from 'For a selected file' working in one of my flows, but when I was creating another flow (copy the step to clipboard and paste it in new flow), User Email was giving me the encoded emails. Top solution worked as a workaround but pls fix I dont want more inconsistencies throughout 

[GamerTuku]

Exact same scenario for me too. Copied to clipboard and it failed to work in another flow. 

[mitquinn]

Its a header field so its Base64 encoded just use the decodeBase64() function to decode and you get the email.

decodeBase64(triggerOutputs()['headers']['x-ms-user-email'])

[Kake_Power]

I couldn't get this to work. I wanted to share what worked for me because I couldn't find this answer anywhere although I got the answer indirectly from the article Run a Flow Only When a SharePoint Item Changes – A Very Simple Solution – Scott J Shearer – M365 and... . I used the Modified By Email dynamic field in the To field. I'm sure that most of the people reading this need the more complex solution, but I wasn't sure if Modified By Email would work if the item was new. It does work.

[MichaelFlorer]

This worked for me, thanks! Just still confused as to why it was working earlier then suddenly broke...

[pragneshpatel]

Does anyone know how power automate get this header ? As we don't see that as part of network request, Also is there any official microsoft documentation for this ? How secure this header is or can we change this header in network request ?

x-ms-user-email