web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Remove record in Share...
Power Automate
Unanswered

Remove record in SharepointList and in SQL database from powerApp

(0) ShareShare
ReportReport
Posted on by 6

Hi,

 

I have a flow where I would like to remove items in a SharePoint list and also in an SQL server. I'm hitting issues there.

 

See below the details:

 

This is the SharePoint list: one column is called "ParseurItemID" which has unique values.

NickyD_1-1701432297940.png

 

I also have an SQL table where the ParseurItemID is recorded (might have duplicate, I can make sure there is no duplicate for the column ParseurItemID, but for the time being I would like to accommodate the ParseurItemID to have some duplication if possible)

NickyD_2-1701432559876.png

 

 

 

 

On a click of a "Button" below I would like to remove from the "ParseurItemID" in pink / purple below (it is in an editform, field called PaseurItemID_datacard1, and it's the datacardvalue10) in:

  • The sharepoint list "Purchase Invoices" (in yellow below)
  • The SQL table "Power_Automate_CSI_Purchase_Invoice_Auto_Processing" (in yellow below)

 

NickyD_6-1701433131535.png

 

 

 

To remove it from the SharePoint List I tried:

  • Remove('Purchase Invoices',LookUp('Purchase Invoices',ParseurItemID=DataCardValue10))
  • Remove('Purchase Invoices',LookUp('Purchase Invoices',ParseurItemID=DataCardValue10.Value))
  • Remove if as well.
  • and multiple other patch / remove from what I could find.

 

So far all my test failed ! If one of you has an advice on this it would be great.

 

Last but not least, if I want to alter the record and not delete it there is the patch function that I tried as well, without success neither. If you have a tip on the patch it would be great as well.

 

Thanks a lot to the community, as always !

 

NickyD.

 

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 331 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 203 Most Valuable Professional

Last 30 days Overall leaderboard