Error when saving email attachment to file system--> "Key 'gateway' not found in connection profile."

[runatyr]

Hello:

We have a web email account at outlook.office.com

I am trying to leverage Power Automate to log into the email account and save the attachments on the local machine. 

I found this template that says it will do this.

https://powerautomate.microsoft.com/en-US/templates/details/289f7f75e2ff4a3183cfd08064bdece6/save-em...

When I click on the template it brings up the web site make.powerautomate.com

I go in and configure the 2 steps.  1) Office 365 Outlook   and 2) File System

My file system step is configured for a desktop folder C:\Users\C\Desktop

and the 2 fields steps are already filled in (File name and file content)

When I test the flow, I get the following error on the "Apply to each" step

Key 'gateway' not found in connection profile.
clientRequestId: xxxxxxx-x-xf3-x   (hidden for post purposes)

What am I doing wrong and what do I need to fix??

What do I need to fix?

[dlikins]

me too

[Anonymous]

hi @runatyr  and @dlikins ,

maybe i found a possible solution to this. Unfortunately i can not test it myself, but at least provide the sources.

So you are using the "File System" Action "Create file". In the Documentation of the "File System" Connector it says it needs a "connection". This is probably due to safety, so not everyone can randomly create files on your computer.

This Doc can be found here:
https://learn.microsoft.com/de-de/connectors/filesystem/#creating-a-connection

From there it leads to the Documentation of the "On-premises data gateway". (https://learn.microsoft.com/en-us/data-integration/gateway/)
This is the crucial part i think.

You should first read over the "What is it..." and "FAQ" Section, before you go to the "install gateways" and "configure gateways" sections. This is due to safety. Because as i read the document, you have enter your real Windows-password and real Username...

If the gateway is set up correctly, i guess (and this is now really theoretically) that you have to insert a step between your first and your second step into the flow. 

For example:
1. When an email arrives (Stays as it is right now)
2. Connect to the gateway (new step)
3. "Apply to each" --> Create File (Stays as it is right now)

If this helped, please leave a reply.

Best regards

[dlikins]

It seems the Gateway is a connection from your hard drive to the cloud. IT recommended against this for some reason 🤔 I'd guess that is why you couldn't test it as well.

Creating an Outlook 'when new mail arrives' trigger worked better for this and using a custom folder with an outlook rule to only put the mail I want in this folder was the key for me. No connection necessary. Maybe this could help others too. 

[Anonymous · Accepted solution]

This is probably the better way. Much more safer, less complex and runs just as fast.

If this solution suits your problem then thats perfect.
For me personally, i needed the file in a VB.net Program. I eventually found a way to do that. If you or somebody else ever stumble accross such situation, you can extract the Content of an (.csv)-attachement using the "MemoryStream". For the File-Name you can use the "FileDescriptor", starting at bit 76.


Wish you the best.