web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Connectors / on premise gateway fai...
Power Automate - Using Connectors
Unanswered

on premise gateway fails when form based or sts auth is enabled along with windows auth

(0) ShareShare
ReportReport
Posted on by AmitLoh-Powerap 608

on premise gateway fails when form based or sts auth is enabled along with windows auth.

 

Categories:
General Questions
Connecting to Data
I have the same question (0)
  • v-micsh-msft Profile Picture
    v-micsh-msft on at
    Re: on premise gateway fails when form based or sts auth is enabled along with windows auth

    Hi @AmitLoh-Powerap,

     

    Could you please sahre more information about the "form based or sts auth is enabled along with windows auth" here?

    With which data source that you enabled this kind of authentication, and for what usage?

    Basically there is no need to enable authentication under Microsoft Flow side, the account information needed for authentication is verified when adding this connection under gateway, and will be stored with the gateway connection.

    For the errors, could you please check the error details first through the gateway logs?

    Understand on-premises data gateways or Microsoft Flow

    Please refer to the troubleshooting part mentioned in the article above.

    Please post back if you need any further assistance.

    Regards

  • AmitLoh-Powerap Profile Picture
    AmitLoh-Powerap 608 on at
    Re: on premise gateway fails when form based or sts auth is enabled along with windows auth

    In sharepoint central admin under authentication section please try sts or form based auth along side windows and check if gateway works(it does not). There are many scenarios(SSO, form based where STS and form based auth is required).

    Many onpremise implementations have SSO or adfs based sso or sts based sso in place at web app level. This gateway does not work in these scenarios and flow can not be used in those scenarios as of now. It only works when you have windows authentication is in place which is not every sharepoint project scneario.

  • v-micsh-msft Profile Picture
    v-micsh-msft on at
    Re: on premise gateway fails when form based or sts auth is enabled along with windows auth

    Hi @AmitLoh-Powerap,

     

    Thanks for your update.

    For SSO enabled on-premise data source, when choose using the gateway, would it be possible for you to enter the 

    "

    Oauth2

    "

    Under authentication type?

     

    I tried with my testing account and specify the authentication type as 'Oauth2', the connection created successfully under Microsoft Flow.Sorry to say that currently I don't have available on-premise SharePoint data source to perform a test, I can't confirm whether the connection would work. If convenient, please take a try to type the oauth2 in Authentication type, then create the SharePoint connection, see if this would make it work.

    For PowerApps, currently SharePoint on-premise only supports the Windows authentication (A dropdown with 'Windows' choice only).

    Regards

  • dimazaid Profile Picture
    dimazaid Microsoft Employee on at
    Re: on premise gateway fails when form based or sts auth is enabled along with windows auth

    hi @AmitLoh-Powerap!
    Could you help us clarify your scenario:

    Are you trying to use the gateway with sts auth connection? or are you trying to use Windows auth with the connection while having sts auth enabled on your SharePoint site? 

    Thanks in advance!
    Dimah

  • AmitLoh-Powerap Profile Picture
    AmitLoh-Powerap 608 on at
    Re: on premise gateway fails when form based or sts auth is enabled along with windows auth

    Great question!. I am trying to use windows auth when sts is enabled. I need to use either of the 2. Gateway works only when only windows is enabled. I think the sts/windows selection dropdown when sts is enabled in default kills the authentication. Please fix this.

  • dimazaid Profile Picture
    dimazaid Microsoft Employee on at
    Re: on premise gateway fails when form based or sts auth is enabled along with windows auth

    Got it! Thanks for clarifying. We'll look into this! 

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: on premise gateway fails when form based or sts auth is enabled along with windows auth

    There's no solution yet to this matter?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes happening today, December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans