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

Power Apps IP restrict Internal user only

Hello everyone,

 

We are developing a PowerApp with IP restrict internally so no one can access outside organisation. Our database is in SQL so we implemented PowerApps data gateway to access SQL in to canvas app so my question is

how we can restrict Power Apps internally so only allowed people can access the app within the organisation network only and uses SQL server as data source for the App?

 

Any help would be appreciate it.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @asif082 ,

Yeah, you are right. You could consider switch your SQL Table data source to CDS, then it could achieve your needs.

 

Currently, within PowerApps, there is no way to restrict the access to a canvas app connected to SQL Table by IP Address.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
OOlashyn
Super User
Super User

Hi @asif082 ,

 

If you are referring to power apps portal there is an official documentation on how to restrict portal by IP address. You can find it here.

If you are referring to model driven power app you can check out this article . Regarding Canvas App I am not sure.

If it is about regular power app (not portal) try to post it to Power Apps Governance and Administering forum.

----------------------------------------------------
If you find this post helpful consider marking it as a solution to help others find it.
v-xida-msft
Community Support
Community Support

Hi @asif082 ,

Do you want to restrict your canvas app from being only accessed from your Org Network?

 

If you want to restrict your canvas app from being only accessed from your Org Network, I afraid that there is no way to achieve your needs in PowerApps currently.

 

The user @LeonSig has faced similar issue with you, please check the response within the following thread:

https://powerusers.microsoft.com/t5/Power-Apps-Governance-and/Restrict-access-to-PowerApp-based-on-u...

 

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks Kris, yes we can only use canvas app due to on Prem SQL Server so just to confirm even if we create new environment in Power Apps we cannot restrict single app with IP address using Power apps portal? 

Hi @asif082 ,

Do you embed your canvas app in your PowerApps Portal?

 

If you embed your canvas app in your PowerApps Portal, you could consider restrict the access to the Portal based on IP Address. Please check and see if the following article would help in your scenario:

https://docs.microsoft.com/en-us/powerapps/maker/portals/admin/ip-address-restrict

 

If you just want to restrict the single canvas app (connected to On-premises SQL Server Table) from being accessed based on IP Address, I afraid that there is no way to achieve your needs in PowerApps currently.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks Kris, no we don't have power apps platform but we are considering to buy if it can block outside organisation access. But the problem is we have to use on prem SQL which contains data and with that we can only use Canvas app.

 

So I believe without switching to CDS we cannot restrict the Canvas app which is currently connected to SQL as a data source, right?

 

Regards,

Asif

Hi @asif082 ,

Yeah, you are right. You could consider switch your SQL Table data source to CDS, then it could achieve your needs.

 

Currently, within PowerApps, there is no way to restrict the access to a canvas app connected to SQL Table by IP Address.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,606)