Power Platform Community Forum Thread Details

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.

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)

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)

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:

General topics