Sharepoint on Premise with Power Automate?

[sarahpoulin]

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.

[chsanche · Accepted solution]

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,

[sarahpoulin]

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?

[chsanche]

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,

[sarahpoulin]

 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.