Answered

Connector asking for credentials when launching app

(0) Share

Report

Posted on by SCTdan

604

I have a powerapp that utilizes a handful of flows. Two of those flows use the SFTP connector to upload attachments to a temp directory (attachment needs to be accessible via public URL for API connection to other app). When I launch the power app, I do not get prompted for SFTP credentials (since I created it I assume), however all my other users do .

Is there any way to pass/include those credentials so users do not have to enter them? There are no unique accounts here, and users do not need to know that password. Plus, you can't paste passwords into the powerapp prompt, nor can lastpass access it. Needless to say, entering the 16 character randomized password sucks, especially when you're out in the field and just need access to the app now.

Thanks

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

jhall 636 on at

Like (0)

Report
Copy link

Link copied!

I'm going to guess that comes down to how you're calling the Flows. If you were having a Flow fire on a system event vs. a user-requested one, then it would not require credentials other than your own.

PowerApps runs in the user's credential space. So when I'm running a PowerApps under my ID, it uses connectors and authentication that my user account retains.

If you wanted a generic system-level kind of account to do the SFTP for you, then you can either share your Flow w/ everyone in your org (ugh), or have the Flow that does the SFTP fire off on something other than the user request (e.g. a button within PowerApps) and instead fired on a system event (e.g. item created in SharePoint). This small change would have your Flow run under your credentials alone.

I actually did this same scenario recently to merge data entered in a form by a user w/ a PowerPoint deck. They submitted the data, the info was written to SharePoint, I then took the data and attachments, created a JSON doc of the data, SFTP'd it all to my custom app, merged the data, SFTP'd it back down and re-attached it to the SharePoint entry.

Was this reply helpful? Yes No
SCTdan 604 on at

Like (0)

Report
Copy link

Link copied!

That makes sense. This flow is kicked off by a user submitting or updating a form. I tested sharing the flow with another user and they reported they were still being asked though. Not an ideal solution anyways as you implied.

I was considering writing it to sharepoint first as a workaround, sounds like it's the way to go here.

Thanks for the input

Was this reply helpful? Yes No
hiteshn 61 on at

Like (0)

Report
Copy link

Link copied!

Hi Team,

I was stucked into this situation, where end user was asked the login to every connector in powerapp that are used in flows.
Providing access to the flow works, but I cannot give access to everyone in the organization.
What I did is removed "Provided by run only user" from the connections in power automate.

so it will use the specified connection only and will not ask the user credentials for the connectors.

Regards,
Hitesh

Was this reply helpful? Yes No