Answered

File System Gateway but using same login for all users

(0) Share

Report

Posted on by Jsunnb

I have a PowerApp that is utilizing a Flow I created in Power Automate. This PowerApp will be used by many different users, however there is a part in the Flow where I'm using the File System Option with a Gateway to updated files on a network drive. I have access to update these files however, not all users will have this access.

I'd like my Flow to use my gateway login for all users instead of needing each user to setup the gateway to the Flow can update the file on their behalf. Is there a way to setup either the gateway connection to always be my login or the line in the Flow to use my login?

I'll show some examples below (with appropriate stuff blocked out) My suspicion is that I'm selecting Windows under Authentication Type and that is my problem. When I use MS SSMS I have two login options one is using Windows Authentication and the other is SQL Server Authentication (which I use to login with a special account that can make changes). So I'm wondering if I need to get our IT Admin to modify so I can possibly login as a different authentication than Windows (Windows is my only option currently)

If I'm on the right track, could someone please send me a screenshot of what I'd be expecting for that Gateway, our IT isn't always up to par on the Power Platform stuff and I might need to guide them in the right direction.

Connector Setup.png Connector Screenshot.png

Categories:

Using connectors

All responses (4)

Answers (1)

Sort by

Jsunnb 61 on at

Like
a
(0)

Report
Copy link

Link copied!

After some digging around in the documentation, I found what I'm wanting to do with File System isn't possible.
https://learn.microsoft.com/en-us/connectors/filesystem/

So I guess my next question is if there is a different way of accomplishing the same thing without using File System? I see SharePoint has this feature, but unfortunately my files are in SharePoint. Thank you in advanced for your help!
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jsunnb ,

Although the connection cannot be implicitly shared, we still have a way to do it. The key is to add another flow.

Sample:

Best Regards,

Wearsky
Jsunnb 61 on at

Like
a
(0)

Report
Copy link

Link copied!

So I had never heard of doing the "When an HTTP request is received" trigger, so I looked it up and I think I see how it is supposed to work. Basically, using JSON you can pass information between two flows.

However, I'm still a bit confused how this solved my issue, unless it is PowerApps itself that is requiring the user to sign in.
Would I need to share that new flow with each person and how would that prevent them from having to have their own sign-in?

I'll try some tests to see if I can get it to work like I think it should but let me know if I'm missing any steps.
Jsunnb 61 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msft , I think I'm close to getting it to work. I'm using header to make my "variables" to transfer my data, but is there a limit on how long a header can be?