Must Read Connecting and using an On-Premise Gateway

Connecting and using an On-Premise Gateway

-

The WHY

There was a request to duplicate files from a SharePoint document library to a File Share. For this particular instance, I didn’t dive deep into the why but dived right into solutioning.

For testing purposes, I create an “instant flow” that would run when you told it to do so in order to streamline the testing. I quickly ran into issues where I was trying to connect to the On-prem Gateway but was not having much luck. Additionally, looking elsewhere on the interwebs for supporting documentation but found little to nothing about solving our connectivity issues.

Below is a step by step process on how to get your gateway to connect and use that with the File System connector.

The HOW

Download / Install gateway on the server (Link to On-Premise Gateway download)

The account you install the gateway with will be the one that is the admin. Open this connection within gateways in the power platform, and you can share this connection with others.

Create On-Prem Gateway including descriptive name

  1. Root folder (I took this from the path to the area where I wanted to store the file) be sure that you add a parent folder and not your select folder. I found small issues while navigating directly to the folder
  2. Windows as the authentication type
Machine generated alternative text:
File System 
Microsoft 
Display name * 
testfolder 1 
Root folder * 
C:\Users\aescobedo\Desktop\ 
Authentication Type 
Windows 
Username 
Cancel

Add your username, which would be the domain\user OR IP address\user. Both work and will be accepted. If this schema isn’t followed, the connection will say it passes but will not be successful.

Select the gateway you have installed.

Machine generated alternative text:
File System 
Microsoft 
Username 
52.252.240.114\aescobedo 
Password * 
Choose a gateway * 
TranferFile Testl 
If you don't see a gateway, or want a new one, you can install one 
now. To see recently installed gateways, refresh this list. 
Install a gateway 
Cancel 
CD

Creating a test flow to ensure this works:

Create an Instant Flow “Manually triggered Flow”

Add the action to Get file content from SharePoint. Navigate to any document you have read rights to within O365.

Add the Create file action and input the following:

Click the folder to navigate to your desired area

Type in a title and use the desired file extension. If you’re getting content of an excel file, type “.xslx” for a document type “.docx”

Insert the file contetn from the get file content step

Click Save

Machine generated alternative text:
Create fi le 
* Folder path 
* File name 
* File content 
C:Wsers\aescobedo\Desktop\testfolder 
sdfdsf.docx 
File Content x 
+ New step 
Save

Run flow and test.
I saw the file pop up instantly within my environment. I hope you do as well!

Helpful Links:
https://docs.microsoft.com/en-us/power-automate/gateway-reference
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-install

Must read

Webinar (Presenter): Microsoft Ignite Briefing: Top Tech Announcements

Each year Microsoft highlights the latest and greatest developments in tech at...

Microsoft 2021 Ignite Briefing (Presenter): Top Tech Announcements

Each year Microsoft highlights the latest and greatest developments in tech at Microsoft Ignite and this year’s...

Latest news

A Day in the Life of a Power Platform Admin

https://www.youtube.com/watch?v=IjGmMKowexw&list=PLqKBietJFMF0TAigxQxMV7tsfUssWIoPJ&index=6 Join this session to walk a day in a Power Platform...

Maximize Your Dynamics Investment with Power Platform

Your Dynamics 365 investment provides your organization with a robust toolset to...

Productivity and Microsoft Viva

Curious about the future of SharePoint now that #MicrosoftViva has arrived? Take a closer look at Microsoft Viva, the...

Using Power Apps, Power BI, and Power Automate Together

Using Power Apps Power BI and Power Automate together can unleash huge benefits and enhance your solutions....

Must Read

Using Power Apps, Power BI, and Power Automate Together

Using Power Apps Power BI and Power Automate together can unleash huge...

Power BI Version Control – Ready to use solution

Power BI Version Control is a free, fully packaged solution that lets...

Connecting and using an On-Premise Gateway

The WHY There was a request to duplicate files...