cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mfialek
Level: Powered On

New Entity from Data

Can I create a new entity with data from Azure database?  if yes, could I then write back to that database as well as the CDS?

 

2 REPLIES 2
Super User
Super User

Re: New Entity from Data

@mfialek 

No PowerApps cannot create a new table within an Azure SQL database.   To my knowledge, Flow can't do that natively either (but by all means you can go ask in that community). 

 

If you want to use code to generate tables in an Azure SQL DB PowerShell might be the way to go.  FYI, I have not done this myself.  Just wanted to point you in the right direction. https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-how-to-use-powershell.

 

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

Power Apps Staff Mr-Dang-MSFT
Power Apps Staff

Re: New Entity from Data

Hi @mfialek,

You can import data from SQL and many other sources into the Common Data Service.

 

Here's some quick steps and you can explore the areas relevant to you.

On the PowerApps Portal: 

Data > Entities > Get data

image.png

Search for SQL:

image.png

 

 

Here's what Azure SQL looks like:

image.png

 

The experience thereafter may remind you of Power Query.

 

Here's a blog post related to this ability: https://powerapps.microsoft.com/en-us/blog/cds-for-apps-march/

Older blog: https://powerapps.microsoft.com/en-us/blog/load-data-from-external-data-sources-to-the-common-data-s...

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (3,759)