Answered

Power Apps IP restrict Internal user only

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Power Apps portals

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

v-xida-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

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,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

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,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

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-user-s-IP-address/td-p/462201

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,

Was this reply helpful? Yes No
OOlashyn 3,496 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

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.

Was this reply helpful? Yes No