For a selected file trigger - returned encrypted user email

(1) Share

Report

Posted on by hubertlam

153

I've created a Flow in which it uses the For a selected file trigger on a SharePoint Document Library.

It then tries to extract the email address of the user who triggered the Flow, however, the email address returned is encrypted!

Can anyone else replicate this?

Extract the email address of the user who triggered the Flow...email address returned is encrypted!

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

hubertlam 153 on at

Like (0)

Report
Copy link

Link copied!

OK - just found out that this is Base64 encoding:

Anyone know how to decode from base64 back into plain text?

Was this reply helpful? Yes No
hubertlam 153 on at

Like (0)

Report
Copy link

Link copied!

What the heck?!?! It's now working again.

Someone has been tweaking the encoding behind the scenes!

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @hubertlam ,

I'm afraid that the issue is caused by microsoft and now the issue has been fixed.

Since your problem has been solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

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.

Was this reply helpful? Yes No
bpe383 2 on at

Like (0)

Report
Copy link

Link copied!

It appears it's not fixed. Mine just started having this issue last week (10/11/2019)

Any suggestions.

Was this reply helpful? Yes No
kitUser 27 on at

Like (0)

Report
Copy link

Link copied!

I am currently experiencing this issue since yesterday, 10/29/2020. Anyone else having this issue?

Update: I was able to create a new flow as a work around for this issue. It is unfortunate to have to transfer all my actions to the new flow to resolve this issue.

Was this reply helpful? Yes No
calebmfoster 4 on at

Like (1)

Report
Copy link

Link copied!
I think I've found a work around as of 2/25/21:
How to avoid corrupt email attachment in Power Automate (tomriha.com)
I believe the formula snippet could be applied to other parts of the email as well
format: base64ToBinary([Attachments Content]) note: [Attachments Content] is a dynamic content when using in a flow, it could look like this: base64ToBinary(items('Apply_to_each')?['contentBytes'])

Was this reply helpful? Yes No
OliverR-82 623 on at

Like (3)

Report
Copy link

Link copied!
Thank you, this gave me the tip to look at decoding functions. The example you linked to is relevant when you're dealing with attachments. However, to decode the email address of the user who triggered a flow, you can do it slightly different:
decodeBase64(triggerOutputs()['headers']['x-ms-user-email-encoded'])
Hope this helps someone else in the future.

1 people found this reply helpful.

Was this reply helpful? Yes No
gullettb 21 on at

Like (0)

Report
Copy link

Link copied!

@OliverR-82 - I was experiencing this issue today and was able to resolve it quickly with the info you posted. Thank you!

Was this reply helpful? Yes No