I created a power automate flow that is triggered when an email arrives in a shared inbox (in Outlook). The flow will get an attachment on the email and create a file in a SharePoint document library that is a copy of that file. I have run into a problem though. Some of the attachments are protected by a password. The way that I know how to do this is to have Power Automate "create a file" in a SharePoint library where the file contents are the same as the contents of the file attached to the email
Or is there any other way I could possibly work around the password?
Solved! Go to Solution.
You can treat the file like any other file. Power Automate considers it a "bag of bits" that is saved somewhere. Here's a skeleton of what you need.
You can simply save it and then, the person who tries to open it, has to know the password.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
You can treat the file like any other file. Power Automate considers it a "bag of bits" that is saved somewhere. Here's a skeleton of what you need.
You can simply save it and then, the person who tries to open it, has to know the password.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
Thank you for your reply. It is going to be a little while before I can confirm if this works, but you have given me an idea. In the flow that I am using, I had to create an array of attachments and filter out the attachments that were part of the user's signature. I was using the output of the filter command. I think I can arrange it so that I can use the output from Outlook instead, while still filtering. I'm going to try this and see if it works.
So, this solution does work, but I didn't have all the information when I asked my question before, so when I implement this solution, it actually raises a different problem:
Thanks for your answer.
User | Count |
---|---|
27 | |
16 | |
15 | |
10 | |
10 |
User | Count |
---|---|
45 | |
29 | |
28 | |
24 | |
23 |