cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sarahpoulin
Helper I
Helper I

Sharepoint on Premise with Power Automate?

I have a flow where when I add columns to a Sharepoint list, it then will populate a document library and create or update an aspx page. I *need* the aspx page to be public facing. Or it be an html page and be public facing. I want to use this page in an iframe on a website (Weebly) so that it's dynamically updated from the Sharepoint list.  The html page just wants to be downloaded instead of it being actually viewed (when I make public), and I learned that aspx pages can't be made public ("no support").

 

Someone told me that apparently with Sharepoint on Premise, that I can have public aspx pages this way. I don't know anything about Sharepoint on Premise, and from my understanding, this is Sharepoint, but I install it on a server myself. So I attempted to install it on my Linux server, but am having trouble installing a later version of nodejs. So before I pull my hair out trying to do this, will I be able to access the Sharepoint server that I install on Linux from Power Automate? If I can't, then I won't bother trying to get it installed.

 

Also, I am open to other suggestions on how to dynamically update my Weebly site with Power Automate.

1 ACCEPTED SOLUTION

Accepted Solutions
chsanche
Microsoft
Microsoft

Hi @sarahpoulin 

 

Yes, but you will need an On-Premise Data Gateway. In order to access On-Premise Data sources with Power Automate, you need a gateway: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem. the Gateway can only be installed in a Windows machine, but you could install the gateway in a machine that has access to that SharePoint over the network. Also, please find there the available actions that Power Automate is able to perform in SharePoint: https://docs.microsoft.com/en-us/connectors/sharepointonline/#actions

 

Best Regards,

If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution

View solution in original post

4 REPLIES 4
chsanche
Microsoft
Microsoft

Hi @sarahpoulin 

 

Yes, but you will need an On-Premise Data Gateway. In order to access On-Premise Data sources with Power Automate, you need a gateway: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem. the Gateway can only be installed in a Windows machine, but you could install the gateway in a machine that has access to that SharePoint over the network. Also, please find there the available actions that Power Automate is able to perform in SharePoint: https://docs.microsoft.com/en-us/connectors/sharepointonline/#actions

 

Best Regards,

If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution

View solution in original post

I don't have a dedicated Windows machine to run the Gateway on 24/7. Is there another solution to have a public facing aspx page on Sharepoint online? Or a public facing html page that doesn't request to be downloaded (but will display it)? Or some other way to dynamically update a page on my Weebly site?

Hi @sarahpoulin 

 

We are only for Power Automate support, regarding that question will be better to reach the SharePoint team. Regarding the on-premise data gateway, there is no workaround for a Linux version.

 

Best Regards,

If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution

 Yes, I know you're Power Automate support. So I didn't know if there is some other solution to use Power Automate to update an external website. My thoughts were to use Power Automate to create a public aspx page and then display that page in an iframe on the external site, but I don't know what other solutions Power Automate may offer.

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (67,526)