Connecting From Powerapps to Azure SQL and CRUD operations

(1) Share

Report

Posted on by CU23101553-0

Hi, I imported an Excel file to Azure SQL. And i would like to access that table to PowerApps from Azure SQL.

So at the connections in PowerApps I used From SQL, and what I have to fill in the authentication type tenant client ID and Client secret I dont know. And which authentication I have to use also I am not sure. I just started Powerapps a day ago. Could you please give suggestions how could I solve this this. (And for Azure SQL I used Microsoftentra MFA authentication), So at the authentication type in Powerapps to connect to AzureSQL can i use Microsoft Entra ID application or other authentications?

Que 2) After getting the table into PowerApps how could I acheive below scenario - The user should be able to add the data for new columns
- The user should be able to add a new record to the dataset (including above new columns)
- The user should be able to update an existing record in the dataset. This update should be logged with history
- When a new record is added or a record has been updated.

Could you please provide any suggestions links , that will be helpful.

Thanks in advance.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi CU23101553-0,

You can definitely perform CRUD operations in Power Apps. Once you've connected your SQL tables with Power Apps using the SQL connectors, you can perform the CRUD operations by modifying the following codes:

CREATE

Patch(SQLTABLE, Defaults(SQLTABLE), { Column1: Value1, Column1: Value1, Column1: Value1, so on.. })

READ

LookUp(SQLTABLE, ID = 1) //to read the whole record LookUp(SQLTABLE, ID = 1).ColumnName //Use this to get a value from a column

UPDATE

Patch(SQLTABLE, LookUp(SQLTABLE, ID = 1), { Column1: Value1, Column1: Value1, Column1: Value1, so on.. })

DELETE

Remove(SQLTABLE, LookUp(SQLTABLE, ID = 1))

What history are you trying to capture?

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Nandit 1,568 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

Following up to check if my suggestion was helpful?

Kind regards,
Nandit

Was this reply helpful? Yes No