web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Delete record in SQL s...

Power Apps

Unanswered

Delete record in SQL server table when same item is deleted in Attachments control

(0) Share

Report

Report

Posted on by msuser48

28

Hi,

I have a SQL server table, where I store images with their respective names.

In my Power App, I have an Attachments control, and a Gallery displaying the name of each attachment:

In the Attachments "OnRemoveFile" control, I want to delete the record in the SQL Server table.

So if I remove img_1.jpg from the attachments box, the record with the name "img_1.jpg" in the image_name column will be deleted in the database table.

How to achieve this?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @msuser48，

Could you please tell me if you want to delete a record including the attachment or just delete the whole record?

If you want to delete the whole record, you just need to use the Remove():

Remove( '[dbo].[YourSQLTable]', LookUp('[dbo].[YourSQLTable]', PrimaryColumn = ThisItem.PrimaryColumn) /* <-- Find the reocrd you want to update */ )

Was this reply helpful? Yes No

Join the conversation